...
Pentaho requires 3 databases which are more or less mandatory these are:
...
Database | Description | Sql Script | Mandatory |
|---|---|---|---|
Shark | is 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 | is the persistence layer used by pentaho | YES | |
sampladata | if you are on production you may not need it but for demonstration and seeing whats new in pentaho you will need it | No |
please note that the sql files above REQUIRES you to edit them since the database are created and are owned by the tomcat user
so if you dont have an other user in postgresql who you want to use you need to replace every occurance of tomcat with your own
user *before importing the files*
one point i would like to add is how i created this sql files: first i converted from hsqldb to mysql and than from mysql to postgresql
...
| Code Block |
|---|
postgres@anfatech:~$ createdb shark \-O tomcat postgres@anfatech:~$ createdb quartz \-O tomcat postgres@anfatech:~$ createdb hibernate \-O tomcat postgres@anfatech:~$ createdb sampledata \-O tomcat |
and import the scripts above into the appropriate database as following
| Code Block |
|---|
tomcat@anfatech:~$ psql \-U tomcat \-d hibernate < hibernate.sql tomcat@anfatech:~$ psql \-U tomcat \-d quarz < quarz.sql tomcat@anfatech:~$ psql \-U tomcat \-d shark < shark.sql tomcat@anfatech:~$ psql \-U tomcat \-d hibernate < sampledata.sql |
now your postgresql should be ready the next step is to configure the datasources required to access the data
Wiki Markup
make sure your driver is in the right location and start up your application server where pentaho is deployed into