Hitachi Vantara Pentaho Community Wiki
Child pages
  • Configuring for PostgreSQL

Versions Compared

Key

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

...

Database

Description

Sql Script

Mandatory

Shark

Used for bursting and similar tasks

PentahoDoc: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)

PentahoDoc:Quarz.sql

YES

Hibernate

The persistence layer used by pentaho

hibernate.sql

YES

sampladata

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

...

Now your PostgreSQL should be ready. The next step is to configure the datasources required to access the data.

You can these are my PentahoDoc:samples for jboss

 sorry for the dead link (my homepage habe been token over) now i uploaded to the templates to the wiki so they should be fine there fine!I will add tomcat context.xml in the near future (???)!

Configuring pentaho's datasources for Tomcat 5.5.x and Higher, using context.xml

if you plan to deploy on tomcat then you better use what tomcat offers you:

...

Code Block
 pentaho
|-- META-INF
|   `-- context.xml  <---(***1***)
`-- WEB-INF
    `-- web.xml

(**1**): this file "context.xml" will be processed by tomcat *at deployment time and if you define your datasources there, tomcat
will do the necessary configurations for you. an

An example of a valid context.xml file will should be looking like the following one:

Code Block
<Context     path="/pentaho"
               docBase="path/to/pentaho" <---(***2***)
               debug="5"
               reloadable="true"
               crossContext="true">   
    <Resource   name="jdbc/Quartz"
                auth="Container"
                type="javax.sql.DataSource"
                maxActive="100"
                maxIdle="30"
                maxWait="10000"
                username="username"
                password="password"  
                driverClassName="org.postgresql.Driver"
                url="jdbc:postgresql://localhost:5432/target-database"/>   
<!--
    You can add as many datasources as you need here

-->
</Context>

(**2**) : the docBase in tomcat is mostly something like this if you deploy your application to tomcat defualt webapps so your docbase shoud be like the following one:

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

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

Code Block
 $CATALINA_HOME/conf/Catalina/localhost/pentaho.xml

if your database are correctly set and everything went fine pentaho should be able to access the databases using the datasource defined in the context.xmlMake xml

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

Configuring the Quartz Scheduler:

...