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

Christian Vogel 1 Reputation point
2022-04-19T18:17:19.487+00:00

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:
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

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
    2022-04-20T20:10:22.093+00:00

    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 .https://learn.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#azure-ir-network-environment

    <<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.
    Thanks
    Himanshu


    • 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