Create and configure a self-hosted integration runtime

Question

Hello,
I am working on a fresh Azure Synapse Analytics project and i am trying to connect my workspace to on prem SQL server to retrive data according to thisrd point of this article :
https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime
The integration runtime is recommended to be different from the machine hosting the server but i think i need to configure a pipeline between the two machines and i can not find he clear steps to do so any suggestion how to figure this out ?
@HarithaMaddi-MSFT please can you help with this one ?

Answer 1

Hi @ahmed alouini ,

Welcome to Microsoft Q&A forum and thanks for your query.

The self-hosted integration runtime doesn't need to be on the same machine as the data source. However, having the self-hosted integration runtime close to the data source reduces the time for the self-hosted integration runtime to connect to the data source. But it is recommended (not mandatory) to setup the IR on private networks (such as VMs) in the same location of your data factory and other resources, in order to ensure the smooth data transfer.

You will have to meet the firewall requirements for on-premises/private network for both machines. The following document has the outbound port and domain requirements for corporate firewalls.

• Firewall requirements for on-premises/private network

You can also refer to this video by a community volunteer for a detailed demo on how to copy data between two virtual machine data sources using Azure data factory: Azure Data Factory Self-hosted Integration Runtime Tutorial | Connect to private on-premises network

Hope this info helps. Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.