...
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
...