CODEWITHSUNDEEP
azure-data-factoryazure-private-link
user10486706
user10486706

Reputation: 157

Access on prem sql server without VMs through azure data factory

Currently I have SHIR in vm which has virtual network set up to connect to on prem sql for my data factory. I want to get rid of the VM and still access the onprem sql using the virtual network. Is it possible to use private link service to pull the data from onprem using adf managed private endpoint? I found one resource where they do this using a VM on top of the private link service. However, that still requires a VM.

Upvotes: 1

Views: 966

Answers (1)

BhargavaGunnam-MSFT
BhargavaGunnam-MSFT

Reputation: 313

Yes, It is possible to use a private link service and a managed private endpoint to access an on-premises SQL Server instance from ADF.

Using the private IP address, you can use the managed private endpoint to connect to the on-prem SQL Server. This eliminates the use of VM.

For this, You need to create a virtual network and establish a connection to your on-premises network using a VPN or ExpressRoute. Then you need to create a private endpoint for the SQL Server instance and use the private IP address to connect to SQL. You need to use SHIR(Which is installed on an on-premises machine and configured to connect to your virtual network) to connect to on-prem SQL via a private network using the private IP of the endpoint.

Upvotes: 0

Related Questions