Overview of data integration 2020 release wave 2
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
The data integration team's vision is to democratize data integration for business users so it's seamless to extract, transform, and load data into Microsoft Dataverse and Azure Data Lake Storage from any data source, and to allow other Microsoft products to take advantage of this data.
We're investing in a few key pillars:
Microsoft Power Platform dataflows: Power Query is the industry-leading smart data prep tool, and evolves by infusing AI and machine learning into data transformations and by extending dataflows to all of Microsoft Power Platform.
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 algorithms.
Enhanced data integration enables analytics on Dataverse data through Export to Data Lake in Common Data Model form, Office data integration to enable new insights, new and enhanced connectors, and improvements in the connectivity platform; extends dual-write for more entities; improves Data Export Service; and enhances the gateway for enterprises and robotic process automation (RPA).
Gateway and Azure Virtual Network connectivity in Microsoft Power Platform will allow enterprises to scale out their cloud-to-cloud integrations without using the gateway, removing complexity and administration effort in building a true, democratized data platform.