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.
