Forum Discussion
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 still want to connect to my local databas server. Having trouble figuring out the best way, i would prefere not to setup a private VPN between Azure and my local network (Going to deploy a couples of customers).
- Hybrid Connection, not working only for WebApp?
- On-premises data gateway, not for Virtual machines?
- VPN (Feels like overkill)
What do you recommend?
Or can i run a Windows service as App for something in Azure? Please point my in the right direction 😉
- Hello,
Could please clarify the following.
Where you are planning to host the windows service - Azure VM or onprem VM?
What the service will do?
With whom the service will interact - you app or dB?- The service get into the VM on Azure, and fetch data from my local database.
- If you want to securely access your onprem database from a service running on Azure VM directly, the best option is to setup a private connectivity between your Azure vnet and onprem network. You can achieve this via s2s vpn or Express Route.
Now, if you don't want to setup vpn/Express Route, I see the following two options:
You have to see if the function of your Windows service can be replaced by a suitable PaaS services to use a onprem data gateway to securely access the onprem data over the internet.
Or,
You can use Azure Data Factory Integration Runtime to securely move your onprem data to a blob storage or Azure SQL dB then setup your Windows service to access the data from there.
Hope this helps.
Thanks,
Rohan
