question

sakuraime avatar image
0 Votes"
sakuraime asked MartinJaffer-MSFT commented

Azure DataFactory COPY on-prem sql database

If I am going to copy on-prem sql server database to azure blob storage account parquet file , I will need a self-host IR ,should be I the self-host IR on-prem or put the self-host IR at Azure VM ? which has the best performance ?

azure-data-factory
· 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.

@sakuraime did my response help you? If it solved your question, please mark as accepted answer. If not let me know how I may better assist.

0 Votes 0 ·

If you found your own solution, please share here with the community.

0 Votes 0 ·

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered

Hello @sakuraime and welcome back.

If your source is on-prem and in a network behind a firewall, you should put your self-hosted IR on prem in the same network. The closer your IR is to your source, the better the performance.

IR separated from on-prem source by firewall, cannot talk to your source.

Only exception might be when you join/peer your on-prem network and virtual network. Still, closer to the source, the better.

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.