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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?