Time for action – installing and running Pentaho BA Server

Next, we will install Pentaho BA Server in a folder of our choice and then copy the MySQL JDBC driver. We run Pentaho BA Server and use a web browser to access Pentaho User Console (PUC). Finally, we log in with our username and password and we can see the PUC UI.

  1. We select the file that we just downloaded and we decompress it. After doing this, we get a folder called biserver-ce-5.0.0-stable. In this folder, we find the subfolder called biserver-ce.

    Note

    From here on, we will refer to the path of the folder biserver-ce with the name [PUC_HOME].

  2. We configure the MySQL JDBC driver in Pentaho BA Server.
  3. We go to the path [PUC_HOME]/tomcat/lib.
  4. We should verify that the MySQL JDBC driver is included by default and if the version included is the one we are using. If it isn't, we should delete the default driver and paste the driver that we are currently using: [PRD_HOME]/lib/jdbc/mysql-connector-java-X.X.XX-bin.jar.
  5. Next, we run the Pentaho BA Server as follows:
    • In Linux:
      1. We open a terminal.
      2. We go to the path [PUC_HOME]:
        shell > cd [PUC_HOME]
      3. We execute the file start-pentaho.sh:
        shell > sh start-pentaho.sh
    • In Windows:
      1. We open a terminal.
      2. We go to the path [PUC_HOME]:
        shell > cd [PUC_HOME]
      3. We execute the file start-pentaho.bat:
        shell > start-pentaho.bat

    Note

    Remember that each time we see [PUC_HOME], we should write the complete path to the folder biserver-ce.

    After completing these actions, we will have run Pentaho BA Server and we will be able to use Pentaho User Console (PUC) to navigate, explore our BI solutions, and manage and configure the BI Server. PUC is Pentaho's public face.

  6. Now we run PUC and log in with a username and password.
  7. We direct our preferred web browser to the following URL:

    http://localhost:8080/pentaho

    This will show us the following welcome and login page:

    Time for action – installing and running Pentaho BA Server
  8. We click on Evaluation Login to see the default users and their respective profiles in Pentaho BA Server. The user console page will look like the following screenshot:
    Time for action – installing and running Pentaho BA Server

    In our case, the user admin already has a profile and Administrator privileges.

  9. We go to the right-hand panel where the login data should be entered and insert the following:
    • User Name = admin
    • Password = password

    To continue, we click on the Login button.

    After logging in, we can see the PUC UI as shown in the following screenshot:

    Time for action – installing and running Pentaho BA Server

What just happened?

We decompressed the file that we downloaded from SourceForge in a folder of our choice. Then we copied the MySQL JDBC driver to the [PUC_HOME]/tomcat/lib folder.

We ran Pentaho BA Server according to our operating system. Then we accessed PUC using a web browser through a URL, http://localhost:8080/pentaho. Then we logged in with the user admin and entered PUC. Finally, we used a PUC option to view the BI solutions explorer.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset