Connect to on-prem data sources from Azure Data Factory

MS Techie 2,311 Reputation points
2021-04-14T16:55:53.993+00:00

Our Azure Cloud is connected to on-premises network via Express Route .

As i understand , we can connect to on-premises from AutoResolve IR via Managed Virtual Network and using Self Hosted IR .

So which Integration Runtime to choose , while connecting to on-prem
AutoResolve IR via Managed Virtual Network
or
Self Hosted IR.

Please help.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
{count} votes

Accepted answer
  1. MS Techie 2,311 Reputation points
    2021-05-03T05:16:25.51+00:00

    Thanks for your reply @HimanshuSinha-msft

    I think , we can connect to on-premises datasources, using 2 runtimes. Azure SSIS IR and Azure Self Hosted IR.

    Below is what i think , as per my understanding.

    If we are trying to rewrite SSIS packages in Azure Native ADF or writing Azure Native ADF, then to connect to on-premises, we can use Azure Self Hosted IR

    If we are using Lift and Shift model of Azure SSIS IR , then i think we can stick with Azure SSIS IR, since it connects to a VNet and hence can connect to on-premises.

    No comments

0 additional answers

Sort by: Most helpful