How to install Pentaho Business Analytics platform 5

In this tutorial we are going to see how to install Pentaho Business Analytics Platform 5. The so called Pentaho BI-Server 5 is the front-end tool of the Pentaho Suite that develop a pure (and complete) user interface to use all the different analytical tools developed by the Suite.

If you have a Linux based operating system or a Windows based platform, the tutorial should work in any case because, you will see, the steps are very simple and easy and not related on the platform.

This tutorial describes the default installation using the HSQL database for the security storage. If you want to know how to install it using MySql database instead, I suggest this tutorial made by David Fombella.

Prerequisites

Before start to install the Pentaho BI-Server 5 you have to check to have Java installed in you system. To check it, you have simply to execute the command below from a terminal.

java -version

If you don’t have it, below you can find a tutorial on how to install it. Please, remember that Pentaho BI-Server 5 requests Java7.

Download and install Pentaho Business Analytics Platform 5 Community Edition

After Java7 is available into your system, you have to download the Pentaho BI-Server 5 package from the official website or the sourceforge web page. In our case we are going to install the Pentaho Business Analytics 5 Community Edition.

Once the ‘biserver-ce-5.0.1-stable.zip’ file will be downloaded in the system, unzip it on the desktop or everywhere else you will like. All the Pentaho Business Analytics 5 tool is available in a folder described below:

biserver-ce

Probably you cannot believe me but this is enough to install Pentaho Business Analytics 5 into your system. 😉

First run and access to the user interface

Pentaho Business Analytics 5 is mainly a web application deployed in a tomcat servlet container. You can easily run the Pentaho Business Analytics 5, opening a terminal and executing the ‘start-pentaho’ script stored in the ‘biserver-ce’ folder (the one with the ‘sh’ extension for the Linux based operating systems and the one with the ‘bat’ extension for the Windows based operating systems).

To check what is happening to the web application, you can see at the log in the file described below.

<biserver-ce>/tomcat/logs/catalina.out

Once, the application is started, you can access to the user interface using a web browser at the link below.

http://<server>:8080/pentaho

With the Community Edition is suggested to use Mozilla Firefox or Google Chrome instead of MS IE Explorer (not well supported today).

To access as administrator you can use the ‘admin’ user with password ‘password’.

After the first run you are ready to use it.. for example with the A.A.A.R. solution. 😉

Advertisements

30 thoughts on “How to install Pentaho Business Analytics platform 5

  1. You not show the environmental variable settings. My console blinks and goes away when I run on windows

  2. Hi,

    What are the minimum system requirements for running the Pentaho Business Analytics, Data Integrator on Linux Box? How would that differ in case we go for pentaho on hadoop plugin?

    Thanks

    • Hi Vineet,

      In both cases it strictly depends on what you are doing with the server (ETL, analysis, ecc.). You can start on a development environment even with 1Gb of RAM with a single processor (talking about storage: it depends on your data). In a production environment an evaluation of the needs must be done.

      The good news is that the architecture is scalable. 😉

  3. got it, i had a entry in my interface for a wrong ip address that tomcat was pointing to… do you know a good resource on how to configure ldap authetication for pentaho 5.0, i’m trying to migrate from 4.8 to 5.0?

  4. Hi Francesco,
    I’m trying to install on my machine and gives me the following error when I run it on my browser:

    The following errors were detected
    [pt_49] One or more system listeners failed. These are set in the systemListeners.xml.
    org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 – [pt_71] Error while trying to execute startup sequence for org.pentaho.platform.repository2.unified.BackingRepositoryLifecycleManagerSystemListener

    Any idea?
    Thanks
    Luis

  5. Hi,
    I set all the variables (java 1.7_51 X64), update the pentaho_admin in web.xml, and start Pentaho 5.0.1 for the first time (no changes to database etc.). Catalina start correctly but at the login I get this message:

    [pentaho.log]
    “2014-04-13 09:52:31,462 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 – Resource /jpivot/jpivot/messages_supported_languages.properties not found in plugin jpivot”

    Please, how can i fix it? I use a Windows 7 (X64). Thank you in advance.

    • Hi Giuseppe,
      The error you get is given in the current release of Pentaho.
      I did not investigate how to solve because I don’t usually use JPivot but, in my opinion, you can ignore it and go ahead with the use of the Pentaho suite.
      In other words: Pentaho is correctly installed.
      I hope this will help you.

      • Thank you, Francesco, it now works.
        Any suggestion for warning messages about “http get method…”?
        Dialog box doesn’t go away and user console doesn’t load.

  6. You are right, Francesco. Looking at logs I notice that pentaho is unable to find and load ESAPI.properties. When jersey application starts I get all the warning message about “http get method”. Any idea?

  7. Hi francesco, I’m a newer on linux and pentaho. When I execute start-pentaho.sh i get the following message:

    /home/pentaho/biserver-ce
    /home/pentaho/biserver-ce
    WARNING: Using java from path
    DEBUG: _PENTAHO_JAVA_HOME=
    DEBUG: _PENTAHO_JAVA=java
    The BASEDIR environment variable is not defined correctly
    This environment variable is needed to run this program

    How do I define that?

  8. Hi Francesco… How can I run the Pentaho BI without conflict with my already running Alfresco Server at the 8080 port? The problem is that I cannot run 2 tomcats at same time in the same server, so how can I solve that if the Pentaho doesn’t have a WAR file to be deployed together with the Alfresco’s Tomcat?

    • Hi Eduardo,
      I cannot imagine how to do exactly what you need, btw you cannot run Alfresco and Pentaho on the same tomcat, sorry!
      I suggest you to install Pentaho on a different sever/machine because this is a suggested and good practice to avoid problems of performance.
      I hope this will help you.

      • Got… I solved that problem… but a new one just rise… I’m not able to connect to my database using the Data_Integration… when I try to use the data integration directly in my server, I can make the connection… but running the data-connection in another machine, and trying to access thru internet, no deal… I know that the server is in touch, but something is avoiding the connection… can I send you my data-integration connection log? oh, man, what a mission to run the server under a MacOSX… some paths are different than Linux, and they are giving me a headache… I would like to make you a tip, if you want, when I solve my problem, to leave a full tutorial about how to run AAAR on a server under MacOSX : ) Its a mission, but we will get there! Thanks for your help…

  9. Hi Eduardo,
    During the last Alfresco Hackathon in Brussel (16th of May) another developer makes the AAAR run under Mac even if it is not tested on that platform. So, it is possibile! 🙂
    Your suggestion to develop a full tutorial on that, it’s amazing.
    Please, write me privately to define details and I’ll give you support.
    Cheers.

  10. Hi Francesco,

    Your blog states that in order to login as administrator use the user id of ‘admin’ and the password of ‘password’ in you installation blog of Pentaho 5.0.1. The Administrator User ID should be ‘Admin’ and not ‘admin’. Pentaho’s logins are apparently case sensitive.

    — Glenn

    • Hi Glenn,
      Thank you for sharing your experience.
      I always use the lower case login but it works with lower and uppercases (I mean the login, not the password).
      Probably it depends on the operating system…
      Cheers.

  11. Have you changed the default database hsql to mysql successfully?
    I tried many times but still cannot found the users table in mysql database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s