The sample data for 'steel wheels' solution is by default included in Pentaho. It is loaded into the hsql database which is accessible if you start the database by executing
pentaho/biserver/data/start_hypersonic.sh
or
pentaho/biserver/data/start_hypersonic.bat
If you wish to use MySQL to load the sample data, you can use the following data dump to load the data into MySQL:
sampledatadump.mysql
You can use the following command to load the data dump:
The following transformation was used to process the data from hsql into mysql database:
hprsnic-mysql-sampledata.ktr - this is a modified version of the transformation provided on the Pentaho Wiki.
To run this transformation, you will need to start the hypersonic database and define the target tables. Open the insert/update step and execute the SQL query as generated by PDI.
Resources
Pentaho Wiki - more info and the transformation to process two tables of sample data from hsql into mysql
