Implementing Microsoft Dynamics 365 for Finance and Operations Apps - Second Edition

Entity store in Azure Data Lake

To bring the Finance and Operations data to the modern data warehouse architecture, Finance and Operations has introduced a new feature that allows us to move the Entity store that was previously in the Azure SQL database to a customer's own Azure Data Lake. Setting up Entity store integration with Azure Data Lake is a simple one-time setup that can be done under System parameters, as shown in the following screenshot:

Once this feature has been enabled, aggregate measurements are staged in Azure Data Lake in CDM folder format. The Azure Data Lake integration feature also supports incremental exports, which ...