title: Use Azure Data Factory + Azure Integration Runtime to connect to on-premises SQL Server
body: <p>I have a SQL Server instance installed on a Virtual Machine, said VM is connected to an Azure VNet. My goal is to consecutively get data out of this SQL Server and store it in an Azure Data Lake.</p>
  <p>Is it possible to use an Azure Data Factory + Azure Integration Runtime (NOT a self-hosted integration runtime!) to do this?</p>
  <p>If I create a new Data Factory (including Private Endpoints so the factory gets an IP address of the VNet) and use the standard Integration Runtime &quot;AutoResolveIntegrationRuntime&quot;, it's possible to specify a SQL server name and credentials, however, the connection test fails:</p>
  <p><a href="https://i.stack.imgur.com/ua8h8l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ua8h8l.png" alt="enter image description here" /></a></p>
  <p>After installing a self-hosted integration runtime on the VM and using this IR, it appears to work:</p>
  <p><a href="https://i.stack.imgur.com/9bJvvl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9bJvvl.png" alt="enter image description here" /></a></p>
  <p>What exactly is the integration runtime doing that wouldn't be possible without it? In the end, couldn't the Azure Integration Runtime (hosted on Azure) just open up an ODBC connection, especially since all resources are in the same network?</p>