Hi guys..!!!
This post teach you how to install the pentaho BA server in windows machine.
1. Download pentaho from sourceforge site
http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/4.8.0-stable/biserver-ce-4.8.0-stable.zip/download
2. Extract the zip file in your fav location.
3. You will get two folders : administration-console & biserver-ce
Adminstration-console purpose : You will give database connections here .
User Console : (biserver-ce) : Core of the server UI .. You will analysis the date
4. Run the start-pentaho.bat file in biserver-ce
location of file : your_location_of_drive\biserver-ce-4.8.0-stable\biserver-ce
NOTE: By default pentaho server runs on 8080 port number. If you wish to change the default port number to your desired one you can do that in server.xml file which is located in conf folder of tomcat
Type this URL in any browser : http://localhost:8080/pentaho.. you will prompted to the login page of server. check for the logs if you find any errors.
5. Stop the server : stop-pentaho.bat in the same location of step 4
How to run the Adminstration console
Run the start-pac.bat file in adminstraion-console folder
location of file :your_location_of_drive\biserver-ce-4.8.0-stable\administration-console
Stop the server : click on stop-pac.bat in the same location of above step.
Where the problems comes into picture ??
You will only get the problem if you don't know how to install the java software and correct path settings for java
Install java software and set the path,classpath,java_home,jre_home
This post will teach you how to set all the things.
http://pentaho-bi-suite.blogspot.in/?view=classic
Admin console Problem:
Edit the console.properties file located in {CONSOLE_HOME}\resource\config}
Notice that the console.ssl.enabled properties is set to false.
Change that value to true. By default keytore and trustore path is
resource/config and password for them is changeit. If you have something
different you can edit the ssl section for the correct value. Remember
that the default port for pentaho administration console https is 8143,
so if you want to change it then you can do this right here in the
properties file
http://wiki.pentaho.com/display/ServerDoc1x/Enabling+SSL+in+Pentaho+Administration+Console
NOTE:
There are many ways of installing pentaho bi server. This is a simple installation of bi server.
Navigate in http://pentaho-bi-suite.blogspot.in site.. I have posted other installation methods which worked successfully.
Sadakar.P
BI developer
("Learning never exhausts the mind")
This post teach you how to install the pentaho BA server in windows machine.
1. Download pentaho from sourceforge site
http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/4.8.0-stable/biserver-ce-4.8.0-stable.zip/download
2. Extract the zip file in your fav location.
3. You will get two folders : administration-console & biserver-ce
Adminstration-console purpose : You will give database connections here .
User Console : (biserver-ce) : Core of the server UI .. You will analysis the date
4. Run the start-pentaho.bat file in biserver-ce
location of file : your_location_of_drive\biserver-ce-4.8.0-stable\biserver-ce
NOTE: By default pentaho server runs on 8080 port number. If you wish to change the default port number to your desired one you can do that in server.xml file which is located in conf folder of tomcat
Type this URL in any browser : http://localhost:8080/pentaho.. you will prompted to the login page of server. check for the logs if you find any errors.
5. Stop the server : stop-pentaho.bat in the same location of step 4
How to run the Adminstration console
Run the start-pac.bat file in adminstraion-console folder
location of file :your_location_of_drive\biserver-ce-4.8.0-stable\administration-console
Stop the server : click on stop-pac.bat in the same location of above step.
Where the problems comes into picture ??
You will only get the problem if you don't know how to install the java software and correct path settings for java
Install java software and set the path,classpath,java_home,jre_home
This post will teach you how to set all the things.
http://pentaho-bi-suite.blogspot.in/?view=classic
Admin console Problem:
Edit the console.properties file located in {CONSOLE_HOME}\resource\config}
console.properties
\# Pentaho Administration Console's Jetty Server Settings
console.start.port.number=8088
console.hostname=localhost
console.stop.port.number=8033
\# SSL Section for Pentaho Administration Console
console.ssl.enabled=false
console.ssl.port.number=8143
keyAlias=jetty
keyPassword=changeit
keyStore=resource/config/keystore
keyStorePassword=changeit
trustStore=resource/config/keystore
trustStorePassword=changeit
wantClientAuth=false
needClientAuth=false
\# Security Authentication Section for Pentaho Administration Console
console.security.enabled=true
console.security.roles.allowed=admin
console.security.roles.delimeter=,
console.security.realm.name=Pentaho
console.security.login.module.name=PropertiesFileLoginModule
console.security.auth.config.path=resource/config/login.conf
http://wiki.pentaho.com/display/ServerDoc1x/Enabling+SSL+in+Pentaho+Administration+Console
NOTE:
There are many ways of installing pentaho bi server. This is a simple installation of bi server.
Navigate in http://pentaho-bi-suite.blogspot.in site.. I have posted other installation methods which worked successfully.
Sadakar.P
BI developer
("Learning never exhausts the mind")
Hi,
ReplyDeleteThank you very much for your article.
Could you please share your experience about connecting Data source using MS SQL Server 2008 R2?
I tried with Pentaho biserver-ce-4.8.0 by following steps:
1. Install JDBC driver
2. Add sqljdbc4.jar to ... tomcat/lib
3. Add sqljdbc_auth.dll to ...tomcat/lib to solve Window Authentication
But it still got error and I can not connect to my Database. :(
Could you please help me?
Thank you very much,
Mi Nguyen
This comment has been removed by the author.
DeleteHi Mikita..
DeleteTry to follow the below steps :
There are two folders in pentaho community edition installation.
1) Administration console
2) bi-server-CE.
* One of the basic purpose of Administration console is to deal with database connections.
* Whenever you want to connect to any data source like pgAdmin,mySQL,MS-SQL Server, DB2 and etc. you need to place the required jar files in 2 places.
* First place: i.e., In the lib folder of Administration-Console
-----------------------------------------------------------
In the following location
D:\Installation Softwares\Pentaho\biserver-ce-4.8.0-stable\administration-console\lib
*Second place : i.e, In the lib folder of tomacat folder of
-----------------------------------------------------------
biserver-ce
-----------------
i.e, in the following location.
D:\Installation Softwares\Pentaho\biserver-ce-4.8.0-stable\biserver-ce\tomcat\lib
* After placing this you must restart both the consoles.. In other words you need to restart the server.
i.e., stop the service in Administration console.
stop the service in tomcat(biserver-ce console)
Now, start both the services
i.e., start pentaho server service.. wait for the server startup...
start the Administration console.
Hope this might helpful.
Thanks
Hi Sadakar Pochampalli,
DeleteThank you very much for your help.
I copied 2 files sqljdbc4.jar and sqljdbc_auth.dll to administration-console and biserver-ce but still can not connect to MS SQL Server. The system informed that:
Error connecting to database (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)
This driver is not configured for integrated authentication
Could you please help me to find out the solution for this problem?
Thanks a lot,
Hope this may works for you :
ReplyDelete----------------------------------
http://www.davidtawater.com/thoughts/2011/first-experiences-with-pentaho/
Hi,
ReplyDeleteThank you very much for your help.
I tried but not yet solve this problem :(. Let me try other solutions.
Thanks a lot,
Hi.. Hope you'll get the solution as quick as possible. Could you also share the same once you get it in this blog ?
ReplyDeleteHi,
ReplyDeleteI solved Integrated problem by:
Copy sqljdbc_auth.dll to C:\Program Files\Java\jdk1.7.0_21\bin
and Copy sqljdbc.jar to tomcat\lib and jdbc (lib) folder in administration-console.
Also check some configurations follow this link:
http://infocenter.pentaho.com/help/index.jsp?topic=%2Fadmin_guide%2Ftask_adding_jndi_data_source.html
Now it's done.
Thank you very much for your support :)
:) Thanks for reading article :)
Delete