question

Woody-6707 avatar image
0 Votes"
Woody-6707 asked Monalv-msft answered

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

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.

azure-data-factorysql-server-integration-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @woody-6707,

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

1 Vote 1 ·

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?

0 Votes 0 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi @Woody-6707 ,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.