Create and configure a self-hosted integration runtime

ahmed alouini 21 Reputation points

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 :
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 ?

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,362 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,525 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

    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.

    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.

0 additional answers

Sort by: Most helpful