This presentation examines the structure of the Common Data Model (CDM) in Azure Data Lake when extracting data from Dynamics 365 (D365) using Azure Synapse Link, based on a real-life project.

Key topics will include:

CDM Organization in Azure Data Lake: Details on how files and folders are arranged in the Data Lake, including the use of change files for incremental data loads.

Technical Columns from Synapse Link: An overview of important technical columns generated during the export process and their role in ensuring data integrity.

Loading Strategies for Lakehouse Architectures: Effective methods for loading data into lakehouse environments such as Databricks and Microsoft Fabric.

Lessons Learned: Key insights and challenges faced during the project, providing practical takeaways for implementation.

This session will provide a clear understanding of the CDM's organization and practical strategies for using Azure Synapse Link in data management and analysis.