How to conect to VPN using azure data factory linked service

Question

I have a client who don't want to install the SHIR in their SQL Server, so the client give me acess to a VPN connection and this informations:

• IP
• SQL Port
• Username
• Password

Is there anything I can do to connect in their server using the linked service of ADF?

Answer 1

Hello Antônio Farias,

Welcome to the Microsoft Q&A forum.

To connect to an on-premises SQL Server using ADF without installing a Self-hosted Integration Runtime (SHIR), you can follow the steps provided in the below Microsoft official documentation.

This tutorial guides you through setting up a Private Link Service and accessing the on-premises SQL Server from a managed virtual network using a private endpoint. By using a managed virtual network, the traffic to and from your on-premises SQL source will pass through your own private endpoint, adding an extra layer of security and isolation

Steps:

1. Setting up a Private Link Service: This involves creating a private link service in the Azure portal that connects to your on-premises SQL Server.
2. Creating a Private Endpoint: You will create a private endpoint in your managed virtual network that connects to the private link service.
3. Configuring the Linked Service in ADF: In ADF, you will configure the linked service to use the private endpoint for connecting to the on-premises SQL Server.

This solution ensures that your data remains secure and is not exposed to the public cloud, aligning with the client's security requirements.

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

I hope this answers your question. Please let me know if you have anyf urther questions.