Microsoft Dynamics 365 Blog Posts & Articles by DynaTech Systems

Wy to Switch to Azure Synapse Link - Dynatech Systems

Written by Payal Oza | Dec 26, 2022 12:02:17 PM

If your Dynamics 365 environment, including its integrations, reporting, and/or BI, is consistent with the data stored in a SQL database that is still filled by the Data Export Service (DES), the end of life of DES in November of this year must have had a negative impact on your system.

Customers that use the Microsoft Data Export Service (DES) to migrate data into Azure from Dynamics 365 and Power Platform have already run out of time. Microsoft deprecated DES in November of last year. Although the service is still operational for existing clients, it is no longer available to new subscribers and will no longer be maintained when it reached end-of-life status in November.

In today’s blog article, we’ll discuss the end of life for Microsoft Dynamics 365 DES, how it will affect your company, and how we can assist you minimize system interruptions!

Differentiate between Depreciated vs End of Life

In general, “deprecation” signifies that a product will no longer be updated or upgraded, although it will still be supported. “End of life” implies that there will be no further support; in alternative words, a product may fail to perform correctly – or at all.

Significantly, when Microsoft projected DES deprecation in November 2021, they set a November 2022 end-of-life date. Instead of utilizing numerous tools to get the job done, Microsoft recommends Azure Data Analytics, with the concept that you can speed time-to-insights with Azure Synapse Link for Dataverse, which is built-in and accessible in all out-of-the-box versions of Microsoft Dynamics 365.

While Microsoft provided plenty of warning about the end of life, if you’re like a lot of people, you probably thought, “November of 2022? That’s a long way away, I’ll be concerned about it afterwards.” And then, of course, you forgot about it! Hence November 2022 is no longer “far away.” In reality, January 2023 has already arrived! That indicates we’ve run out of lifeline!

How it affects your business?

Simply put, your organization’s Dynamics 365 ecosystem may be jeopardized. As previously stated, if it is dependent on data contained in a SQL database that is still filled by DES, you cannot afford to wait until the database reaches end of life before making the necessary changes. You may lose access to your Dynamics 365 Business Intelligence dashboards, reports, and connectors, among other things!

The Solution:

To export data from Dataverse, Azure Synapse Link for Dataverse is an excellent alternative to the DES. It also allows you to execute AI and machine learning, integrate with additional datasets, and slice and dice enormous amounts of Dataverse data. Because the Azure Synapse connection for Dataverse is built-in and available out of the box, we can reduce time to insights. It may be used to export data from Dataverse indefinitely to Azure Synapse Analytics and Azure Data Lake Storage Gen2.

Initial and incremental writes for table data and metadata are supported by the Azure Synapse Link for Dataverse service. Any updates to data or information in Dataverse are automatically sent to the Azure Synapse meta store as well as Azure Data Lake Storage, relying on the setup. This is actually a push procedure. Without the need for manual intervention, changes are pushed to the target.

Capabilities of Azure Synapse Link for Dataverse

Look for a more intuitive user interface in Azure Synapse Link that speeds data pipeline enablement & makes it easy for everyone in your organization to access Dataverse data. Metadata changes for the Common Data Model (CDM) will also be accessible across all Azure Synapse Link modules.

  • Exploration of a serverless data lake, interaction with other sources, and transformation in Azure Synapse Analytics
  • Custom forecast prediction utilizing Azure Synapse Analytics’ in-built AI integration over exported Dataverse data.
  • Tables are continuously exported to Azure Synapse Analytics and/or Azure Data Lake Storage Gen2. This covers both standard and unique tables that may be created, updated, or deleted.
  • Dataverse connection and delinking to Azure Synapse Analytics as well as Azure Data Lake Storage Gen2
  • Assessment of exported Dataverse data in Azure Synapse Analytics using common tools like T-SQL. Additionally, analysis may be performed using Apache Spark.
  • Using Power BI Reports and dashboards to extract insights from exported Dataverse data

These features, together with built-in data input capabilities, will increase the rate at which you can develop insights. Dataverse data may also be used to generate enterprise-scale Power BI reports. Another important feature of Azure Synapse Link is its solution-awareness. This simplifies application lifecycle governance and the transition from testing to operations.

Conclusion

For those who wish to execute artificial intelligence and machine learning, interface with external datasets, and analyze massive amounts of data, Azure Synapse Link provides the quickest approach. Therefore, preparing your transition with one of our assessment services is crucial to retaining your capacity to efficiently collect, analyze, disseminate, and connect with relevant data—we would be delighted to assist you in gaining insights that drive your business choices!

At DynaTech Systems, we have Azure specialists who can assist in migrating from MS Dynamics 365 DES (Data Export Service) to Azure Synapse Link for Dataverse. Though the DES is discontinued, DynaTech can guide you to successful export of data. Make sure that your organizational data is safe and accessible without any disruptions! Consult our Azure experts atsales@dynatechconsultancy.com right away!

 
 
 
 
 
 
 
 
 
 
5/5 - (5 votes)