Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Unanswered

Automatically push data changes from Dynamics 365 to Azure SQL Server - is this possible?

Posted on by 16
Hi,
Our organisation uses Dynamics 365 as its transactional system. To report on this data, we, originally, used Data Export Services to push data updates automatically to an Azure SQL Server database. Microsoft deprecated Data Export Services and suggested the substitute be Azure Synapse. With the instructions that were published online with this suggestion were instructions on making any source (Dynamics 365) data changes updated automatically within Synapse.
Our organisation wishes to deprecate Synapse from our landscape and use Azure SQL Server again - to act as our single data warehouse - but this time there is no Data Export Services to call upon.
We are using Azure Data Factory Pipelines to import external data into our Azure SQL Server database. These imports are through pre-scheduled triggers, this is fine for external data. However, if any Dynamics 365 (Dataverse) source data is updated (records amended, records deleted, new records inserted, etc..) then is there a way for Dynamics 365 to push data to Azure SQL Server (or send a message to Azure SQL Server so an Azure Data Factory trigger can be executed to pull that updated data via a pipeline)?
Thanks.
  • Anthony Blake Profile Picture
    Anthony Blake 1,241 on at
    Automatically push data changes from Dynamics 365 to Azure SQL Server - is this possible?
    I think the challenge you have is that the way to get it to your SQL server might have to be via the Synapse link you want to take out of the equation.
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Automatically push data changes from Dynamics 365 to Azure SQL Server - is this possible?
    Hi,
     
    Please refer to the following thread, which may be helpful.
     
    Best Regards,
    Dengliang Li
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans