Business Central Connector for Azure Data Factory

Andrew Hairston Cloud 0

Is there a connector that can be configured to allow data to be extracted from Business Central into Azure Data Factory? Please do not confuse my query for AX or Finance and Operations.

Apoorva Belsare 0 Reputation points

2024-09-04T11:51:49.4733333+00:00

I am able to connect to Business Central using dynamics 365 but in entities it does not list the tables or API in business central instead gives Entities like 'ACIViewMapper (aciviewmapper)'

1 answer

Pinaki Ghatak 4,610 Reputation points Microsoft Employee

2024-08-09T08:26:51.89+00:00

Hello @Andrew Hairston Cloud

Yes, there is a connector available for Azure Data Factory that allows you to extract data from Business Central. The connector is called the "Dynamics 365 Business Central connector" and it can be used to extract data from Business Central into Azure Data Factory.

To use this connector, you will need to create a linked service in Azure Data Factory that connects to your Business Central instance. You can then use this linked service to create pipelines that extract data from Business Central and load it into other data stores or data processing services in Azure.

Here is a link to the official Microsoft documentation that provides more information on how to use the Dynamics 365 Business Central connector in Azure Data Factory: https://docs.microsoft.com/en-us/azure/data-factory/connector-dynamics-365-business-central

I hope that this response has addressed your query and helped you overcome your challenges. If so, please mark this response as Answered. This will not only acknowledge our efforts, but also assist other community members who may be looking for similar solutions.
Please sign in to rate this answer.
Andrew Hairston Cloud 0 Reputation points

2024-08-09T18:46:10.7133333+00:00

@Pinaki Ghatak please click on the link you shared. It does not go to any documentation. Please advise.

Smaran Thoomu 16,735 Reputation points Microsoft Vendor

2024-08-12T17:54:30.2533333+00:00

Andrew Hairston Cloud - Here is the correct link for the Microsoft documentation that provides more information: https://video2.skills-academy.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory

Andrew Hairston Cloud 0 Reputation points

2024-08-13T12:04:58.0433333+00:00

@Smaran Thoomu but where specifically does it mention Business Central? I've seen that learn document and it mentions AX and CRM Engagement Apps. Can you be more specific?

Smaran Thoomu 16,735 Reputation points Microsoft Vendor

2024-08-13T14:16:37.13+00:00

Andrew Hairston Cloud Sorry for the confusion with the previous links. Here's a similar request—could you please take a look?
Similar thread
Business Central Connector #88574

I hope this helps! Let me know if you have any further questions.

Smaran Thoomu 16,735 Reputation points Microsoft Vendor

2024-08-14T17:11:48.8133333+00:00

Andrew Hairston Cloud Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

Andrew Hairston Cloud 0 Reputation points

2024-08-15T11:09:42.4966667+00:00

@Smaran Thoomu Hi, but no, it's not helpful. Has there been any validation with this type of connection?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Business Central Connector for Azure Data Factory

1 answer

Your answer