Forum Discussion
Azure VPN Connection
Greetings - I don't know if this is possible in Azure, but I figured I would try as all the classes I have taken don't have an answer. I am new to Azure networking so what I want to do may not b...
For your scenario, since you already have an Azure VPN set up with the client and you are trying to connect to a SQL server to pull data for reporting purposes, you can use a Self-hosted Integration Runtime installed on a machine that has access to the SQL server over the VPN. The Self-hosted Integration Runtime can securely connect to Azure Data Factory through the internet, and you can use it to create an endpoint in Azure Data Factory to connect to the SQL server and pull data for your reports.
To set up the Self-hosted Integration Runtime, you need to download and install the Integration Runtime on a machine that has connectivity to the data sources you want to use in your data integration pipelines. Once installed, you can configure the Integration Runtime to connect to the Azure Data Factory service and register it with the service.
After registering the Self-hosted Integration Runtime with Azure Data Factory, you can use it to create data integration pipelines that can connect to your SQL server and pull data for your reporting needs.
To set up the Self-hosted Integration Runtime, you need to download and install the Integration Runtime on a machine that has connectivity to the data sources you want to use in your data integration pipelines. Once installed, you can configure the Integration Runtime to connect to the Azure Data Factory service and register it with the service.
After registering the Self-hosted Integration Runtime with Azure Data Factory, you can use it to create data integration pipelines that can connect to your SQL server and pull data for your reporting needs.