Setting up the databases required by Pentaho
Pentaho requires 3 databases which are more or less mandatory. These are:
Used for bursting and similar tasks
Database which is the main pentaho scheduler (think about it as a cron-like tool that stores its cron jobs in the database)
The persistence layer used by pentaho
If you are on production you may not need it, but you will need it for demonstration and seeing what is new in Pentaho.