Ultimate Guide for Pushing Azure SQL Changes to Dynamics 365

I recently embarked on a mission with my team to setup an integration between Azure SQL and Dynamics 365 (D365) which uses Dataverse to store its data. The requirements involved pushing any changes that take place on the Azure SQL side in real time to D365 to ensure that the data on both systems stay in sync. The solution also needed to push from Azure SQL to D365 instead of requiring the D365 side to poll for changes. Finally, the solution had to require the least amount of development effort. Here is the architecture of the solution we devised:

Looking at the aforementioned requirements it was clear that Azure Serverless solutions will have to come into play here. Upon further investigation we discovered that there is a new feature called Azure SQL trigger for Functions (still in public preview at the time of writing this post). As discussed here the Azure SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, updated, or deleted. Now here there are couple questions that needed to be answered before adopting this solution:

• Would the solution scale?
• Would the solution be resilient?
• Would it support the latest security standards on Azure ( e.g. using Managed Identities)?