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!!