question

HemantSudehely-0557 avatar image
0 Votes"
HemantSudehely-0557 asked ·

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

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...

azure-data-factoryazure-virtual-machines
10 |1000 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.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered ·

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








·
10 |1000 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.