Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Copy 100+ tables from one database to another database

Hi,
I have Enterprise version Talend. I need to copy tables from one database to another database. I am looking dynamic schema option and the below link is not working and I see this link in several posts. 
If anyone know how to copy tables from one database to another using dynamic schema let me know.

Thanks.

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Here is the link:
vapukov
Master II
Master II

If You use Enterprise version of Talend, it is already support Dynamic columns, so You can make a loop:
1) read all tables names from Source (from information schema for example)
2) convert flow to iterate and for each row store names to variable
3) make a universal job - source table -> target table. Use variable as table name and single column with Dynamic type

If You use community version - check Talend Exchange for components (if it present for Your database)
Anonymous
Not applicable
Author

Hi!

How did you resolve it?