Self Hosted IR

Keerthika 20 Reputation points

We are using Azure Data Factory/Azure synapse analytics to copy SQL data from on premise to Azure Data Lake. For this we have installed Self hosted IR in one of the VM in On-Premise environment.

Is there any alternative way, where we do not need to manage our own VM or run the Self Hosted IR to get the data from on-prem databases to Azure Data Lake using Azure data factory?

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.
3,805 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,474 questions
0 comments No comments
{count} votes

Accepted answer
  1. Harishga 940 Reputation points Microsoft Vendor


    Welcome to Microsoft Q&A and thank you for your query.

    In order to copy data from local sources to the cloud using Azure Data Factory, it needs to be able to connect to those sources. This can be achieved only by using the self-hosted integration runtime.

    The self-hosted integration runtime is a service running in Azure Data Factory, but you can add local compute nodes on local servers in your on-premises network. The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network. A connection is created between the nodes and the integration runtime within your Azure Data Factory (ADF) in Azure. Through this connection, ADF can reach your local data and copy it securely to the cloud. This set-up is very similar to the Power BI on-premises gateway. In fact, the self-hosted integration runtime used to be called the "data management gateway".

    An alternative to using the self-hosted integration runtime (IR), is to use an on-premises ETL tool - like SSIS - to push the data to the cloud. However, this means you need a SQL Server license and a server. The self-hosted IR service is free to use and can be run on any local server. If you want to migrate your data infrastructure to the cloud, Azure Data Factory (and other Azure tools like Logic Apps) are a better choice.

    Hope this helps. Do let us know if you any further queries.

    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.

0 additional answers

Sort by: Most helpful