This wiki does not contain official documentation and is currently deprecated and read only. Please try reading the documentation on the Liferay Developer Network, the new site dedicated to Liferay documentation. DISCOVER Build your web site, collaborate with your colleagues, manage your content, and more. DEVELOP Build applications that run inside Liferay, extend the features provided out of the box with Liferay's APIs. DISTRIBUTE Let the world know about your app by publishing it in Liferay's marketplace. PARTICIPATE Become a part of Liferay's community, meet other Liferay users, and get involved in the open source project. Pentaho Portlets
Introduction #
This article explains how to install the sample JSR-168 portlets distributed by Pentaho.
Pentaho distributes JSR-168 integration with its Business Intelligence (BI) suite. They have also distributed sample portlets and data to give an example of Pentaho's integration.
Installation #
This wiki assumes experience with installing Liferay portal and a basic understanding of Pentaho's Business Intelligence (BI) suite.
Setup Liferay With MySQL #
Though Pentaho's sample portlets are configured for both MySQL and HSQLDB, the installation here will be based on HSQLDB. In order for Liferay's database to not conflict with Pentaho's, we will configure Liferay to point to a MySQL schema. This will assume the use of Liferay, bundled with Tomcat 5.5.
- Install Liferay Portal 4.3.4 (Bundled with Tomcat for JDK 5.0).
- Create a MySQL database with the SQL scripts provided from Liferay.
- Install the MySQL JDBC driver and configure Liferay to use the MySQL schema.
- Make sure you can startup Liferay and hit http://localhost:8080.
Setup Pentaho #
Pentaho requires the installation of several WAR files and the use of the database and solutions.
- Download and unzip the latest pentaho_j2ee_deployments-<version>.zip from Pentaho.
- Run the ant target ant war-all-pentaho-tomcat.
- Though there will be errors, hot deploy the file /pentaho_j2ee_deployments-<version>/build/pentaho-wars/tomcat/hsqldb/pentaho.war by one of two methods:
- Drop it in the auto.deploy.deploy.dir specified in portal-ext.properties.
- Use the Plugin Installer portlet, under the Upload File tab, to upload the pentaho.war file
- Shutdown Liferay.
- Configure the <tomcat>/conf/server.xml file as delineated in Pentaho's Wiki.
- Copy pentaho-portal-layout.war, pentaho-style.war, and sw-style.war from /pentaho_j2ee_deployments-<version>/build/pentaho-wars/ to <tomcat>/webapps/.
- Download and unzip pentaho_sample_data-<version>.zip and pentaho_solutions-<version>.zip from Pentaho as sibling directories to <tomcat>.
- In /pentaho-data, run start_hypersonic.sh or, for Windows, start_hypersonic.bat.
- Make sure you can startup Liferay and hit http://localhost:8080.
Use Pentaho's Sample Portlets #
After starting up Liferay, Pentaho and its sample portlets should be ready for use.
- Login to Liferay with the default user credentials: test@liferay.com / test.
- Go to the Liferay Dock and click Add Content. You should see the Pentaho portlets under the category Undefined. Add the portlets: RegionFilterPortlet, RegionFilterPortlet, PieDatasetChartPortlet, and EmbeddedReportPortlet.
- Choose specific controls in the Filters portlet, and click Update. You should see something like the following:
