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.

Wiki

« 返回到 Starting with...

Pentaho Portlets

详细信息 打印
标签: liferay v4.3 installation deployment setup

Table of Contents [-]

  1. Introduction
    1. Installation
      1. Setup Liferay With MySQL
        1. Setup Pentaho
          1. Use Pentaho's Sample 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.

          1. Install Liferay Portal 4.3.4 (Bundled with Tomcat for JDK 5.0).
          2. Create a MySQL database with the SQL scripts provided from Liferay.
          3. Install the MySQL JDBC driver and configure Liferay to use the MySQL schema.
          4. 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.

          1. Download and unzip the latest pentaho_j2ee_deployments-<version>.zip from Pentaho.
          2. Run the ant target ant war-all-pentaho-tomcat.
          3. 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:
            1. Drop it in the auto.deploy.deploy.dir specified in portal-ext.properties.
            2. Use the Plugin Installer portlet, under the Upload File tab, to upload the pentaho.war file
          4. Shutdown Liferay.
          5. Configure the <tomcat>/conf/server.xml file as delineated in Pentaho's Wiki.
          6. Copy pentaho-portal-layout.war, pentaho-style.war, and sw-style.war from /pentaho_j2ee_deployments-<version>/build/pentaho-wars/ to <tomcat>/webapps/.
          7. Download and unzip pentaho_sample_data-<version>.zip and pentaho_solutions-<version>.zip from Pentaho as sibling directories to <tomcat>.
          8. In /pentaho-data, run start_hypersonic.sh or, for Windows, start_hypersonic.bat.
          9. 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.

          1. Login to Liferay with the default user credentials: test@liferay.com / test.
          2. 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.
          3. Choose specific controls in the Filters portlet, and click Update. You should see something like the following:

          0 附件
          73407 查看
          平均 (2 票)
          满分为 5，平均得分为 1.0。
          评论
          讨论主题回复 作者 日期
          Is there going to be a new install process for... Lisa Simpson 2009年9月11日 上午8:00
          We are also very interested in any... Aaron Low 2009年10月9日 下午4:32
          I followed the complete procedure above on... venkat bagam 2009年9月14日 上午2:38
          Any news on this one ? I go and try it out if... gerald hemmers 2010年1月14日 上午1:54
          Hi. Recently I got an assignment where we... Vineet Bansal 2010年4月22日 上午12:20
          check this link... SZ khan 2010年7月7日 上午3:34
          Sultee, Looks great from the pictures... but... Ryan T 2010年10月19日 下午5:20
          Hi.. I want to integrate Liferay 5.2.3 with... ankit yakkundi 2011年1月13日 上午1:24
          Hi Ankit, Did you got any solutions for this. vasv kumar 2011年2月24日 下午11:15
          liferay-portlet.xml,liferay-display.xml are... vasv kumar 2011年2月24日 下午9:56
          Hi, anyone knows tell me where I can find this... FREDERICO ARAÚJO 2014年12月16日 上午11:54

          Lisa Simpson
          Is there going to be a new install process for 5.2.3??? Surely its changed somewhat by now...
          在 09-9-11 上午8:00 发帖。
          venkat bagam
          I followed the complete procedure above on Liferay 4.4.3, tomcat 5.5 and pentaho_j2ee_deployments-1.6.0-RC2.820. Yes, every thing looked good but couldn't see any portlets related to pentaho. Rather, I could access pentaho only as a web-app from http://localhost:8080/pentaho.
          在 09-9-14 上午2:38 发帖。
          Aaron Low
          We are also very interested in any documentation on integrating Liferay 5.2.3 with Pentaho 3.0.0.
          在 09-10-9 下午4:32 发帖以回复 Lisa Simpson。
          gerald hemmers
          Any news on this one ? I go and try it out if it is going to work i will let you know
          在 10-1-14 上午1:54 发帖。
          Vineet Bansal
          Hi.

          Recently I got an assignment where we need to integrate the Liferay Portal Standard Edition 5.2.3 with Pentaho 3.5.0 or 3.5.2 using Tomcat 5.5. I have found many documents on the net for the older versions integration but not on the version I am working on.

          Can any one pl help me on this by providing some pointer?

          Any genius?

          Vineet
          在 10-4-22 上午12:20 发帖。
          SZ khan
          check this link
          http://www.adictosaltrabajo.com/tutoriales/tutoriales.php?pagina=IntegrarLif­eray521PentahoBI2MySQL51
          在 10-7-7 上午3:34 发帖以回复 Vineet Bansal。
          Ryan T
          Sultee,

          Looks great from the pictures... but unfortunately I do not speak Spainish... Do you know of an English translation other then google? ...or is the Google translation accurate?

          Thanks,

          Ryan
          在 10-10-19 下午5:20 发帖以回复 Sultee khan。
          ankit yakkundi
          Hi..
          I want to integrate Liferay 5.2.3 with tomcat 5.23 and Pentaho 1.7.I have tried all the above steps,but i want to know how can i get RegionFilterPortlet, RegionFilterPortlet, PieDatasetChartPortlet, and EmbeddedReportPortlet.Since i have deployed pentaho-portal-layout.war, pentaho-style.war, and sw-style.war in webapps folder.
          When i deploy it i am able to see the above 3 portlets ie pentaho-portal-layout, pentaho-style, and sw-style.All showing open link.When i click on it i get a page showing "HTTP Status 404" errpr.

          Please let me know i need to do,so that i can view the reports or graphs as shown in the above wiki.

          Thanks in advance.
          Any idea or suggestions are welcome.
          在 11-1-13 上午1:24 发帖。
          vasv kumar
          liferay-portlet.xml,liferay-display.xml are missing in pentaho.war,then how can i add portlets into a page through control panel.

          liferay-portlet.xml is not there in war,so because of this all 15 portlets are unregistering immediately after registered.
          在 11-2-24 下午9:56 发帖。
          vasv kumar
          Hi Ankit,

          Did you got any solutions for this.
          在 11-2-24 下午11:15 发帖以回复 ankit yakkundi。
          FREDERICO ARAÚJO
          Hi, anyone knows tell me where I can find this portlet for version 6.2 of Liferay?
          Know if this portlet has continuity or if there is another initiative?

          Since already thank you for your attention.

          Hugs,
          Frederick Araújo
          在 14-12-16 上午11:54 发帖。