Connecting to a sql database at Azure

  • 1
  • Question
  • Updated 2 years ago
  • Doesn't Need an Answer
Has anyone created an external connection to a SQL Database hosted at Azure?  What are the steps?
Photo of Mark Ebersole

Mark Ebersole

  • 570 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Tyler Neal

Tyler Neal

  • 760 Points 500 badge 2x thumb
I'm wondering this as well, would like to move some old archived data over and have it still be accessible.
Photo of Khamla Phimmachack

Khamla Phimmachack, Official Rep

  • 1,536 Points 1k badge 2x thumb
Great question,

You may be able to get some guidance from this tutorial:

http://help.skuid.com/m/models-conditions-filters/l/679635-using-azure-active-directory-with-the-mic...

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!
Photo of Mark Ebersole

Mark Ebersole

  • 570 Points 500 badge 2x thumb
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.
Photo of rocketc

rocketc

  • 722 Points 500 badge 2x thumb
Mark,

Could you list the steps you took to achieve this? Creating a Odata web service for an existing Azure SQL database. Thank you