Article

Why Azure Synapse Link for Dataverse improved the Dynamics 365 data analysis story

by Kirk Donahoe
Director of Pre-Sales, Business Analytics & Power Platform, MCA Connect

As expected, many exciting announcements came out during Microsoft Build 2021. The announcement that caught my attention most was the preview release of Azure Synapse Link for Dataverse. This service will allow simple configuration to continuously export your Dataverse data and metadata to your own data lake.

In conversations with others in the Dynamics 365 CRM/CE community, some have mentioned that this functionality feels like a rebrand of the ‘Export to Data Lake’ functionality that has been available for quite a while now, and I partially agree. 

The capabilities announced at this year’s Build add another extremely beneficial layer on top of the previous functionality: the automatic linking of the configured storage account with Azure Synapse Analytics and the creation of T-SQL views in the Serverless endpoint that queries from the data lake. This additional layer greatly simplifies the process of accessing your data to create a Logical Data Warehouse through writing additional SQL Views or through other Azure services including Azure Machine Learning and Azure Cognitive Services.

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access
Azure BI and Reporting Customer Engagement Data Integration Data Warehousing Databases Dataverse (CDS) Dynamics 365 Dynamics CRM Power Apps Power Platform
About Kirk Donahoe

Kirk Donahoe is the Director of Pre-Sales, Business Analytics and Power Platform for MCA Connect. Prior to this role he was the Solution Architect over forty implementations of MCA Connect’s DataCONNECT solutions for Microsoft Dynamics AX/365 Finance and Operations or Dynamics 365 CRM/CE; of which he was the original developer. He has over eighteen years’ experience in technology. Kirk earned his B.B.A. in Business Information Systems from Mississippi State University and his M.S. in Management Information Systems from the University of South Florida. He can be contacted through LinkedIn at https://www.linkedin.com/in/kirkdonahoe/.

More about Kirk Donahoe