Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Wednesday, 15 January 2014

Installation of pentaho BI server 5.0.1 CE along with C-Tools , Saiku Analytics on remote ubuntu 12.04.3 LTS server

Hi guys,

In this post you'll learn about the installation pentaho BI CE server 5.0.1 in ubuntu server and then C-Tools(CDE,CDA,CDF,Saiku Analytics) installation

PART-I : Open JDK installation
PART-II : Pentaho 5.0.1 CE installation
PART-III : C-Tools,Saiku Analytics installation

 Pr-requisites 
1)Ubuntu Server
Find OS: lsb_release -a
Outupt : 
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 12.04.3 LTS
Release:        12.04
Codename:       precise

2) Windows 7 64 bit -PuTTY 
Login to the PuTTY using given username and password
Username would be : IP address ( for eg :71.221.143.168)
Password would be : Password (for eg : adminsadakar)

3) Mozilla firefox(Preferrable for pentaho)
Version 25.0.1

If you have given .pem file convert it into .ppk file and add this file. 

You need to install java and set JAVA_HOME for before you install pentaho server.

PART- I JAVA (Open - JDK)- Installation 


Installation of JAVA(Open JDK) in ubntu server
 
NOTE : You must issue sudo(Superuser do) permission before you ready to install java
Command : sudo su
In the next line : You need to issue the password that you used for log-ing using PuTTY.

* Install Open JDK and JRE using the below commands
 1) JRE installation command
      apt-get install openjdk-7-jre

2) JDK installation comman

       apt-get install openjdk-7-jdk

3) Find whether java installed or not 
   which java
  Ouptut
  /usr/bin/java

4) Find which version installed
  java -version  
Ouput 
  java version "1.7.0_25"
 OpenJDK Runtime Environment (IcedTea 2.3.10) (7u25-2.3.10-1ubuntu0.12.04.2)
 OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)


IMP: NOTE-1
You need NOT to set JAVA_HOME if you see the above message(when you issue java -version) for ubntu server, at the time of java installation it will set the JAVA_HOME.
This may differ from version to version for ubntu server.

NOTE-2
By default the open JDK install in the below location 
/usr/lib/jvm/ 

NOTE-3 ( Optional - set java_home)
References: 
1) http://blog.manishchhabra.com/2012/05/installing-oracle-sun-java-jdk-and-setting-java_home-in-ubuntu-linux/
2) http://askubuntu.com/questions/321422/how-to-setup-java-home-and-path-in-ubuntu-12-04
 
Open .bashrc file using an editor. If you use VI then
vi ~/.bashrc
and add the following 2 lines in your .bashrc file.
JAVA_HOME=/usr/lib/jvm/jdk1.7.0_21/
export JAVA_HOME

PART- II Pentaho 5.0.1 CE installation 

1) Create a folder under home
   mkdir pentaho


2) Issue the below command to down load pentaho zip file from sourceforgesite 
 wget http://sourceforge.net/projects/pentaho/files/Business Intelligence Server/5.0.1-stable/biserver-ce-5.0.1-stable.zip/

3)  Unzip the file
i) Once the down load is completed you will be getting "biserver-ce-5.0.1-stable.zip"  zip file under  pentaho

ii) unzip the file using below command
    unzip biserver-ce-5.0.1-stable.zip
NOTE: if unzip is not installed in ubuntu server issue the below command to install unzip package

sudo apt-get install unzip
4) biserver-ce  folder
i) Once unzip completed you will be getting a folder biserver-ce
ii) Do the follwoing

root@SADA-KAR-167:/home/pentaho# cd biserver-ce
root@SADA-KAR-167:/home/pentaho/biserver-ce# ls
OUTPUT
data               import-export.sh  pentaho-solutions  set-pentaho-env.bat  start-pentaho.bat        start-pentaho-debug.sh  stop-pentaho.bat  third-party-tools
import-export.bat  licenses          promptuser.js      set-pentaho-env.sh   start-pentaho-debug.bat  start-pentaho.sh        stop-pentaho.sh   tomcat


NOTE : You need to give the permissions to the .sh files to run
Issue below command : chmod -R 777
For full information of chmod refer here :

5) Start the bi server using below command

root@SADA-KAR-167:/home/pentaho/biserver-ce# ./start-pentaho.sh
OUTPUT
/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE:   /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME:   /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME:        /usr
Using CLASSPATH:       /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
 

NOTE: stop the server by issuing this command
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./stop-pentaho.sh

root@ONE-DMZ-SRV161:/home/pentaho/biserver-ce# ./stop-pentaho.sh
/home/pentaho/biserver-ce
/home/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE:   /home/pentaho/biserver-ce/tomcat
Using CATALINA_HOME:   /home/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME:        /usr
Using CLASSPATH:       /home/pentaho/biserver-ce/tomcat/bin/bootstrap.jar


6) Go the web-browser and give the below URL
http://YourHost:8080/pentaho
Example : 71.221.143.168:8080/pentaho

NOTE: pentaho by default uses 8080 port number.

Credentials you need to supply once you get the home page are :
User name : Admin
Password : password


PART- III C-Tools(CDE, CDF & CDA) & Saiku Analytics installation.

1) Go to the Market place ( HOME--> MarketPlace)

2) Install CDF first( by default it installs with pentaho installation - if you have any latest version in the detail list upgrade to new one).

3) Click on Install to install CDA with the latest version.
 Version
TRUNK-SNAPSHOT
4) Click on Install to install CDE with the latest version.
Version
TRUNK-SNAPSHOT
 5) Click on Install for Saiku installaiton
Version
2.6-PENTAHO5-SNAPSHOT
NOTE : CDF, CDA are two dependencies you must install before installing CDE.



6) Once you install the required tools from Market place you must restart the petnaho server other wise you can not find the installation of tools. 
Stop server:
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./stop-pentaho.sh
Start server:
root@SADA-KAR-167:/home/pentaho/biserver-ce# ./start-pentaho.sh

References :
JAVA installation : http://openjdk.java.net/install/
Pentaho installaton :  http://community.pentaho.com/


Thank you for reading this post.
If you have any queries drop your comments in comments box.