Can I specificy the VPC for Datafactory

Randall Danielson 96 Reputation points
2020-11-27T22:08:46.417+00:00

I have a site to site VPN setup and working. I can prove this by launching a virtual machine into the virtual network and pinging a machine in the other site.

Now what I want to do is launch Data-factory in this virtual network so that it can connect to a MS SQL server at the other site over the local addresses of the VPN.

How do I set the virtual network of a data-factory instance?

Thanks
~

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,116 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,440 questions
{count} votes

Accepted answer
  1. Randall Danielson 96 Reputation points
    2020-11-30T22:22:46.78+00:00

    Hi... maybe this is what you were trying to say and I didn't understand... but I got something to work.

    I created a new Azure windows VM (making sure to launch it into the virtual network that has access to the site 2 site vpn). Logged into Azure portal from a browser on this VM, did the express install of a Integration Runtime onto this VM.

    Now Data Factory can connect to the remote MS SQL over the VPN without installing anything at the remote site.

    Thanks
    ~Randy

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Saurabh Sharma 23,666 Reputation points Microsoft Employee
    2020-11-30T23:02:21.947+00:00

    @Randall Danielson Yes, correct you need to install SHIR on the VM to connect to your data factory to make it work in site to site VPN. Thanks for sharing the details as well as it will help other community members. Please let me know if you have any other questions.

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    0 comments No comments