Connect an on-prem SQL Server to Azure Data Factory using a self-hosted integration runtime (IR).

Summary

This simulates an on-prem environment by creating two servers in the same network. One has SQL Server and the other has a self-hosted integration runtime installed to connect to Azure.

  1. Create two Windows VMs in Azure with the same virtual network/subnet
  2. In VM1: Install SQL Server with sample database.
  3. In VM2: Install Azure Data Studio and the self-hosted IR.
  4. Test connection VM2 -> VM1.

Considerations for using a self-hosted integration runtime

More details in this Microsoft doc.

  • Don’t in