Multiple self-hosted IR proxies for an Azure-SSIS IR

Question

Multiple self-hosted IR proxies for an Azure-SSIS IR

Woody 41

Hello,
We have a self-hosted integration runtime that we have configured as a proxy for an Azure-SSIS IR in data factory. We also have numerous self-hosted integration runtimes setup on a number of different VMs and we want our Azure-SSIS IR to be able to use all these self hosted iRs as proxies. Is it possible to have more than one proxy IR for a SSIS IR? If not, what alternatives could we consider?
Thank-you.

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-04-22T21:07:12.263+00:00

Hi @Woody ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

AFAIK I don't think we can configure an Azure-SSIS IR with multiple self-hosted IR's as a proxy but to double check on the alternate options, I will reach out to the product team and will get back to you as soon as I have a response from the team.

Thank you for your patience
Woody 41 Reputation points

2021-04-23T06:23:44.467+00:00

I was asking about multiple proxies because we are shifting our SSIS packages from on-prem to Azure. Currently we have a number of ODBC connections defined on the server and our original idea was to have a handful of VMs in different locations that have a no. of ODBC connections defined on each based on the location of the VM and the location of the ODBC connection source.
For example, VM1 is located in Australia and it has 2 ODBC connections defined to end-points in Australia.
VM2 is located in the UK and it has 3 ODBC connections defined to end-points in throughout Europe.
The SSIS packages make calls to the ODBC connections in both regions which is why we thought we could have multiple proxies.
What if we were to setup multiple nodes for the one integration runtime proxy with the first node pointed at VM1 and the second node pointed at VM2. Would SSIS packages deployed in Azure be able to access ODBC connections defined on either machine, or is that not really how the nodes work?

Accepted answer

0 additional answers

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2021-04-22T21:07:12.263+00:00

Hi @Woody ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

AFAIK I don't think we can configure an Azure-SSIS IR with multiple self-hosted IR's as a proxy but to double check on the alternate options, I will reach out to the product team and will get back to you as soon as I have a response from the team.

Thank you for your patience
Woody 41 Reputation points

2021-04-23T06:23:44.467+00:00

I was asking about multiple proxies because we are shifting our SSIS packages from on-prem to Azure. Currently we have a number of ODBC connections defined on the server and our original idea was to have a handful of VMs in different locations that have a no. of ODBC connections defined on each based on the location of the VM and the location of the ODBC connection source.
For example, VM1 is located in Australia and it has 2 ODBC connections defined to end-points in Australia.
VM2 is located in the UK and it has 3 ODBC connections defined to end-points in throughout Europe.
The SSIS packages make calls to the ODBC connections in both regions which is why we thought we could have multiple proxies.
What if we were to setup multiple nodes for the one integration runtime proxy with the first node pointed at VM1 and the second node pointed at VM2. Would SSIS packages deployed in Azure be able to access ODBC connections defined on either machine, or is that not really how the nodes work?

Answer 1

Hi @Woody ,

A self-hosted integration runtime can run copy activities between a cloud data store and a data store in a private network. It also can dispatch transform activities against compute resources in an on-premises network or an Azure virtual network. The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network.

Please refer to Create and configure a self-hosted integration runtime.

Best regards,
Mona

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Multiple self-hosted IR proxies for an Azure-SSIS IR

0 additional answers

Your answer