Share via

Synapse Link for Dataverse includes finance and operations data

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to Microsoft Dataverse documentation. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts Jul 17, 2023 Oct 16, 2023

Business value

All Dynamics 365 customers, including customers who use finance and operations apps, can work with their data in Azure Synapse Analytics using a single, integrated experience built into Microsoft Dataverse. Choose data from all Dynamics 365 apps, including finance and operations, and Dynamics 365 Sales, Service, and Marketing apps within a single integrated experience. Customers and partners can also leverage advanced features in Synapse Link for Dataverse, including support for restricted storage accounts as well as parquet format and Delta Lake. Customers who currently use the export to data lake feature in finance and operations can plan migration to Synapse Link for Dataverse.

Feature details

Microsoft Azure Synapse Link for Dataverse lets you choose data from finance and operations apps. Use Azure Synapse Link to continuously export data from finance and operations apps into Azure Synapse Analytics and Azure Data Lake Storage Gen2.

Azure Synapse Link for Dataverse is a service that's designed for enterprise big data analytics. It provides scalable high availability together with disaster recovery capabilities. Data is stored in the Common Data Model format, which provides semantic consistency across apps and deployments.

Azure Synapse Link for Dataverse offers the following features that you can use with finance and operations data:

  • Choose both standard and custom finance and operations entities and tables.
  • Continuous replication of entity and table data is supported. Create, update, and delete (CUD) transactions are also supported.
  • Link or unlink the environment to Azure Synapse Analytics and/or Data Lake Storage in your Azure subscription. You don't have to go to the Azure portal or Microsoft Dynamics Lifecycle Services for system configuration.
  • Choose data and explore by using Azure Synapse. You don't have to run external tools to configure Synapse Analytics workspaces.
  • All features of Azure Synapse Link for Dataverse are supported. These features include availability in all regions, saving as parquet delta files, and restricted storage accounts.
  • The table limits in the Export to Data Lake service aren't applicable in Azure Synapse Link for Dataverse.
  • By default, saving in parquet delta lake format is enabled for finance and operations data, so that query response times are faster.

See also

Choose finance and operations data in Azure Synapse Link for Dataverse (docs)