Saturday, December 20, 2008

Setup the new BI server 2.0 in Linux-Ubuntu

1- Setup the Java environment
This new BI server version 2 installation and using is really more straightforward. You first need to install the last version of the Java Development Kit or Java Runtime Environment from the Synaptic Package Manager. To do this, go to System > Administration > Synaptic Package Manager. You will be prompted for your administrator password before the package manager window open.
Look for the sun-java6-jdk. Right-click and select Mark for Installation. Then click the Apply button in the toolbar. The Synaptic Package Manager will download all the necessary files and take care of the installation process automatically.

2- Setup the environment variables
You only need to setup to environment variable JAVA_HOME and JRE_HOME and make them persistent.
In you .profile file in your folder (this file is normally hidden), add the 2 following lines:
  • export JAVA_HOME=/usr/lib/jvm/java6_xxx
  • export JRE_HOME=/usr/lib/jvm/java6_xxx/jre
Then from your terminal, go to your BI server folder that you have downloaded (I dowloaded this file version for the matter of this tutorial: biserver-ce-2.0.0-RC1.tar.gz) and unzipped in your user folder. Then from the terminal window, go to your new installation folder and from there, you can start your BI server with the following command:
./start-pentaho.sh
To stop it, type in:
./stop-pentaho.sh
As you will see, this Community Release of the BI 2.0 server is embedded with hsqldb as the database server with some sample data and Apache Tomcat as the application server.

No comments: