Skip to main content
Nintex Community Menu Bar
Question

Connecting to a sql database at Azure

  • July 10, 2024
  • 4 replies
  • 12 views

Forum|alt.badge.img+3

Has anyone created an external connection to a SQL Database hosted at Azure?  What are the steps?

4 replies

Forum|alt.badge.img+4

I’m wondering this as well, would like to move some old archived data over and have it still be accessible.


Forum|alt.badge.img+6

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!


Forum|alt.badge.img+3

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.


Forum|alt.badge.img+3
  • July 10, 2024

Mark,

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