Extraction of Business Central data via ADF

Question

Hi,

I have seen across multiple forums/documentations but unable to get a scope of how to extract Business Central data from ADF.

Can someone guide me on this ?

Note : We do have some custom tables also created in BC of which we need to also extract data

Answer 1

You can leverage REST API for data extraction :

https://sites.google.com/view/daniele-incalza/logbook/connect-azure-data-factory-to-business-central

My understanding is for custom tables you would have to create the APIs yourself

Answer 2

To extract data from Business Central using Azure Data Factory (ADF), you can utilize the Azure Data Factory OData connector. This connector allows you to connect to Business Central APIs and extract data, including data from custom tables that you have created in Business Central.

Here are the steps to guide you through the process:

1. Set Up Azure Data Factory: Ensure you have an Azure Data Factory instance set up in your Azure portal.
2. Use the OData Connector: In Azure Data Factory, create a new linked service using the OData connector. You will need to provide the necessary authentication details, such as service principal authentication, to connect to Business Central.
3. Create Datasets: After setting up the linked service, create datasets that point to the Business Central APIs. For your custom tables, ensure that you have the appropriate API endpoints available to access the data.
4. Build Pipelines: Create pipelines in ADF that utilize the datasets to extract data. You can schedule these pipelines to run at specific intervals or trigger them based on events.
5. Transform and Load: Once the data is extracted, you can perform any necessary transformations within ADF before loading it into your desired destination, such as a data warehouse or data lake.

For more detailed information on using Azure Data Factory with Business Central, you can refer to the documentation on the Azure Data Factory OData connector and how to connect Business Central to Azure.

---

References:

• Extract data from Business Central
• Azure Data Factory OData connector