Access on-premises file-share from Azure functions ?

Question

We have a hub-and-spoke network connectivity from Azure Network to on-premises via Express Route

From Azure functions , how to access

1. On-premises File-Share
2. On-Premises SQL Server

What options do we have ?

Please help

Answer 1

Hello @MS Techie , Thank you for reaching out, apologies for the delay.
Depending on the plan utilized you can have different networking options available as mentioned here in the documentation. Below are some options which I can think of that you can use based on your requirements.

On-premises File-Share

• As mentioned in this post by Ajay, due to Sandbox environment restrictions connecting to on-premises file share is not supported. You can use the REST functionality as suggested by him.
• You can use Azure Logic App to connect to your on-premises File-Share using on-premises data gateway and perform actions/triggers according to your requirements. In addition to it you can also connect your Function App to your Logic App if additional requirements are there.

On-Premises SQL Server:

• As you have the Express Route connectivity you can use Regional VNET integration for outbound access from your Function App and use Private Endpoint/ Service Endpoint for inbound access. Please go through this documentation for additional details.
• As mentioned above you can use Azure Logic App to connect to your on-premises SQL Server using on-premises data gateway and perform actions/triggers according to your requirements.

Please let me know if there any other concerns I will be glad to continue with our discussion. Thank you!

Answer 2

Is there any news on this one? We’re willing to run Azure Functions in any flavor (Windows, Linux, isolated, containerized etc.) to be able to connect to an on-premises file share.