How to connect azure container instances to on premise SQL Servers

Question

Hi I was wondering what services and infrastructure would be required in order to allow Azure container instances to connect to our on premise sql servers.

E.g on-premise data gateway, private link, azure vpn gateway?
The use case/ scenario for this is that we are wanting to spin-up containers running DBT within them and allowing dbt to execute sql commands against our on premise databases.

Answer 1

Hello @Justin Nix,

Just sharing some initial thoughts, how about exploring the option of deploying Container Instances in a VNET

https://learn.microsoft.com/en-us/azure/container-instances/container-instances-vnet

Then that particular container in the VNET can communicate with on premise sql servers either through VPN Gateway (https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-about-vpngateways)

Or Azure Express Route: https://learn.microsoft.com/en-us/azure/expressroute/expressroute-introduction

Regards,

Shiva.

Answer 2

You can deploy an Azure Container instance, into a Virtual Network - that is linked to your on-premises environment.

You can setup a Site to Site VPN from on-premises to your Azure, using a VPN Gateway, Local Gateway and Azure Virtual Network, and for DNS resolution you can use a domain controller on-premises or in azure or Azure Private DNS resolver.