question

ahmedalouini-3495 avatar image
0 Votes"
ahmedalouini-3495 asked KranthiPakala-MSFT commented

Create and configure a self-hosted integration runtime

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://docs.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 ?

azure-data-factoryazure-sql-databaseazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @ahmedalouini-3495,

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks alot this exactly what i was looking for

0 Votes 0 ·

Hi @ahmedalouini-3495,

Glad to know my response was helpful. Thanks for accepting the answer as it would be beneficial for other users reading this thread. :)

Have a nice day!

0 Votes 0 ·