Source and sink in the copy activity must be connected via the same self-hosted IR

Question

_{Wednesday, February 6, 2019 7:08 PM}

I'm confused with this message "Source and sink in the copy activity must be connected via the same self-hosted IR"

Story: 1. Created azure data factory pipeline to load data from Oracle db (on premises) to Azure data lake gen 2 To connect to Oracle on premises we are using Oracle self-hosted IR, to connect to Azure Data Lake container we are using Azure AutoResolveIntegrationRuntime.  All works, data loaded

2. Enabled fire wall on Azure storage ( where data Lake located) for selected network: corporate ip range. AutoResolveIntegrationRuntime couldn't accessing Data Lake, which is understandable: Azure has IP different from my company IP range.

3. Created virtual machine on Azure under company Vnet with new selfhosted IR. In azure data factory set connection to Data lake with new self hosted IR, connection works, firewall is on, all great. But Pipeline stopped working, getting error : Source and sink in the copy activity must be connected via the same self-hosted IR

How I can resolve the issue?

Thank you, Bruce.     

All replies (1)

_{Wednesday, February 13, 2019 10:16 AM}

HI Bruce,

Ensure that the firewall rules are enabled properly on the corporate firewall, the Windows firewall on the self-hosted integration runtime machine, and the data store itself. Enabling these rules allows the self-hosted integration runtime to connect to both source and sink successfully. Enable rules for each data store that is involved in the copy operation.

For more details, refer “Ports and firewall”.

Hope this helps.