Use single self hosted IR to source on-Prem sql database and target Azure VM sql server data server

Question

I have required to perform Azure Data Factory Copy activity.
My source is the On-Prem SQL server database and target sink activity to the Azure VM SQL server data server.

I did try by creating 2 self-hosted IR(one for source and one for target) but getting validation error - source and sink in the copy activity must be connected via the same self-hosted integration runtime

Please suggest...

Answer 1

Hi @HemantSudehely-0557 ,

Welcome to Microsoft Q&A and thank you for your query.

For Copy activity, it requires source and sink linked services to define the direction of data flow. The following logic is used to determine which integration runtime instance is used to perform the copy:

Copying between two cloud data sources: when both source and sink linked services are using Azure IR, ADF uses the regional Azure IR if you specified, or auto determine a location of Azure IR if you choose the autoresolve IR (default) as described in Integration runtime location section.

Copying between a cloud data source and a data source in private network: if either source or sink linked service points to a self-hosted IR, the copy activity is executed on that self-hosted Integration Runtime.

Copying between two data sources in private network: both the source and sink Linked Service must point to the same instance of integration runtime, and that integration runtime is used to execute the copy Activity.

Please refer to this doc: Determining which IR to use

Hope this helps.

----------

Thank you

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members