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

« Voltar para Starting with...

Pentaho Portlets

Detalhes Imprimir
Tag: 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 Anexos
          73446 Visualizações
          Média (2 Votos)
          A média da avaliação é 1.0 estrelas de 5.
          Comentários
          Respostas do tópico Autor Data
          Is there going to be a new install process for... Lisa Simpson 11 de Setembro de 2009 08:00
          We are also very interested in any... Aaron Low 9 de Outubro de 2009 16:32
          I followed the complete procedure above on... venkat bagam 14 de Setembro de 2009 02:38
          Any news on this one ? I go and try it out if... gerald hemmers 14 de Janeiro de 2010 01:54
          Hi. Recently I got an assignment where we... Vineet Bansal 22 de Abril de 2010 00:20
          check this link... SZ khan 7 de Julho de 2010 03:34
          Sultee, Looks great from the pictures... but... Ryan T 19 de Outubro de 2010 17:20
          Hi.. I want to integrate Liferay 5.2.3 with... ankit yakkundi 13 de Janeiro de 2011 01:24
          Hi Ankit, Did you got any solutions for this. vasv kumar 24 de Fevereiro de 2011 23:15
          liferay-portlet.xml,liferay-display.xml are... vasv kumar 24 de Fevereiro de 2011 21:56
          Hi, anyone knows tell me where I can find this... FREDERICO ARAÚJO 16 de Dezembro de 2014 11:54

          Lisa Simpson
          Is there going to be a new install process for 5.2.3??? Surely its changed somewhat by now...
          Postado em 11/09/09 08: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.
          Postado em 14/09/09 02:38.
          Aaron Low
          We are also very interested in any documentation on integrating Liferay 5.2.3 with Pentaho 3.0.0.
          Postado em 09/10/09 16:32 em resposta a 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
          Postado em 14/01/10 01: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
          Postado em 22/04/10 00:20.
          SZ khan
          check this link
          http://www.adictosaltrabajo.com/tutoriales/tutoriales.php?pagina=IntegrarLif­eray521PentahoBI2MySQL51
          Postado em 07/07/10 03:34 em resposta a 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
          Postado em 19/10/10 17:20 em resposta a 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.
          Postado em 13/01/11 01: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.
          Postado em 24/02/11 21:56.
          vasv kumar
          Hi Ankit,

          Did you got any solutions for this.
          Postado em 24/02/11 23:15 em resposta a 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
          Postado em 16/12/14 11:54.