Overview of Common Data Model and data integration 2019 release wave 2

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Our vision is to democratize data (integration) for business users, so that it is seamless to extract, transform, and load data into Common Data Service and Azure Data Lake Storage from any data source, and to provide structure and meaning to that data through the Common Data Model. To achieve this vision, we are investing in three key pillars:

  • Common Data Model: Establishes industry-wide structure and semantics of underlying data so that customers can then reason about that data through various business application solutions, analytics, and machine learning (ML) algorithms. In this milestone, we will extend the reach of the Common Data Model through SDKs and object models to support developers and partners, better in-product experiences, and more.
  • Power Platform Dataflows: Power Query is the industry-leading smart data preparation tool and evolves by infusing AI and ML into data transformations, and by extending dataflows to all of the Microsoft Power Platform.
  • Enable analytics on Common Data Service data: Enhanced data integration through Office data integration, new and enhanced connectors, improvements to the connectivity platform, extending Dual Write, improving the data export service, and enhancing on-premises gateways for enterprises.

Here are the themes and guiding principles for our investments in this milestone:

  • Improved fundamentals and engineering excellence

    • Security, reliability, performance, compliance, supportability, and efficiency

  • Remove enterprise blockers

    • Services are deployed to every geography with a Hero or Hub region.
    • Enterprise connectivity asks: For example, guest access, Excel data, and SAP

  • Improved and intelligent data integration

    • Power Platform Dataflows
    • Enable analytics on Common Data Service data
    • Smart data preparation
    • Common Data Model and the Open Data Initiative

  • Make our partners successful