Azure DataFactory COPY on-prem sql database

sakuraime 2,321 Reputation points
2021-09-22T15:11:27.023+00:00

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
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,643 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,036 Reputation points
    2021-09-22T20:53:54.497+00:00

    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.

    0 comments