Has anyone created an external connection to a SQL Database hosted at Azure? What are the steps?
I’m wondering this as well, would like to move some old archived data over and have it still be accessible.
You may be able to get some guidance from this tutorial:
Some of the basic requirements for connecting to an external data source are:
1. Accessible via a URL endpoint (including an authentication scheme that we support)
2. Payloads are JSON.
Please see this link for more information about connecting to data sources.
Hope this helps!
Thanks. I was able to connect to my database by creating an Odata web service that connected to it and hosting the web service at Azure.
Could you list the steps you took to achieve this? Creating a Odata web service for an existing Azure SQL database. Thank you