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
-
Download the latest version from Pentaho Community Web Site
-
Extract it (e.g., ”/opt”)
-
Grant execution rights to the BI folder and substructure
chmod u+x bi-folder -R
-
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.
-
Add BI paths (admin console & BI server) to your system PATH to be executable from everywhere
-
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
-
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
-
Optional you can migrate the sample repository into your DB. See the README.txt in biserver-ce/data/ in your BI folder.
-
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
-