We would like to integrate an on-premise SQL Server database with Umbraco implemented in Azure.  What is the best way to do this?  I was thinking about using Azure sync services to sync a few tables from my on-premise database to the Umbraco database.  A custom process would then use Umbraco's API to push data into the correct tables in Umbraco.  One of the developers here does not like this idea because he doesn't think it's efficient to have a process continually poll one or more tables to find new data to push through Umbraco's API. 

We are also thinking about building CLR procedures in our on-premise database to call the Umbraco API, but I don't like that idea because I'm concerned about security and latency.

Any help would be GREATLY appreciated!

Thanks!