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.
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 calledbiserver-ce
.Note
From here on, we will refer to the path of the folder
biserver-ce
with the name[PUC_HOME]
.We configure the MySQL JDBC driver in Pentaho BA Server.
We go to the path
[PUC_HOME]/tomcat/lib
.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
.Next, we run the Pentaho...