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: 
_AnonymousUser
Specialist III
Specialist III

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.
Labels (2)
1 Reply
Anonymous
Not applicable

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")