--- title: Saiku Analytics (BI) Integration with Pentaho and Liferay description: Saiku Analytics (BI) Integration with Pentaho and Liferay image: https://blog.e-zest.com/hs-fs/file-3395201834-png/blog-files/login-in-pentaho.png --- [![e-Zest logo\_An accion lab company\_Colour](https://blog.e-zest.com/hubfs/images/Logos%20with%20Tagline/Corporate/SVG/e-Zest%20logo_An%20accion%20lab%20company_Colour.svg "e-Zest logo_An accion lab company_Colour")](https://www.e-zest.com/) - [WORK](https://www.e-zest.com/our-work) - [SERVICES](https://www.e-zest.com/our-services) - [Product Engineering](https://www.e-zest.com/digital-product-engineering-services) - [Enterprise Data Services](https://www.e-zest.com/enterprise-data-services) - [Digital Commerce](https://www.e-zest.com/digital-commerce-services) - [Digital Operations](https://www.e-zest.com/digital-operations) - [Digital Consulting](https://www.e-zest.com/digital-transformation-consulting-services) - [Digital Experience Design](https://www.e-zest.com/digital-experience-design) - [INSIGHTS](https://blog.e-zest.com/) - [CAREERS](https://www.e-zest.com/careers) - [ENTERPRISE DATA SERVICES](https://www.e-zest.com/enterprise-data-services) - [GENERATIVE AI](https://www.e-zest.com/generative-ai) - [Healthcare](https://healthcare.e-zest.com) - [Contact Us](https://www.e-zest.com/contact-us) - ![Elevating Product Engineering with AI and ML](https://blog.e-zest.com/hubfs/Elevating%20Product%20Engineering%20with%20AI%20and%20ML.jpg) [BLOGS](https://blog.e-zest.com) #### Elevating Product Engineering with AI and ML As technology evolves and customer choices broaden, there is an increasing ... [Read more](https://blog.e-zest.com/elevating-product-engineering-with-ai-and-ml) - ![e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024](https://blog.e-zest.com/hubfs/e-Zest%20%E2%80%93%20An%20Accion%20Labs%20Company%20-%20Gets%20Recognition%20as%20a%20Contender%20in%20the%20ISG%20Provider%20LensTM%20Study%20on%20Digital%20Engineering%20Services%202024.jpg) [NEWS](https://blog.e-zest.com/news) #### e-Zest – An Accion Labs Company gets Recognition as a Contender in the ISG Provider Lens™ Study on Digital Engineering Services 2024 We are delighted to announce that e-Zest – An Accion Labs Company has been ... [Read more](https://blog.e-zest.com/news/e-zest-an-accion-labs-company-gets-recognition-as-a-contender-in-the-isg-provider-lens-study-on-digital-engineering-services-2024) - ![e-Zest Solutions supports Digital Pune Mission](https://blog.e-zest.com/hubfs/blog-files/Digital%20Literacy%20Bus%20e-Zest.png) [CSR](https://blog.e-zest.com/csr) #### e-Zest Solutions supports Digital Pune Mission **Pune, India:** e-Zest Solutions, a leading digital technology innovation ... [Read more](https://blog.e-zest.com/csr/e-zest-solutions-supports-digital-pune-mission) - [Work](https://www.e-zest.com/our-work) - [Services](https://www.e-zest.com/our-services) - [Insights](https://blog.e-zest.com) - [Careers](https://www.e-zest.com/careers) - [Enterprise Data](https://www.e-zest.com/enterprise-data-services) - [Generative AI](https://www.e-zest.com/generative-ai) - [Innovations](https://www.e-zest.com/innovations) - [Healthcare](https://healthcare.e-zest.com) - [About](https://www.e-zest.com/about-us) - [Contact](https://www.e-zest.com/contact-us) - [Blog](https://blog.e-zest.com/) - [News](https://blog.e-zest.com/news) - [CSR](https://blog.e-zest.com/csr) - [![Linkedin Icon](https://blog.e-zest.com/hubfs/icons/linkedin_icon_white.svg)](https://www.linkedin.com/company/e-zest-solutions/) - [![Twitter Icon](https://blog.e-zest.com/hubfs/twitter-logo-silhouette%20(5).svg)](https://twitter.com/ezest) - [![Facebook Icon](https://blog.e-zest.com/hubfs/facebook-app-logo%20(4).svg)](https://www.facebook.com/61259256638) - [![Instagram Icon](https://blog.e-zest.com/hubfs/instagram-logo%20(4).svg)](https://www.instagram.com/ezestsolutions/) - [![Youtube Icon](https://blog.e-zest.com/hubfs/icons/youtube_icon_white.svg)](https://www.youtube.com/user/ezestcorporate) [![Go to top icon](https://blog.e-zest.com/hubfs/AA%20Assets/top%20button.svg)](https://blog.e-zest.com/saiku-analytics-bi-integration-with-pentaho-and-liferay/#top) Hit enter to search or ESC to close Insights e-Zest members share technology ideas to foster digital transformation. - [Blog](https://blog.e-zest.com) - [News](https://blog.e-zest.com/news) - [Podcasts](https://www.e-zest.com/podcasts) - [Healthcare](https://blog.e-zest.com/healthcare) - [CSR](https://blog.e-zest.com/csr) - [Whitepaper](https://blog.e-zest.com/whitepaper) - [Playbook](https://blog.e-zest.com/playbook) - [Media Kit](https://www.e-zest.com/media-kit) # Saiku Analytics (BI) Integration with Pentaho and Liferay [Shailesh Kulkarni](https://blog.e-zest.com/author/shailesh-kulkarni) Dec 24, 2012 [business intelligence](https://blog.e-zest.com/topic/business-intelligence-2) [Java](https://blog.e-zest.com/topic/java) [pentaho](https://blog.e-zest.com/topic/pentaho) [Ad hoc Report Feature](https://blog.e-zest.com/topic/ad-hoc-report-feature) [Liferay](https://blog.e-zest.com/topic/liferay) [Saiku Analytics](https://blog.e-zest.com/topic/saiku-analytics) [Technology](https://blog.e-zest.com/topic/technology) - - - - **Objective:** Recently I had integrated Saiku Analytics tool with Pentaho to implement the Ad hoc report feature in a Java based business application. The basic requirement was, users should be able to define the report layout and generate report based on dynamic dimensions, cubes and field selection. Also user should be able to view reports in graphical format and export it into excel or pdf. Saiku is an open source tool which is used for multidimensional analysis where you can slice and dice data. This tool is freely available for download from www.analytical-labs.com. Organisations can use the solution internally without having to pay license fees.This provides a user friendly, web based analytics solution that helps users to quickly and easily analyze application/system data. The solution connects to a range of OLAP Servers including Mondrian, Oracle Hyperion. This tool easily integrates with Pentaho, as this was developed with the purpose of the GWT based wrapper around the OLAP4J library. We can integrate this tool with other business applications using Iframe, SSO. In this blog, I have explained how we can integrate this tool with Pentaho and Liferay using Iframe Portlet. We have integrated Saiku with an application having the following technology stack - Liferay 5.2.3 - Spring framework 3.0.5 - Ifaces 1.8 - Mysql 5.1 Saiku provides Pentaho plugin, you can download it from [http://analytical-labs.com/downloads.php](http://analytical-labs.com/downloads.php) site. We need to extract the Saiku.zip file into \[drive name\]liferay-portal-5.2.3pentaho-solutionssystem folder and map corresponding datasource in \[drive name\]liferay-portal-5.2.3pentaho-solutionssystemolapdatasources.xml file. This step will integrate Saiku with Pentaho. Using this datasources.xml file Saiku pickup dimensions and cubes. Sample datasource definition in datasource.xml file - ``` Provider=Mondrian;DataSource=Pentaho Pentaho BI Platform Datasources http://localhost:9080/pentaho/Xmla?userid=joe&password=password Provider=mondrian PentahoXMLA MDP Unauthenticated Provider=mondrian;DataSource=Liferay solution:Liferay/Repair_Order.mondrian.xml ``` In the above xml snippetsLiferay/Repair\_Order.mondrian.xml is a cube and dimension definition file which is called as mondrian schema file and it can have multiple cubes defined in it, this file is generated through Pentaho and Liferay is the name of the folder in which this file is present. We can create cube using Pentaho schema workbench. Pentaho should connect to MySQL database, for that purpose we have configured the database username, password and driver information in mysql5.hibernate.cfg.xml, hibernate-settings.xml file from the pentaho-solutionssystemhibernate folder and to configure datasource in Pentaho, we have used the following steps : 1. Connect to Pentaho admin interface using http://localhost:9080/pentaho/ URL. 2. Use username=*joe* and password=*password* to login in Pentaho [![](https://blog.e-zest.com/hs-fs/file-3395201834-png/blog-files/login-in-pentaho.png?width=350&height=200&name=login-in-pentaho.png)](https://blog.e-zest.com/wp-content/uploads/2013/01/Login-in-Pentaho.png) 3. Go to file -\>New -\> Data source.. [![](https://blog.e-zest.com/hs-fs/file-3395201844-png/blog-files/pentaho-data-source.png?width=350&height=200&name=pentaho-data-source.png)](https://blog.e-zest.com/wp-content/uploads/2013/01/Pentaho-Data-Source.png) 4. Select source type = “SQL Query”, you can see Liferay as listed data source [![](https://blog.e-zest.com/hs-fs/file-3395201854-png/blog-files/pentaho-liferay-integration.png?width=350&height=200&name=pentaho-liferay-integration.png)](https://blog.e-zest.com/wp-content/uploads/2013/01/Pentaho-Liferay-Integration.png) 5. Select it and edit it to connect to correct database. \[Click on the pencil icon to edit the data source.\] Provide hostname, database name, port number, user name and password and click on ‘Test’ to test the connection. It should show successfully connected message. [![](https://blog.e-zest.com/hs-fs/file-3395201864-png/blog-files/pentaho-liferay-db-integration.png?width=350&height=200&name=pentaho-liferay-db-integration.png)](https://blog.e-zest.com/wp-content/uploads/2013/01/Pentaho-Liferay-DB-Integration.png) ***Integrating Saiku Reporting Tool in Liferay*** Saiku Analytics is an independent Web application, and requires authorization to access the tool. Liferay community edition comes bundled with an Iframe Portlet which enables integration of web application inside the Liferay UI as a Portlet. [![Integrating Saiku Reporting Tool in Liferay](https://blog.e-zest.com/hs-fs/file-3395201874-png/blog-files/integrating-saiku-reporting-tool-in-liferay.png?width=350&height=200&name=integrating-saiku-reporting-tool-in-liferay.png)](https://blog.e-zest.com/wp-content/uploads/2013/01/Integrating-Saiku-Reporting-Tool-in-Liferay.png) - Source URL = /pentaho/Login?unique=new Date() - Authenticate=true - User name (field name=j\_username) and (value=joe) - Password (field name=j\_password) and (value=password) - Hidden variables= locale=en;redirectTo=/pentaho/content/saiku-ui/index.html?biplugin=true;autoLoginSiku=true;unique=new Date() - HTML attributes= no change in this. Keep it as it is. - - - ### Similar Blog [![The New Age of Data-led Digital Transformation](https://blog.e-zest.com/hubfs/dd%20blog.jpg) The New Age of Data-led Digital Transformation Digital Transformation in organizations has placed data where it deserves to be – at the center of the Digital Enterprise. The ... By Devendra Deshmukh Mar 10, 2020](https://blog.e-zest.com/the-new-age-of-data-led-digital-transformation) [![Insightful Tips CIOs must not Ignore](https://blog.e-zest.com/hubfs/Blog%20Graphics%20(Insightful%20tips%20CIOs%20must%20not%20ignore%20in%202017).jpg) Insightful Tips CIOs must not Ignore CIOs of enterprises are under tremendous pressure to innovate and evolve according to the ever changing business dynamics. CIOs ... By Nidhi Thakkar Jan 27, 2017](https://blog.e-zest.com/insightful-tips-cios-must-not-ignore-in-2017) [![Qlik Sense - GenX of Qlikview](https://blog.e-zest.com/hubfs/blog-files/qlik.jpg) Qlik Sense - GenX of Qlikview We all are familiar with QlikView, the leading data visualization tool. Qlik community has recently introduced Qlik Sense 2.1 as ... By Nilam Mahajan Nov 26, 2015](https://blog.e-zest.com/qlik-sense-genx-of-qlikview) [![Technology in the News- Week 37, 2015](https://blog.e-zest.com/hs-fs/file-3419272476-jpg/blog-files/tech-digest-week-37.jpg) Technology in the News- Week 37, 2015 **Microsoft acquires cyber security startup Adallom** By Corporate Sep 11, 2015](https://blog.e-zest.com/technology-in-the-news-week-37-2015/) [![Tech stories handpicked for you -Week 34, 2015](https://blog.e-zest.com/hs-fs/file-3419271906-jpg/blog-files/tech-digest-week-33.jpg) Tech stories handpicked for you -Week 34, 2015 By Corporate Aug 22, 2015](https://blog.e-zest.com/tech-stories-handpicked-for-you-week-34-2015/) [![Ensuring Accessibility & Inclusivity in Technology with Conversational AI](https://blog.e-zest.com/hubfs/Ensuring%20Accessibility%20%26%20Inclusivity%20in%20Technology%20with%20Conversational%20AI.jpg) Ensuring Accessibility & Inclusivity in Technology with Conversational AI The fact that the technology landscape is evolving is not breaking news, but the emergence of Conversational AI represents a ... By Shailesh Kulkarni Apr 08, 2024](https://blog.e-zest.com/ensuring-accessibility-inclusivity-in-technology-with-conversational-ai) [![Generative AI: The Future of Product Engineering](https://blog.e-zest.com/hubfs/Home%20New%20Images/Home%20Images%202020/Banner%20Desktop/Generative%20AI%20The%20Future%20of%20Product%20Engineering.png) Generative AI: The Future of Product Engineering In today's fast-paced technological landscape, the role of Artificial Intelligence (AI) in reshaping product engineering is ... By Shailesh Kulkarni Sep 14, 2023](https://blog.e-zest.com/generative-ai-the-future-of-product-engineering) [![DevOps for improving productivity and software reliability](https://blog.e-zest.com/hubfs/%5E9FD7331E997F4F5D2AC9EE1D30FD640B1AC5033E0CE9C5EA41%5Epimgpsh_fullsize_distr.png) DevOps for improving productivity and software reliability Now-a-days, DevOps is very popular buzzword in the IT industry and is gaining good traction by companies to adopt DevOps culture ... By Shailesh Kulkarni Jul 31, 2017](https://blog.e-zest.com/devops-for-improving-productivity-and-software-reliability) [![SaaSification for Big Data application](https://blog.e-zest.com/hubfs/sonal-saasification-for%20big-data-application.png) SaaSification for Big Data application “Products as a Service” or “Software as a Service” models have innate abilities to potentially scale and be cost effective for ... By Shailesh Kulkarni Jul 05, 2017](https://blog.e-zest.com/saasification-for-big-data-application) [![Distributed public data made easy by Satori](https://blog.e-zest.com/hubfs/ipsita-distributed-public-data-made-easy-by-Satori.png) Distributed public data made easy by Satori One common problem that we face every day is the availability of open/public data distributed on thousands of silos websites ... By Shailesh Kulkarni Jun 21, 2017](https://blog.e-zest.com/distributed-public-data-made-easy-by-satori) ## Helping Organizations Thrive in the Digital Age [Contact Us](https://www.e-zest.com/contact-us) - [About](https://www.e-zest.com/about-us) - [Services](https://www.e-zest.com/our-services) - [Work](https://www.e-zest.com/our-work) - [Insights](https://blog.e-zest.com/) - [Healthcare](https://healthcare.e-zest.com/) - [Accion Labs](https://www.accionlabs.com/) - - - - - - Dallas - Detroit - Hannover - Vienna - London - Pune © 2025 e-Zest Solutions - [Privacy Policy](https://www.e-zest.com/privacypolicy) - [Cookie Policy](https://www.e-zest.com/cookie-policy) Contact us Contact us e-Zest is a leading digital innovation partner for enterprises and technology companies that utilizes emerging technologies for creating engaging customers experiences. Being a customer-focused and technology-driven company, it always helps clients in crafting holistic business value for their software development efforts. It offers software development and consulting services for cloud computing, enterprise mobility, big data and analytics, user experience and digital commerce.