How to access on-premise SQL server using Azure-Relay-Bridge from Azure Function App in python

Question

Hi,

I would like to access on-premise SQL server from Azure function app using Azure-Relay-Bridge(https://github.com/Azure/azure-relay-bridge)

In my efforts to configure the Azure Relay Bridge, I have explored multiple avenues.

As I am not an expert in the Azure Relay part, I have faced difficulty due to the limited availability of comprehensive online documentation.

I have meticulously reviewed these articlesand attempted to implement the suggested solutions:

https://github.com/Huachao/azure-content/blob/master/articles/app-service-web/web-sites-hybrid-connection-connect-on-premises-sql-server.md

https://github.com/AdamPaternostro/Azure-Relay-Connect-To-SQL-PaaS-Without-Firewall-Rule

But I am not sure if this is perfect match for my case.

Is there any written documentation or available open source for it?

I want to write Function app in python.

Answer 1

Hello @Robert Chow - Thanks for reaching out and posting on the MS Q&A.

Here's an official documentation using Powershell functions & Hybrid Connections: Managing hybrid environments with PowerShell in Azure Functions and App Service Hybrid Connections

Azure Functions is great for stateless executions but for stateful workflows such as establishing a connection to an on-prem SQL server, you might look at Azure Durable Functions, Logic Apps, and WebApps. For example, you can create a workflow in Logic Apps that interact with the on-prem SQL Server, and call your Function App in the same workflow too: Create and run code from workflows in Azure Logic Apps using Azure Functions

---

Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.