Hello is there a connector that can be used to extract data from BC to Azure Data Factory? I know there is one for F&O (AX) as well as specific D365 CRM apps.
Yes, for Business Central, there isn't a native Azure Data Factory (ADF) connector like there is for F&O or CRM, but you can use the OData feed from Business Central as a source in ADF.
🔹 Steps:
1. In Business Central, expose the data via OData Web Services.
2. In ADF, use the OData connector to connect to BC using the generated OData URL.
3. Authenticate using OAuth 2.0 (with Azure AD app registration).
This setup lets you extract data from BC into ADF for further transformation or loading into other systems.
Mark below checkbox to make this answer Verified if it helps you.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
241
Share
Report
All responses (
Answers (
