Azure Data Factory - Can you copy from on-prem MS SQL Server when within a Managed Virtual Network IR?

Christian Vogel 1 Reputation point

Hi all,

We're trying to use ADF to copy data from an on-prem SQL Server to an Azure SQL DB. The IR documentation seems to indicate the only way to do this is with a self-hosted IR, but we're also looking options to use a VPN to connect Azure and our on-prem SQL server directly, with something like this:

Is it possible for configured VPN and routes settings to allow Azure IR to copy data from our on-prem SQL Server?

Thanks for your help and guidance!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,762 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

    Hello @Christian Vogel ,
    Thanks for the question and using MS Q&A platform.

    As we understand the ask here is can we connect to in premise SQL using Azure IR with VPN , please do let us know if its not accurate.
    Is the inpremise server part of VPN ? if yes Its possible .

    <<text from the above link >>
    Azure Integration Runtime supports connecting to data stores and computes services with public accessible endpoints. Enabling Managed Virtual Network*, Azure Integration Runtime supports connecting to data stores using private link service in private network environment*.

    Please do let me if you have any queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments