Azure Synapse and D365 Business Central integration

Ganeo Davide 0 Reputation points
2023-01-13T14:17:38.87+00:00

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!

Davide

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.
2,625 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 17,721 Reputation points Microsoft Employee
    2023-01-16T18:51:50.08+00:00

    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 : [https://learn.microsoft.com/en-us/dynamics365/business-central/admin-common-data-service ) once the data is in dataverse , you can use Synapse link to . [https://learn.microsoft.com/en-us/power-apps/maker/data-platform/export-to-data-lake

    Thanks
    Himanshu