Dynamics 365 Finance
Category
Sep 12, 2024
Published date
Text
Article Type
AI Summary
- Microsoft is deprecating the Export to Data Lake feature in Dynamics 365 Finance & Operations as of October 15, 2023.
- The new solution recommended by Microsoft is Azure Synapse Link, which offers more robust features like Delta Table functionality.
- Transition options include exporting to Azure Data Lake in CSV format, exporting to Azure Data Lake in Delta Parquet format, or exporting to OneLake with Microsoft Fabric.
- Exporting to Azure Data Lake in CSV format requires using Azure Synapse Link instead of the old CDMUtil tool, but watch out for storage costs and integration complexity.
- Exporting to Azure Data Lake in Delta Parquet format offers better performance and scalability but comes with higher costs and technical complexity.
- Exporting to OneLake with Microsoft Fabric is the most integrated option, minimizing the need for manual data conversion processes, but has limited support beyond D365 F&O and CE entities.
- It is advised to start planning the migration now, test out different options in a sandbox environment, and consult with IT and data teams for a smooth transition.
- The article also includes a dad joke about data files going to therapy for having CSV issues and provides additional resources for further reading.
Registered users can view the full text for FREE!
Sign In Now!