Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
492 questions
Access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 31%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
thanakrit.r
1
Reputation point
Hi,
I need to set up ADF with VNet integration. there is now a Managed VNet feature that avoids creating a VM and hosting a Self-Hosted Integration Runtime on it.
Unfortunately, when I look into the requirements and the setup associated, it looks like it requires a Load Balancer and also Virtual Machines as stated in this post: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
Is it really the only way to manage VNet integration with on-premises resources? Is it possible to not have a loadbalancer and a backend server for forward rule to endpoint?
BR,
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 46%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sidney Hodieb 85 Reputation points2023-11-14T10:44:04.5566667+00:00 The Managed VNet feature in Azure Data Factory (ADF) does not require a VM or a Self-Hosted Integration Runtime. It simplifies secure data access within a virtual network by provisioning an Azure Integration Runtime within a Managed VNet.
However, if you’re looking to access on-premises resources, you’ll need to connect your on-premises environments to Azure via Express Route or VPN. The tutorial you mentioned involves a Load Balancer and Virtual Machines, but that’s for a specific scenario where you want to access an on-premises SQL Server.
If you’re accessing Azure resources like Azure SQL Managed Instance from a Managed VNet, you can do so using a Private Endpoint without needing a Load Balancer or backend server. So, the requirements for setting up a Managed VNet in ADF depend on your specific use case and the resources you want to access. Hope this helps!
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga 5,985 Reputation points Microsoft Vendor2023-11-15T12:31:05.9366667+00:00 Hi thanakrit.r
Just checking in to see if the above answer provided by @Sidney HODIEB helped.If this answers your query, do click
Accept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know. -
Harishga 5,985 Reputation points Microsoft Vendor
2023-11-16T11:26:51.6166667+00:00 Hi@thanakrit.r
Just checking in to see if the above answer provided by @ @Sidney HODIEB helped.If this answers your query, do click
Accept AnswerandYesfor was this answer helpful. And, if you have any further query do let us know.
Sign in to comment