Azure Data Factory Azure Integration Runtime for on-premise SQL server

Question

Hi,

I have S2S connectivity from Azure to Onpremise. I have a SQL server kept in Onpremise. Can I use Azure Integration run time instead of using Self Hosted Integration runtime to connect to SQL server? WHat If I want to access file share from Data Factory? What kind of Integration runtime will be required? Self hosted or Azure IR?

Regards

Rajaniesh

Answer 1

@Anonymous

Welcome to the Microsoft Q&A platform, and thank you for posting your query in the community forum. 

I understand that you want to know if you can use Azure Integration Runtime instead of Self-Hosted Integration Runtime to connect to an on-premises SQL Server and what kind of Integration Runtime is required to access a file share from Data Factory.

In Azure Data Factory, we have three kinds of integration runtimes: The Azure integration runtime, the self-hosted integration runtime and the Azure-SSIS integration runtime. For the Azure integration runtime, you can also enable a managed virtual network which makes its architecture different than the global Azure integration runtime.

This table lists the differences in some aspects of all integration runtimes, you can choose the appropriate one according to your actual needs.

To connect to an on-premises SQL Server using Azure Integration Runtime, you need to:

• Set up Site-to-Site (S2S) connectivity between Azure and your on-premises network.
• Install Azure Integration Runtime in your Azure virtual network.
• Configure Azure Integration Runtime to use the S2S connection to connect to your on-premises SQL Server.
• Use Azure Integration Runtime to securely transfer data between your on-premises SQL Server and cloud-based data stores.

To access a file share from Data Factory using Self-Hosted Integration Runtime, you need to:

• Install Self-Hosted Integration Runtime on a local machine in your on-premises network.
• Configure Self-Hosted Integration Runtime to access the file share.
• Use Self-Hosted Integration Runtime to securely transfer data between the file share and cloud-based data stores.

For more details, refer to: Choose the right integration runtime configuration for your scenario

I hope this helps! Let me know if you have any further questions.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.