Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Database

Description

Sql Script

Mandatory

Shark

Used for bursting and similar tasks

PentahoDoc:Shark.sql

YES

Quarz Quartz

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

PentahoDoc:Quarz.sql

YES

Hibernate

The persistence layer used by pentaho

hibernate.sql

YES

sampladata sampledata

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

sampledata.sql

No

...

Code Block
tomcat@anfatech:~$ psql -U tomcat -d hibernate < hibernate.sql
tomcat@anfatech:~$ psql -U tomcat -d quartz < quarzquartz.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.

You can these are my use my settings as an example: PentahoDoc:samples for jboss

 sorry for the dead link (my homepage habe has been token over) now i uploaded the templates to the wiki so they should be fine there!

...

instead of messing with config files in conf/server.xml  or even worst worse creating a file under $CATALINA_HOME/conf/Catalina/localhost/yourApplication.xml

...

(**2**) : if you deploy your application to tomcat defualt default webapps so your docbase shoud be like the following one:

Code Block
      docBase="${catalina.home}/webapps/pentaho

when you finnished finished creating your context.xml you can then package your war and deploy it to tomcat. the context.xml of your application will get converted to applicationName.xml for the application name pentaho as shown above the resulting file will be this one:

...