Connect Azure Data Factory to Business Central

ADF (Azure Data Factory) does not have a default connector with Business Central such as Dynamics AX and CRM, but it can be invoked using the REST connector.

In the example I will describe we will import Item from Business Central to an Azure Blob Storage, creating a .csv file, using ADF.

We create an Azure Blob Storage called datafactory.

We create on our ADF a new pipeline.

From the Move & transform folder we drag the Copy Data object into the pipeline.

Now we create two new Datasets:

First dataset: ItemAPIBC

Name: ItemAPIBC

Base Url: https://api.businesscentral.dynamics.com/v2.0/Mytenant/MyEnviroment/api/v2.0/companies(CompanyID)/items

Authentication type: Oauth2 CLient Credential

Token Endpoint: https://login.microsoftonline.com/MyTenant/oauth2/v2.0/token

Client ID: My :client id of my app registration

Client Secret: client secret of my app registration

Scope: https://api.businesscentral.dynamics.com/.default

Perform a connection test by setting the Base URL: https://api.businesscentral.dynamics.com/v2.0/Mytenant/MyEnviroment/api/v2.0/companies(CompanyID)/items

Second Dataset: StorageCSV

At this point we are going to parameterize our Copy Data in the Pipeline.

We parameterize the origin in this way, associating it with the dataset that calls the Business Central API:

We parameterize the sink in this way, associating it with the dataset of our Azure Blob Storage

We map the fields of our interest that we want to export to our .csv file like this:

At this point I can launch debug to manually export the file

Let's go and check the correctness of our extraction:

On Business Central:

On my Azure BLob Storage

and the game is done!!