How to check if my function app is accessing resources in a vnet

Question

Hello, I am trying to create a web app which takes data from an IOT hub and moves the data onto a database which is located on a server secured with a virtual network.

To attempt to achieve this, I have created a function app which has public access enabled, and has network injection enabled which points to the virtual network containing the database server. Firstly, is this the correct approach? If it is, how can I test that the function I have written is connecting to the database?

Thanks for the help!

John

Answer 1

Hi,

Why do you need a Function app to pull data from Web app and push it to a VM in a VNET?

You can directly enable VNET connectivity from Web App and push data from Web app to VM in the vNET directly.

Regards,

Karthik Srinivas

Answer 2

@John Fahey

I hope this is your scenario -> IOT hub is enabled with public access and the Database is present in Vnet

For this use case, you can use IOT hub triggered azure function and write code to connect to the Database depending on the kind of database you are using. If it is SQL database, you can use the SQL bindings for Azure function ( This is still in preview). The function app can be integrated with Vnet, please make sure that the vnet is same as that of the database.

To test the connectivity you can perform tcpping from the function app to the SQL endpoint like below

1. In Azure potal of Function app-> select console
2. run this command-> tcpping server endpoint url:443