Bulk copy from a database with a control table

Question

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.

Answer 1

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.

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

Thanks
Saurabh