Azure Synapse and D365 Business Central integration

Ganeo Davide 10 Reputation points

Hi all,

we are looking for the best way to read entire tables from D365 Business Central (full cloud) using Azure Synapse Analytics. Our goal is to have each table exported inside the azure data lake so they can be used as data source for the data warehouse (in a similar way of "Export to Azure Data Lake" add-in for D365 for Finance & Operations).

Thanks for your help!


Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,118 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,281 Reputation points Microsoft Employee

    Hello @Ganeo Davide ,

    Thanks for the ask and wlcome to Microsoft Q&A .

    I think you can push the D365 Business central entites to Dataverse ( you can refer to the doc : [ ) once the data is in dataverse , you can use Synapse link to . [