How to connect Business Central to Azure Data Factory

Anonymous
2022-02-26T12:37:04.963+00:00

I posted this question on Re: [MicrosoftDocs/azure-docs] Business Central Connector (Issue #88574)

But that didn’t help.

Is it actually possible to connect Business Central to ADF?

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,351 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ben Zhai 6 Reputation points
    2022-03-09T16:45:40.367+00:00

    I have the same question, we used to be able to use the web service authentication method + OData to access the BC cloud data, namely: user name + web service access key. But recently, MS decided to deprecate this method. the alternative is to use the AAD service principle and key.

    1. Find the OData URL, e.g. : https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxx-6592-46f6-ba60-xxxxxxxxxxxxx/Benben10-Live/ODataV4/Company('Benben10')/bin
    2. Setup a linked service in a data factory or synapse using an OData connector. fill the details as follows:
      181478-application-details-li.jpg
      181535-odata-connection-method-li.jpg
      the service URL example https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxx-6592-46f6-ba60-xxxxxxxx/Benben10-Live/ODataV4/
      181510-odata-connector-li.jpg
      here is a super detailed web page to create a service level credential for access BC with out using Office 365 user name and password authentication.
      https://vjeko.com/2019/02/16/how-do-i-really-set-up-azure-active-directory-based-authentication-for-business-central-apis/#comments
    1 person found this answer helpful.
    0 comments
  2. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2022-03-01T20:05:35.75+00:00

    Hello @Anonymous ,
    Thanks for the question and using MS Q&A platform.

    As we understand the ask here is how to connect to ADF from Business central , please do let us know if its not accurate.
    Since you are asking about the connecting option from Business central to ADF , I think a better place to ask this here : https://community.dynamics.com/
    Just wanted to share that ADF does have some option to connect to Dynamics , please do read more about the same here : https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory

    <<< quick extract from the above article >>

    This article outlines how to use Copy Activity in Azure Data Factory and Synapse Analytics pipelines to copy data from Dynamics AX source. The article builds on Copy Activity, which presents a general overview of Copy Activity.

    Please do let me if you have any queries.
    Thanks
    Himanshu

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments