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: