Data Integration with Azure Synapse Link for Dataverse
Configuration & Using Azure Synapse with Power Platform
I am going to show you how you can use Azure Synapse Link for Dataverse to connect your Microsoft Dataverse data to Azure Synapse Analytics.
What is Azure Synapse Analytics?
It is an analytics service - part of Azure ecosystem that makes it easy for you to query data on your terms, using either serverless or dedicated resources—at scale.
Azure Synapse Link for Dataverse
Azure Synapse Link for Dataverse is a functionality in Power Platform that enables you to get near real-time insights over your data in Microsoft Dataverse. With a few clicks, you can bring your Dataverse data to Azure Synapse, visualize data in your Azure Synapse workspace, and rapidly start processing the data.
When this is configured, it takes a copy of the Dataverse date and put in data lake to make it available for integration, analytics, etc.
This data replica is auto updated with new records and every updates & deletes are reflected.
With this data, we can do custom analysis, integration using data pipelines (like you would do in SSIS) and also analytics by leveraging its native integration with Power BI.
Let’s get started with the steps:
Create Azure Synapse Analytics Workspace in Azure.
Login to Azure Portal
Navigate or search for Azure Synapse Analytics.
Click on create
Fill the create form as shown below:
Finish this process and wait for the deployment to be complete:
Go to your maker studio: make.powerapps.com
Make sure to be in the right environment and tenant
Click on Azure Synapse Link on the left side as shown below.
Click on New Link button.
Fill the wizard as shown below:
Click Next
Select the tables to export to Azure Synapse
Click on Save to finish the wizard
Wait for the process to complete, it takes some minutes depending on the size of your data.
When it is complete, we can see our newly created Azure Synapse Link as shown below:
Click on it to see the synchronized tables:
Azure Synapse Analytics Workspace
From the above screen, click on Go to Azure Synapse Analytics Workspace to see your Dataverse data in the workspace.
In the above screen, you can see a query result showing account records from dataverse.
We can perform any kind of analytics and manipulation on this data.
Conclusion
We have seen how to use the Azure Synapse Link for Dataverse to bring data from Dataverse into Azure Synapse Analytics and work on them in the workspace.That’s all for today.