Access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint

thanakrit.r 1 Reputation point
2023-11-13T15:16:02.2566667+00:00

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,

Azure Private Link
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.
484 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,126 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
{count} votes