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
 * 1) 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
 * 1) !/bin/bash


 * 1) chkconfig: 2345 90 60

cd "/opt/biserver-ce/"
 * 1) Pentaho service controller script

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

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