A SQLCLR object that makes a connection to the Cloud database is an option as well. Given the "different domains" comment I suspect any connection between the two instances will need to be done using a SQL Server Login Name and Password and not rely on a Windows Security Context.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato