How to set up the Pentaho Business Intelligence Suite

Pentaho Business Intelligence Suite so far is the best freely available open-source Business Intelligence Tool. It integrates Kettle (data integration), Mondrian (OLAP server), Weka (data mining), jfreereport and a Tomcat Web server to publish business analytics.

Installation

  1. Download the latest version from Pentaho Community Web Site
  2. Extract it (e.g., ”/opt”)
  3. Grant execution rights to the BI folder and substructure

     chmod u+x bi-folder -R
  4. Make sure your JAVA_HOME variable is set properly and add it to your path by

     echo $JAVA_HOME
     export JAVA_HOME=/path/to/my/java/lib (e.g., /usr/lib/jvm/java-6-sun) 
     export PATH=$PATH:$JAVA_HOME

    Alternatively you can set your variables in .bashrc.

  5. Add BI paths (admin console & BI server) to your system PATH to be executable from everywhere
  6. Now you can start BI by executing start-pac.sh (only works if started within the admin-console folder) for the admin console and start-pentaho.sh for the BI server.

Database Connection

  1. Copy your data base JDBC driver into the BI folders, e.g.:

     /opt/biserver-ce-3.7.0-stable/administration-console/jdbc
     /opt/biserver-ce-3.7.0-stable/biserver-ce/tomcat/lib
  2. Optional you can migrate the sample repository into your DB. See the README.txt in biserver-ce/data/ in your BI folder.
  3. After starting the Administrator Console you can easily add a new data connection
    • Insert connection name
    • Select appropriate driver class
    • Insert DB user name & password
    • Define URL according to following syntax:
      jdbc:[DB-Type(e.g.mysql, postgresql)]://[host][,failoverhost...][:port]/[database] 
       # e.g.: jdbc:postgresql://localhost:5432/mydb

Leave a Reply