...
- Unzip the Pentaho demo data to a working directory on your machine. Start the database using the start_hypersonic.bat|.sh file in the demo data root directory.
- Unzip Kettle to a working directory on your machine. Start Kettle's Spoon application using the Spoon.bat|.sh file in the Kettle root directory.
- Download the attached transformation to your working directory and load it into Spoon using the File|Open menu options in Spoon. You should see a transformation similar to this:
- This transform will access the data in the DEPARTMENT_MANAGERS and QUADRANT_ACTUALS tables in the demo HSQLDb tables, and copy it into a new database named "sampledata" in MySQL. We have the HSQLDb database up and running, but we need to create a few things on the MySQL side before we run the transformation.
- First, log in to your MySQL server, and create a database named "sampledata". Grant access to pentaho_user (password "password") to administer (create tables, insert data) this new database.
- Next, in Spoon, from the Transformation menu at the top of the screen, click the menu item Get SQL. You should be prompted with a dialog that has two create table statements in it. This is the SQL to create the tables in MySQL for you.
- From the dialog, select Execute SQL. You should now have a DEPARTMENT_MANAGERS and QUADRANT_ACTUALS table in your MySQL sampledata database.
- In Spoon, from the Transformation menu at the top of the screen, click the menu item Run. This executes the transformation, which copies the data from the HSQLDb to the MySQL database.
That's all there is to it! Your MySQL database should be populated with the sample data.
Note that the transformation's database connection information makes a few assumptions, not the smallest being that the databases are local, you are logging in to them with the pentaho_user, etc. You can find and tweak these parameters by clicking on a step in the transformation and clicking the edit button next to the connection information.
If If you have any troubles with this tip, or you just want to send me some feedback, please post to Pentaho forums at http://www.pentaho.org/discussion, or contact me at<!-- var prefix = 'ma' + 'il' + 'to'; var path = 'hr' + 'ef' + '='; var addy10913 = 'commnityconnection' + '@' + 'pentaho' + '.' + 'org'; var addy_text10913 = 'commnityconnection' + '@' + 'pentaho' + '.' + 'org'; document.write( '<a ' + path + '\'' + prefix + ':' + addy10913 + '\'>' + addy_text10913 + '</a>' ); //-->commnityconnection@pentaho.org This email address is being protected from spam bots, you need Javascript enabled to view itforums.pentaho.org.
kind regards,
Gretchen Moran