Enable Common Data Service entities for analytics


These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review What’s new and planned for Common Data Model and Data Integration. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Our vision is to empower our customers to gain comprehensive insights and drive business actions based on their data in Common Data Service. To be able to achieve this, to run analytics and extract intelligence from your data, there is a need to push the data to Azure Data Lake, which enables best-in-class analytics performance along with the fundamental availability, security, and durability capabilities of Azure Storage. With this effort, we will enable first-party analytics apps to run rich analytics by pushing data from Common Data Service to Azure Data Lake. Additionally, we will also support Bring your own lake/Bring your own storage functionality where customers can link their existing Azure Data Lake to their Common Data Service environment. This will enable customers to run rich analytics on their Common Data Service data.

Common Data Service to ADLS

Extract intelligence from your Common Data Service data through first-party analytics apps

If you are a salesperson interested in the complete interaction history of a customer, a sales manager looking to gain insights into your team, or a customer service manager looking to anticipate needs and improve performance with insights into case trends, our first-party analytics apps such as Dynamics 365 Customer Insights, Sales Insights, and Customer Service Insights lets you do just that. This feature lets you hydrate Azure Data Lake with your Common Data Service data to avail of rich insights driven by empowering first-party analytics apps.

Frictionless experience to connect and hydrate your Azure Data Lake Storage

With this feature, you can easily bring your own Azure Data Lake (or, we will create one for you), link to your Common Data Service environment, and select Common Data Service entities to hydrate the lake. This gives you the ability to create rich reports using Power BI and other powerful analytics and Machine Learning services.

Support for initial and incremental writes

This feature enables writing existing and incremental Common Data Service data to the lake. Customers don’t want a full copy of their data at every refresh and it is imperative that we support this critical ask for incremental data refreshes.

Support for data and metadata changes in the Azure Data Lake

We understand that, with every business, data is constantly changing, and we will provide complete support for data and metadata changes to propagate to the Azure Data Lake along with support for CRUD (Create Read Update Delete) operations.