How to access on-premises SQL Server from Azure Data Factory without self-hosted IR or setting up a new VM

yiwan 0 Reputation points
2024-01-22T09:10:13.06+00:00

I want to access on-premises SQL Server from Azure Data Factory and look up some documents. I found that there are 2 ways to implement:

  1. use self-hosted IR to access SQL server
  2. set up Load Balancer, Private Link and VM to access SQL Serverhttps://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

But,

for 1, I don't have permission to install anything in this PC, it is difficult to set up the self-hosted IR here.

for 2, it is difficult to set up a new VM in company's Azure environment.

So, are there any other ways to access on-premises SQL Server from Azure Data Factory?

(there is Express Route between on-premises network and Azure cloud environment.)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,313 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,136 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 24,271 Reputation points Microsoft Employee
    2024-01-22T20:23:40.76+00:00

    Hello yiwan,

    Welcome to the Microsoft Q&A forum.

    My understanding is, In order to access an on-premises SQL Server from Azure Data Factory, you will need to use either a self-hosted integration runtime or an Azure virtual machine(set up for the load balancer) that is connected to your on-premises network.

    This Azure VM needs to be connected to your on-premises network via a VPN or ExpressRoute as pointed out in the document.

    I hope this answers your question. Please let me know if you have any further questions.

    0 comments No comments