Forum Discussion

lovishsood1's avatar
lovishsood1
Copper Contributor
Feb 04, 2025

OData Connector for Dynamics Business Central

Hey Guys,

 

I'm trying to connect Dynamics Business Central OData API in ADF but I'm not sure what I'm doing wrong here because the same Endpoint is returning data on Postman but returning an error in ADF LinkedService.

https://api.businesscentral.dynamics.com/v2.0/{tenant-id}/Sandbox-UAT/ODataV4/Company('company-name')/Chart_of_Accounts

 

 

azure data factory
Azure ETL
Azure Integration Runtime
Copy Activity
Linked Service
  • dfkconsult's avatar
    dfkconsult
    Brass Contributor
    Feb 24, 2025

    Checkout these posts

     

    https://learn.microsoft.com/en-us/answers/questions/1538522/how-can-i-connect-to-bc-using-adf-with-odata-api

    https://learn.microsoft.com/en-us/answers/questions/1858160/business-central-connector-for-azure-data-factory

    https://community.dynamics.com/forums/thread/details/?threadid=ddd7a24f-654e-4f02-b656-c0772a55e8bd

    https://www.encorebusiness.com/blog/how-to-use-an-odata-connection-with-service-principal-authentication-for-dynamics-365-business-central/

    https://stackoverflow.com/questions/76411322/how-to-use-azure-data-factory-to-take-business-central-data-and-put-into-azure-s

    https://www.linkedin.com/pulse/azure-data-factory-configure-linked-service-business-central-nguyen-6ga7c

     

Resources