question

Samy-7940 avatar image
0 Votes"
Samy-7940 asked SaurabhSharma-msft commented

Bulk copy from a database with a control table


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

https://docs.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
· 1
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.

Hi All, appreciate an update on this. Thanks a lot.

0 Votes 0 ·

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @samy-7940,

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


image.png (99.8 KiB)
· 1
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.

Hi @samy-7940,

We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·