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

Robert Chow 0 Reputation points


I would like to access on-premise SQL server from Azure function app using 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:

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.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,693 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,582 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MikeUrnun 8,346 Reputation points

    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.

    0 comments No comments