Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: This Page was contributed by Yassine Elassad


Setting up the databases required by



Pentaho requires 3 databases which are more or less mandatory these are:


so if you dont have an other user in postgresql who you want to use you need to replace every occurance occurrence of tomcat with your own

user before importing the files 

one point i I would like to add is how i I created this sql files: first i I converted from hsqldb to mysql and than from mysql to postgresql 

it was a bit pain full process, but now pentaho Pentaho works and thats that's good. please Please be warned that the sampledata is not 100% well converted so you may encounter


you can these are my samples for jboss i I will add tomcat context.xml in the near future 

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