Bulk copy from a database with a control table

Samy Abdul 3,366 Reputation points
2021-09-19T15:52:17.287+00:00

Hi All, I have been going through the Azure document link suggested earlier on by experts:

https://learn.microsoft.com/en-us/azure/data-factory/solution-template-bulk-copy-with-control-table

But , I have found below information contradictory:
To copy data from a data warehouse in Oracle Server, Netezza, Teradata, or SQL Server to Azure Synapse Analytics, you have to load
huge amounts of data from multiple tables. Usually, the data has to be partitioned in each table so that you can load rows with
multiple threads in parallel from a single table.
This article describes a template to use in these scenarios.

NOTE: If you want to copy data from a small number of tables with relatively small data volume to Azure Synapse Analytics, it's more
efficient to use the Azure Data Factory Copy Data tool. The template that's described in this article is more than you need for that
scenario.

Could experts explain the apparent contradiction. I assume in the note it should have been Copy activity. Thanks a lot.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,118 questions
{count} votes

Accepted answer
  1. Saurabh Sharma 23,791 Reputation points Microsoft Employee
    2021-09-20T18:39:37.58+00:00

    Hi @Samy Abdul ,

    Thanks for using Microsoft Q&A !!
    I do not think it is a contradiction as ADF Copy Data Tool with the control template (Metadata-driven copy task) is suggested for data warehouses with large amount of data however the note talks about general Copy Data Tool is "Built-In Copy Task" Task Type to perform copy activity.
    133646-image.png

    In both cases the template uses Copy Activity for the data ingestion. Please let me know if you have any other questions.

    Thanks
    Saurabh


0 additional answers

Sort by: Most helpful