#1 2011-06-27 16:16:20

apasotti
Member
Company: pasotti consulting
Registered: 2009-08-05
Posts: 42
Website

copy db

Tags: [as400, database, db2]

Hi
Sorry for the disturbance,
I read all the tables in a db (about 100) and copy them to another db. The data base is a as400 while the target is a db2.
The tables have the same path.
I can not use direct sql commands.
Is there a way using some COMPONENTS Talend?

Offline

#2 2011-06-28 09:19:44

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: copy db

Hi
There is no a component can be used to copy simply the database from one db type to another type. In Talend, you need to use a tAS400Input to extract records from one table and write them into target db using tDB2Output, create the table if not exist on tDB2Output. To speed up the development progress, you can use the advanced feature 'create job from templates' in Talend Integration Suite.


Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB