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