We have an application (called Umbraco) hosted on Azure. We also have an on-premises SQL Server database. We'd like to integrate the two. Specifically, we want to push or pull data from the on-prem DB to Umbraco's database.
My approach was to use Azure's Data Sync to synchronize my on-prem DB with custom tables I'd add to the Umbraco DB. I would then build a process to poll the tables for changes and then push those changes through Umbraco's API.
My co-worker doesn't like this approach because he doesn't like the idea of constantly polling the tables to find changes. He wants to use a CLR proc in the on-prem DB to call the Umbraco API. I'm concerned about this approach primarily because of security concerns.
Are one of these ideas better? Are there other ideas?
Any help is much appreciated!