Page Comparison

Here is a quick tip on how to move data from one database to another, a simple proposition thanks to Kettle being the awesome ETL tool that it is!

We are going to move the Pentaho demo sample data from HSQLDb to MySQL. I have attached the Kettle transformation used to move the data. We are not going to go through the tedious details fo the transformation, but rather demonstrate the use of it so you can take it away and put it in your "Pentaho toolbox". Let's dig right in.

...

Before you start, be sure you have the following resources.

• Pentaho Pre-configured Installation Demo Data
• Kettle, latest version 2.3.0
• MySQL Server, version 5.0+ Community Edition or other DB that supports "if"
• MySQL Connector/J, JDBC Driver for MySQL, version 3.1.2
• Kettle transformation used to move the data (Thanks, Nic Guzaldo)

Step By Step

...

If you have any troubles with this tip, or you just want to send some feedback, please post to Pentaho forums at http://forums.pentaho.orglogin and add your comments here.

kind regards,
Gretchen Moran