topic ETL of GSDB IBM sample database from DB2 to MySQL. in Talend Studio

ETL of GSDB IBM sample database from DB2 to MySQL.

_AnonymousUser — Sat, 16 Nov 2024 12:57:55 GMT

I need to migrate the GSDB database(Great Outdoors,a free IBM sample database used for demonstration of products like Cognos BI etc.) from DB2 to MySQL.Essentially, I want the tables with data,but also other DB objects like stored procedures etc if it is possible.As I am very new with Talend ETL I would appreciate some hints about the better way to do it.
Thanks.

Re: ETL of GSDB IBM sample database from DB2 to MySQL.

Anonymous — Thu, 21 Apr 2011 18:38:12 GMT

Talend can do database migrations, but this is not the primary focus for the tool. Migrating SP and other DB objects may be easier with a tool designed for this use.
For the tables and data (especially if you want to automate the process) Talend is a good fit.
if you are using TIS, take a look at the table-to-table job templates (right click Job Designs-->Create Job from Template")