07 Jan

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. 😉

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

  1. 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

    • Francesco Corti

      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. 😉

  2. 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?

  3. 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

  4. 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.

    • Francesco Corti

      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.

  5. 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?

  6. 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?

  7. 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?

    • Francesco Corti

      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…

  8. Francesco Corti

    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.

  9. 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

    • Francesco Corti

      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.

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

  11. Hi,

    Does anyone answer why PENTAHO COMMUNITY EDITION works only in JAVA 7, not in JAVA 8? Please help me with your valuable answer. Early waiting for your reply.

    Regars,
    Naveen.

    • Francesco Corti

      Hi Naveen,
      When Pentaho 5 has been released the Java 8 didn’t exist.
      It’s quite common, on big projects or products roadmap, that core layers (like Java is) are updated in major releases.
      IMHO it’s a matter or certification path, and not a matter of technical issue.
      You can try to run Pentaho CE with Java 8 but nothing is guarantee. 😉

  12. Thanks, Franceso for you quick reply. I gave a try using Java 8 with Pentaho CE,Am able to see the login page of Pentaho User Console. Once in, nothing is displaying.. it is just a simple blank page. I’m not sure what was the reason behind the issue.

  13. 🙂 … This is another Scenario where I have been try to work out. I’m trying to run the pentaho CE with Tomcat 8 instead of the default version 6. I can see the message as “Server has startup”, but the pentaho user console page is not coming up. I believe I’m missing some configuration. Could you please guide or provide the steps how to achieve my issue. Thanks in advance.

    • Hi Naveen or Francesco,
      I also receive the 404 error and cannot figure why. I’ve tried installing 5.3 on both Windows 7, pointed to jdk1.7.0_21 and ubuntu in a VirtualBox, pointing to java-7-openjdk-amd64. Tomcat starts but returns the same “HTTP Status 404 – /pentaho” in both cases. I don’t see any warnings or errors in the Catalina.out (ubuntu) or catalina.2015-04-05.log (windows 7), but I also don’t see any messages about launching any Pentaho program or service. Are we sure that there isn’t any file I need to put in one the Tomcat directories? The 5.3 download did not include Tomcat and no instructions I found even mention it as a prerequisite and deduced that by opening the bat file. I found some EE instructions that require staging some ~.WAR files in Tomcat. Now I’m stumped … any ideas?

      Thanks for the blog and helping people out with Pentaho.

  14. Glad to inform you… pentaho CE edition works with JAVA 8.
    sol: have to create following batch file with the name “setenv.bat” in the location biserver-ce-5.2.0.0-209\tomcat\bin
    code inside the file:
    set JAVA_OPTS=-Dfile.encoding=UTF-8 -Xms128m -Xmx1024m -XX:PermSize=64m -XX:MaxPermSize=256m
    restart the server. It worked like a charm

  15. Francesco!
    THANK YOU !
    I followed your instructions and the BA works via my MacbookPro via Ubuntu on VirtualBox.

    I tried over the weekend to do this in native OS X but it wasn’t possible. Failing that I did launch it on Windows 8 on another machine, but I was determined to get this done on my MacbookPro.

    Many Thanks

    Joseph

  16. Hi Francesco,

    In Pentaho Reporting, I have a requirement where I need to change the file name dynamically with the date and time_stamp while exporting the report into the CSV or excel format.
    For instance: The file name is “A”, I need the file name as A_05_15_2015.
    Could you please assist with any solution here

  17. When I type http://10.1.1.72:8080/pentaho on my browser I get an error “The requested URL could not be retrieved – The following error was encountered: Connection to 10.1.1.72 Failed. The system returned: (113) No route to host”. But I have ping to that host.
    Thank you!!

  18. Thank you! It was the proxy. Now it works.
    Is there any tutorial o something to start to use Pentaho? I’m interested in Analytics Platform.
    Thank you very much for your help.

  19. Hola a todos,estoy tratando de desplegar Pentaho 5.4 en un servidor Glassfish,pero esto no esta tan sensillo como pensaba,alguien me podria ayudar por favor??

  20. Hello everyone, I’m trying to deploy Pentaho 5.4 in a Glassfish server, but this is not so sensillo as I thought, someone could please help me ??

  21. Hello Francesco, thank you for the wonderfull work you have put into AAAR.
    We are using it as a reporting tool for a digital asset management system.

    I just wanted to give you some feedback on some of the above installation instructions, that you might want to revise:
    Pentaho Business analytics 5.0 is no longer supported for AAAR, if I understand the metadatafile from the pentaho market, AAAR is now limited to the latest pentaho version 6.1. This also means you also must run it with java 8. With java 7 pentaho 6.1 no longer started after I installed the AAAR.

    • Francesco Corti

      Hi Stefan,

      Thank you for the feedback and, yes, your right: AAAR is no longer supported for Pentaho 5.x.
      And the suggestion I always give is to move to the latest Pentaho 6.x version.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.