In this chapter we talk about Pentaho, the fastest growing, most active, most popular, and most heavily invested in Open Source Business Intelligence (OSBI) suite in recent years. We analyze its principal characteristics and the principal projects included in the suite.
With Pentaho Business Analytics (BA ) Server, we have full BI analytic power at our fingertips through a GNU General Public License (GPL ).
We will see how Pentaho Report Designer (PRD) and Pentaho BA Server interact, and how we can use them to run our reports from Pentaho User Console (PUC). At the end of this chapter, we will have Pentaho BA Server running and will be able to access our reports from a web browser.
In this chapter we will do the following:
Download and install Pentaho BA Server
Configure the MySQL JDBC driver in Pentaho BA Server
Run Pentaho BA Server and log in with Pentaho User Console (PUC)
Create a solutions folder in our Pentaho BA Server...