0

I have a requirement to use an Azure Function App to query data in an on-premise SQL database, extract that data, dump it to a blob.

By these requirements ADF is not permissible.

The on premise SQL engine is behind a firewall.

How does Azure/the FunctionApp gain a connection to the SQL Engine to run the required select queries?

Steve Lyle-CSG
  • 117
  • 1
  • 4
  • 12

1 Answers1

2

For Azure AppService, you can use Hybrid Connections to access a private network from within your AppService. This can be your route into the on premise network.

The same is possible for Function Apps, as long as you use an app service plan with level "standard" or higher. Consumption plan is not supported. You can find it under "Platform features - Networking"

A full step-by-step tutorial can be found here: How to Azure Function App with Hybrid Connection.

Here is also a video about the idea.

Community
  • 1
  • 1
Alex AIT
  • 17,361
  • 3
  • 36
  • 73