# Connecting to an Azure SQL database **URL:** \ **Category:** Get Help\ **Created:** [September 17, 2021, 12:04am UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371 "2021-09-17T00:04:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![NewfangledSoftware](https://avatars.discourse-cdn.com/v4/letter/n/67e7ee/32.png) [@NewfangledSoftware](https://forum.adalo.com/u/NewfangledSoftware)\ **Post date:** [September 17, 2021, 12:04am UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/1 "2021-09-17T00:04:33Z")
Is it possible to connect Adalo to an azure SQL database. Meaning I want to create, delete, update and view records from that database instead of using the Adalo database. I have an existing customer and I want to build an app on top of their existing data. ---
**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\ **Post date:** [September 17, 2021, 2:08pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/2 "2021-09-17T14:08:37Z")
Hi @NewfangledSoftware, Welcome to the forum! Adalo can work with External Collections (aka DB Tables) via REST API (see here: [External Collections with APIs - Adalo Resources](https://help.adalo.com/integrations/external-collections-with-apis)). The external collection needs to have the correctly working endpoints. Quick search shows that Azure SQL databases could be exposed to “outer world” using Odata. See here: [Query Azure SQL Database using Rest-API](https://social.msdn.microsoft.com/Forums/azure/en-US/25d9baa4-2510-4ce4-b857-70a07e4ddea4/query-azure-sql-database-using-restapi?forum=azureapimgmt) and here [https://azure.microsoft.com/en-us/blog/introduction-to-open-data-protocol-odata-and-sql-azure/](https://azure.microsoft.com/en-us/blog/introduction-to-open-data-protocol-odata-and-sql-azure/). Hope this helps. Best regards, Victor. ---
**Author:** ![NewfangledSoftware](https://avatars.discourse-cdn.com/v4/letter/n/67e7ee/32.png) [@NewfangledSoftware](https://forum.adalo.com/u/NewfangledSoftware)\ **Post date:** [September 17, 2021, 7:34pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/3 "2021-09-17T19:34:18Z")
Good day Victor, Thank you for the reply. I saw those resources but had hoped someone in the community had found another way to do it. I was willing to collab with someone on it. The Odata service mentioned in the links no longer seems to exist. So my guess is that I need to create something custom. Will have to contact a traditional developer I think. ---
**Author:** ![vikingrs6](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/vikingrs6/32/81_2.png) [@vikingrs6](https://forum.adalo.com/u/vikingrs6)\ **Post date:** [September 17, 2021, 9:30pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/4 "2021-09-17T21:30:31Z")
You need [Instant GraphQL APIs & REST APIs on Databases](https://hasura.io/graphql/database/) Creates API endpoints to SQL Database. We use it with Azure SQL instances. Technically it’s a GraphQL first solution but it does allow you to create no-code REST API’s… Best of both worlds and a really good tool. SaaS or self hosted depending on your preference. You could also use PowerAutomate to create REST API endpoints to a Azure SQL database but it’s a lot more work etc. Odata is very 1990’s… ---
**Author:** ![NewfangledSoftware](https://avatars.discourse-cdn.com/v4/letter/n/67e7ee/32.png) [@NewfangledSoftware](https://forum.adalo.com/u/NewfangledSoftware)\ **Post date:** [September 17, 2021, 10:27pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/5 "2021-09-17T22:27:43Z")
The Power Automate option would be a winner as I have built their entire internal ecosystem with a combination of SQL, PowerApps connecting to SQL and then Power Automate to deal with any workflows. Not sure how to create the Power Automate connector though. ---
**Author:** ![vikingrs6](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/vikingrs6/32/81_2.png) [@vikingrs6](https://forum.adalo.com/u/vikingrs6)\ **Post date:** [September 17, 2021, 11:13pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/6 "2021-09-17T23:13:58Z")
Check out the HTTP Request Trigger and Response Action. It’s been a while since we did it but essentially the Request Trigger is your API endpoint, you then perform your SQL or whatever business logic action(s) and finally send your response back. Make sure you add some sort of auth token and validate it before doing the SQL to protect your data. Not as neat as the Hasura solution but doable… ---
**Author:** ![NewfangledSoftware](https://avatars.discourse-cdn.com/v4/letter/n/67e7ee/32.png) [@NewfangledSoftware](https://forum.adalo.com/u/NewfangledSoftware)\ **Post date:** [September 17, 2021, 11:16pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/7 "2021-09-17T23:16:31Z")
Checking out Hasura now. API’s are definitely my weakness so working through is. Thanks for that. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [September 27, 2021, 11:16pm UTC](https://forum.adalo.com/t/connecting-to-an-azure-sql-database/17371/8 "2021-09-27T23:16:50Z")
Closed on September 27, 2021, 11:16pm UTC This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.