Kenneth: /* Installation */

2014-10-29T02:55:28Z

Installation

New page

== 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 ==

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

== Evaluator Accounts ==

Administrator
User Name: Admin
Password: password

Business User
User Name: Suzy
Password: password

== init script ==

/etc/init.d/pentaho
<pre>
#!/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
</pre>

== 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 ===

<pre>
./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
</pre>

=== import data ===

<pre>
./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
</pre>

== 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

Pentaho - Revision history

Kenneth: /* Installation */