How to connect Business Central to Azure Data Factory

Question

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?

Answer 1

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:
   
   
   the service URL example https://api.businesscentral.dynamics.com/v2.0/xxxxxxxxx-6592-46f6-ba60-xxxxxxxx/Benben10-Live/ODataV4/
   
   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

Answer 2

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 or upvote 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