Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Overal reformating.

Setting up the databases required by Pentaho 

Pentaho requires 3 databases which are more or less mandatory


. These are:



Sql Script



is used Used for bursting and similar tasks




database Database which is the main pentaho scheduler (think about it as a cron-like tool that stores its cron jobs in the database)




is the The persistence layer used by pentaho




if If you are on production you may not need it, but you will need it for demonstration and seeing whats what is new in pentaho you will need it Pentaho.



please Please note that the sql files above REQUIRES you to edit them since the database are created and are owned by the tomcat userso . So, if you dont have an other another user in postgresql PostgreSQL who you want to use then you need will have to replace every occurrence of tomcat with your own user before importing the files .

one One point I would like to add is how I have created this sql SQL files: first I converted them from hsqldb HSQLDB to mysql MySQL and than then from mysql to postgresql it MySQL to PostgreSQL. It was a bit pain full painfull process, but now Pentaho works and that's good. Please be warned that the sampledata is not 100% well converted so you may encounter some problem with it, this . This is a task that still needs to be done to finalize the sampledata.

loading the data into postgresql:

create Create the dabases above empty and assuming databases. Assuming your user is tomcat you would do that as following:

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


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 Now your postgresql PostgreSQL should be ready the . The next step is to configure the datasources required to access the data.

you You can these are my samples for jboss I will add tomcat context.xml in the near future make future (???)

Make sure your driver is in the right location and start up startup your application server where Pentaho is deployed into into