Forum Discussion

JohanDevP's avatar
JohanDevP
Copper Contributor
Jun 27, 2020

Access local data from Azure Virtual Machine

Hello,  My first time here so be nice ; ) When i deploy WebApps i use a Hybrid Connection to access onprem databases. But now i need to install a Windows Service on a virtual machine, and stil...
App Services
azure
devops
networking
virtual network
rohanislam's avatar
rohanislam
Brass Contributor
Jun 28, 2020

Previously you said your service fetch data from the local database and now you are saying the service is used to fetch data from some third part API. 😉
If the first one is true, you can simply try using Azure "Function App" to connect to your local sql db via hybrid connection.
If the latter is true, you can try using "Logic App", you should be able to connect to any API by configuring a custom connector. You can also connect logic app to your local sql server via an onprem data gateway as well.
So, I would explore Function App and Logic App and see which one suits the best to meet the requirement.
Hope this helps, please let me know if you have any further query.

Thanks,
Rohan



JohanDevP's avatar
JohanDevP
Copper Contributor
Jun 28, 2020

Thank you, i did not provid you with all information the flow is the following:

 

1. Fetch data from external API.

2. Import it into the local database (and process it)

3. Then display the processed data on the web again.

 

Going to look into Function App, and Logic App 😉

Resources