Connect to on-prem data sources from Azure Data Factory

Question

Connect to on-prem data sources from Azure Data Factory

MS Techie 2,346

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.

HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-16T00:38:03.437+00:00

Hello @MS Techie ,
Thanks for the ask and using the Microsoft Q&A platform .
I dont have an express route setup and hence i cannot test this . But since you are already on ER , I think AutoresolveIR work for you .
Please do let me know how it goes .
Thanks
Himanshu
MS Techie 2,346 Reputation points

2021-04-16T10:25:40.063+00:00

Hi @HimanshuSinha-msft

My question is whether to use Azure Managed Virtual network option or Self Hosted IR , while connecting to on-premises.
Which is better ?

Please check internally with experts from Microsoft and let me know the answer.
HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-19T20:38:04.057+00:00

Hello @MS Techie ,

Thanks for the patience , please go ahead and use Self hosted IR . Please read about this more here .

Hope this helps .

Thanks
Himanshu
HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-27T18:01:51.477+00:00

Hello @MS Techie ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-16T00:38:03.437+00:00

Hello @MS Techie ,
Thanks for the ask and using the Microsoft Q&A platform .
I dont have an express route setup and hence i cannot test this . But since you are already on ER , I think AutoresolveIR work for you .
Please do let me know how it goes .
Thanks
Himanshu
MS Techie 2,346 Reputation points

2021-04-16T10:25:40.063+00:00

Hi @HimanshuSinha-msft

My question is whether to use Azure Managed Virtual network option or Self Hosted IR , while connecting to on-premises.
Which is better ?

Please check internally with experts from Microsoft and let me know the answer.
HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-19T20:38:04.057+00:00

Hello @MS Techie ,

Thanks for the patience , please go ahead and use Self hosted IR . Please read about this more here .

Hope this helps .

Thanks
Himanshu
HimanshuSinha-msft 18,621 Reputation points Microsoft Employee

2021-04-27T18:01:51.477+00:00

Hello @MS Techie ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Answer 1

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.

Connect to on-prem data sources from Azure Data Factory

0 additional answers

Activity