ETL of GSDB IBM sample database from DB2 to MySQL.
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.
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")