Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Shark.sql

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)

Quarz.sql

YES

Hibernate

is the persistence layer used by pentaho

hibernate.sql

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

sampledata.sql

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 Markupyou can these are my \[samples for jboss\|http://www.anfatech.com/blogs/categories/yassines-tech-blog/stuff/posgres-ds.zip\] i will add tomcat context.xml in the near future&nbsp;future 

make sure your driver is in the right location and start up your application server where pentaho is deployed into