Connecting to a sql database at Azure

Mark EbersoleMark Ebersole Member
edited March 2017 in Questions
Has anyone created an external connection to a SQL Database hosted at Azure?  What are the steps?

Comments

  • Tyler NealTyler Neal Member
    edited February 2017
    I'm wondering this as well, would like to move some old archived data over and have it still be accessible.
  • Khamla PhimmachackKhamla Phimmachack Skuid Mod, Admin 🛠️ 
    edited May 2017
    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!
  • Mark EbersoleMark Ebersole Member
    edited March 2017
    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.
  • rocketcrocketc Member
    edited March 2017
    Mark,

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