Pentaho

Pentaho

Pentaho - http://www.pentaho.com/

A Comprehensive Platform for Data Integration & Business Analytics

Pentaho Community Edition

Pentaho Community Edition - http://community.pentaho.com/

Business Analytics Platform:

"Pentaho's modern, simplified, and interactive approach empowers business users to access, discover and blend any data types regardless of their size. With a full spectrum of increasingly advanced analytics tools, from basic reports to predictive modeling, users can help themselves to analyze and visualize data across multiple measures and dimensions without being dependent on IT."

Pentaho Open Source BI Suite Community Edition (CE) - http://wiki.pentaho.com/display/COM/Community+Wiki+Home

==

Community User Guide - http://wiki.joanillo.org/images/1/11/Community_user_guide.pdf

wget http://downloads.sourceforge.net/project/pentaho/Data%20Integration/5.2/pdi-ce-5.2.0.0-209.zip
unzip pdi-ce-5.2.0.0-209.zip
mv data-integration pdi-ce-5.2.0.0-209
ln -s pdi-ce-5.2.0.0-209 data-integration
cd data-integration
rm -f *bat

Installation

Download Pentaho Business Intelligence Server from SourceForge.net - http://sourceforge.net/projects/pentaho/ -> "Files" -> "Business Intelligence Server" -> "5.2"

• http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/
• http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.2/biserver-ce-5.2.0.0-209.zip/download

Quick Install:

cd /opt
wget http://downloads.sourceforge.net/project/pentaho/Business%20Intelligence%20Server/5.2/biserver-ce-5.2.0.0-209.zip
unzip biserver-ce-5.2.0.0-209.zip
mv biserver-ce biserver-ce-5.2.0.0-209
ln -s biserver-ce-5.2.0.0-209 pentaho
cd pentaho
rm -f *bat
./start-pentaho.sh
# hit enter to start initial

Connect to port 8080 from a browser:

site: http://pentaho.oeey.com:8080    (example domain)
user: admin
pass: password

Installed Version

$ cat tomcat/webapps/pentaho/WEB-INF/classes/server-assembly.properties
...
assembly.version=5.2.0.0-209

Evaluator Accounts

Administrator

User Name: Admin
Password: password

Business User

User Name: Suzy
Password: password

init script

/etc/init.d/pentaho

#!/bin/bash

# chkconfig: 2345 90 60

# Pentaho service controller script
cd "/opt/biserver-ce/"

case "$1" in
    start)
        ./start-pentaho.sh
        ;;
    stop)
        ./stop-pentaho.sh
        ;;
    *)
        echo "Usage: $0 {start|stop}"
        exit 1
        ;;
esac

version checker

The Pentaho BI Platform now contains a version checker that will notify you when newer versions of the software are available. The version checker is enabled by default. For information on what the version checker does, why it is beneficial, and how it works see: http://wiki.pentaho.com/display/ServerDoc2x/Version+Checker

import export data

export data

./import-export.sh \
--export --url=http://localhost:8080/pentaho --username=admin \
--password=password \
--file-path=/root/backup.zip --charset=UTF-8 --path=/public \
--withManifest=true --logfile=/root/logfile.log

import data

./import-export.sh \
--import --url=http://localhost:8080/pentaho --username=admin \
--password=password --charset=UTF-8 --path=/public \
--file-path=/root/backup.zip \
--logfile=/root/logfile.log \
--permission=true \
--overwrite=true \
--retainOwnership=true

Upgrade Pentaho

Upgrade BA Systems - http://infocenter.pentaho.com/help/index.jsp?nav=%2F9_1

Uses "migration" tool and is a pretty intensive process.

keywords

Pentaho business paralytics