Forum Discussion

matthew_jones's avatar
matthew_jones
Copper Contributor
Nov 03, 2021

Azure Data Factory - connect to VM SQL

Hi all.

 

I have a n Azure VM SQL machine.

 

Im trying to setup an Integration Runtime for this server in ADF.  I dont want to use Self-hosted IR as that precludes using a dataflow.

 

The VM/SQL is public facing and has a public IP.

 

Is there anyway I can use an Azure IR for this?

 

Many thanks in advance.

 

Matt

1 Reply

  • lukemurraynz's avatar
    lukemurraynz
    Learn Expert
    Jan 15, 2022
    You could try Azure Data Factory on a Private Link, then connect that way?

    https://docs.https://docs.microsoft.com/en-us/azure/data-factory/data-factory-private-linkmicrosoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory