1. Download pentaho BI Server
Follow the below
steps to download the pentho BI server
1.
Open the browser and access the
below URL. You will find all the available versions of pentaho BI. Click on the
latest version available(6.1)
2.
You will be redirected to a
page which contains the biserver-manual and biserver-ce- downloader’s.
Click on “biserver-ce-6.1.0.1-196.zip”
to download the business integration server
3.
The will download a zip file containing
the business intelligence server
2. Copy the Installers
1.
Login to the server where we have to install pentaho BI by
giving proper credentials
2.
Create a directory “pentaho_installer”
in the root directory and copy the biserver zip file downloaded in the previous
steps.
3.
JDK Installation
Install the JDK
and set the environment variables following the instructions in “Pentaho ETL Installation Linux”.
4.
BI Installation
1.
Navigate to / pentaho_installer/ and run the below command
Commad: unzip
biserver-ce-6.1.0.1-196.zip -d /pentaho/
2.
The will create biserver-ce folder
as shown below
5.
Creating postgres schema
1.
Download the script files from
the below location
/pentaho_installer/
2.
Run the below command to create
the pentaho DB repository.
psql -U postgres -f "/pentaho_installer/create_jcr_postgresql.sql"
psql -U postgres -f "/pentaho_installer/create_quartz_postgresql.sql"
psql -U postgres -f "/pentaho_installer/
create_repository_postgresql.sql"
6.
JNDI configuration
1.
Edit the context.xml(/pentaho/biserver-ce/tomcat/webapps/pentaho/META-INF/context.xml) file and add the below JNDI connections
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="bi_hibuser" password="xxxx"
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/bi_hibernate"
validationQuery="select 1" />
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="bi_pentaho_user" password="xxxx"
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/bi_quartz"
validationQuery="select 1"/>
</Context>
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="bi_hibuser" password="xxxx"
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/bi_hibernate"
validationQuery="select 1" />
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxTotal="20" maxIdle="5"
maxWaitMillis="10000" username="bi_pentaho_user" password="xxxx"
driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/bi_quartz"
validationQuery="select 1"/>
</Context>
8. Audit configuration
1.
Copy the audit_sql.xml file to the below location
Source
/pentaho/biserver-ce/pentaho-solutions/system/dialects/postgresql/audit_sql.xml
Target
/pentaho/biserver-ce/pentaho-solutions/system
9. Hibernate configuration
1.
Edit the /pentaho/biserver-ce/pentaho-solutions/system/hibernate/hibernate-settings.xml file and edit the below based property
<config-file>system/hibernate/postgresql.hibernate.cfg.xml</config-file>
2. Edit postgresql.hibernate.cfg.xml and change the DB connections details to match the portgres database
<hibernate-configuration>
<session-factory>
<property name="cache.provider_class">net.sf.ehcache.hibernate.SingletonEhCacheProvider</property>
<property name="hibernate.generate_statistics">true</property>
<property name="hibernate.cache.use_query_cache">true</property>
<!-- Postgres 8 Configuration -->
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://localhost:5432/bi_hibernate</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.username">bi_hibuser</property>
<property name="connection.password">xxxx</property>
<property name="connection.pool_size">10</property>
<property name="show_sql">false</property>
<property name="hibernate.jdbc.use_streams_for_binary">true</property>
<!-- replaces DefinitionVersionManager -->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- load resource from classpath -->
<mapping resource="hibernate/postgresql.hbm.xml" />
</session-factory>
</hibernate-configuration>
<config-file>system/hibernate/postgresql.hibernate.cfg.xml</config-file>
2. Edit postgresql.hibernate.cfg.xml and change the DB connections details to match the portgres database
<hibernate-configuration>
<session-factory>
<property name="cache.provider_class">net.sf.ehcache.hibernate.SingletonEhCacheProvider</property>
<property name="hibernate.generate_statistics">true</property>
<property name="hibernate.cache.use_query_cache">true</property>
<!-- Postgres 8 Configuration -->
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="connection.url">jdbc:postgresql://localhost:5432/bi_hibernate</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="connection.username">bi_hibuser</property>
<property name="connection.password">xxxx</property>
<property name="connection.pool_size">10</property>
<property name="show_sql">false</property>
<property name="hibernate.jdbc.use_streams_for_binary">true</property>
<!-- replaces DefinitionVersionManager -->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- load resource from classpath -->
<mapping resource="hibernate/postgresql.hbm.xml" />
</session-factory>
</hibernate-configuration>
10.
Configuring the memory parmeters
1.
Navigate to the path /pentaho/biserver-ce/
and edit the below file
start-pentaho.sh and add the highlighted content. Change
the Xms and Xmx depending on the requirement
CATALINA_OPTS="-Djava.security.egd=file:/dev/./urandom -Xms2048m -Xmx6144m
-XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000
-Dsun.rmi.dgc.server.gcInterval=3600000 -Dfile.encoding=utf8
-DDI_HOME=\"$DI_HOME\""
11.
Remove evaluate user list
Edit the file
/pentaho/biserver-ce/pentaho-solutions/system/pentaho.xml and change the below
Before
<login-show-users-list>true</login-show-users-list>
<login-show-sample-users-hint>true</login-show-sample-users-hint>
After
<login-show-users-list>false</login-show-users-list>
<login-show-sample-users-hint>false</login-show-sample-users-hint>
12.
Install saiku analysis plugin
1.
Download the saiku analysis plugin by using the below URL.
You can find the latest version of the plugin on the pentaho marketplus URL(http://www.pentaho.com/marketplace/)
Saiku Plugin Download URL
2.
Copy the saiku plugin
downloaded in the above step to /pentaho_installer/ folder
3.
Unzip the plugin by running the
below command
unzip
saiku-plugin-p6-3.8.8.zip -d /pentaho/biserver-ce/pentaho-solutions/system/
4. Download the license file using the below link http://licensing.meteorite.bi .
You need to sign up and create a license file for community edition.and
copy it to the below location
/pentaho/biserver-ce/pentaho-solutions/system/saiku/ license.lic
13.
Starting the pentaho BI server
Navigate to path
/pentaho/biserver-ce and run the below command. On the first start you will get
a version checker message just press enter to continue
Command: sh start-pentaho.sh
