Connect from DataLake to Dataverse and setup sync of the data

Question

Hello Everyone ,

Some Background Info : How to connect Azure Data Lake to Data verse and setup sync of the data. Kindly help on possible method to achieve above.

Answer 1

There is a great MS docs page on how to do this set up please see -
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse

Answer 2

Hi @Rameshbabu C ,

Thank you for posting query in Microsoft Q&A Platform.

You can move data from Data lake to Dataverse easily using Dataverse connector in Azure Data factory pipelines or Synapse Pipelines.

Use copy activity with source as Data lake dataset and sink as Dataverse dataset. Please check below link that has detailed documentation of using Copy actiivty for Dataverse.
Copy and transform data in Dynamics 365 (Microsoft Dataverse) or Dynamics CRM using Azure Data Factory or Azure Synapse Analytics

Below are few useful resources to understand about Copy activity:
Copy Data Activity in Azure Data Factory
Copy activity in Azure Data Factory and Azure Synapse Analytics

Between, we can consider use Synapse link also for exporting data from dataverse to ADLS gen2. Please check below link.
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake

Hope this helps. Please let us know if any further queries.

------------

Please consider hitting Accept Answer. Accepted answers help community as well.