Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition. made simple. Pentaho rocks!We use it for what you would expect. ETL for process and aggregate data, and then building data cubes and reports for viewing that data. We also use the ETL tool to auto-process files (CSV, XML etc) from that we receive from a few of our vendors daily.,The Data Integration tool is fantastic. A novice user can get up to speed quickly with it and the GUI is intuitive Support. As an enterprise customer, I am always thrilled with the fast turnaround on support tickets that I open. Job Scheduling. The Job scheduler is easy to use and very reliable Data Analyzer Tool in "User Console". The drag and drop UI makes it easy for me end users to see the data in whatever way suits them. They can even GEO-MAP the data instantly!!,Speed on ETL. Without a very complex setup, the ETL Job runs single threaded and can be slow for BIG jobs. The "Report Designer" is decent, but lacks a lot of control that you might get from more mature products (like Business Objects, for instance). Sometimes to want to rotate or reformat a chart label, and it can't be done. In other cases, it can. It is not consistent. Also, 3D charts don't work in certain circumstances. Finally, charts mapped over time, in some cases, don't have the X Axis auto-scale and so all the data points are not readable.,8,Jasper,10,10,2,auto-processing vendor data files ETL for aggregate OLTP data into OLAP for reporting auto-producing reports for weekly meetings,using the ETL tool (PDI) to process external files was unexpected.,10Pentaho the best BI integratorOur product intended to analyse Media and Communications data and provide decision making capabilities to our end users. Whereas we built the workflow management, transactional capabilities, Pentaho provided the BI layer for our product. Analysts were our end users. Everything from data ingestion to decision making was the scope of our product. We read data across disparate data sources/formats and using our business expertise provided decision making capability.,Data Integration. Pentaho wins hands down. You can read huge data using a Hadoop process, do your encirchment, load it to a Netezza database afterwards, finally input the data to your WEKA model to predict which Customer will churn or what offer should be made to the customer so that he/she stays put. BI Server. If you want to schedule a data read operation of your clickstream data, to finally burst out recommendations of next best actions to end users, Pentaho's BI Server performs this integration seamlessly. Mondrian. This layer provides Cube based Hierarchical data modeling on the front end and at the back end converts this OLAP structure to a ROLAP, SQL based model. Hence any relational database becomes a ROLAP engine seamlessly.,Data Visualization. Provide richer library of data visualization capabilities. Ultimately the dashboards are the end result of all the hard work done at the back office. Yes, Pentaho has a lower TCO compared to other Products but richer data visualization capabilities would make it a winner! Pentaho has overcome this limitation by allowing external charting engines to be integrated with their product suite, but more needs to be done to strengthen core Pentaho Data Visualizaiton capabilities. Alternatively the external charting engine capabilities need to be documented and evangalized. Alternative to Mondrian. In our case we needed to analyse data for a million subscribers over key performance areas like Churns, Activations etc. In these scenarios semi additive measures needed to be calculated and presented in a report across days to years grains of time. In such scenarios the Mondrian based ROLAP capability did not scale up to our expectation. Pentaho needs to address such issues and fast. In the world of R/SAS/SPSS its hard to find use cases where WEKA was used in Production environments to solve a business problem. We would have needed some hand holding to replace our R/SPSS code to WEKA and help us build newer alogorithms on this platform ground up.,7,,6,Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.,8,6,4,10,5,As a replacement for our costly and technically disparate ETL and data visualization solution. As a integration software for our transactional systems with our BI systems. As a workflow management, business process specific application system.,As a dashboard/reporting solution. As a end to end data integrator. Right from data ingestion to pretty pictures that provide business value and decision making capability. As a workflow management solution.,No,Price Product Features Product Usability,I would place high marks on the visualization layer. If I cannot use one aspect of a Product suite it becomes difficult to evangelize the product within an organisation. Or I would set internal expectations that though the Product offers various modules, our evaluation should restrict itself to 2-3 core ideas and evaluate accordingly.,Implemented in-house,Yes,Technical expertise. Finding the right people who understood Java and BI was a tough ask. So we decided to keep the teams separate and let a Solutions Engineer/Architect provide direction for the integration. The team had prior experience in using stable proprietary products where documentation was plenty and hence any issue could be solved easily by tapping into the knowledge base around. Customer support interactions were infrequent. With Pentaho it was vice versa, where we depended more on Customer support than on community knowledge.,5,Yes,8,Yes,End to end data ingestion to data visualization is easiest to do. Dashboard/report creation, distribution is easy too. Workflow integration is best used in Pentaho. You can schedule an invoice to be loaded as soon as it arrives in your ftp server, you can apply business rules, load it to your database, refresh the data warehouse with this latest invoice and finally burst an email with telling all users to go and see the report. All this can be achieved in Pentaho's Workflow integration tool.,You HAVE to know Java to use Pentaho to the best of its capability. For pure BI enabled users like myself, it was a steep learning curve. Trying to match Customers data visualization expectations was tough, Our customers had already used Tableau and/or Microstrategy/Cognos/Business Objects, hence it was always a tough ask to match/better what they had already seen and experienced.,Yes, but I don't use it,5
103 Ratings
Score 7.5 out of 101
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Pentaho Reviews

103 Ratings
<a href='' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.5 out of 101
Show Filters 
Hide Filters 
Showing 2 of 103 Pentaho ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Job Type

Reviews (1-2 of 2)

  Vendors can't alter or remove reviews. Here's why.
Sandro Frattura profile photo
June 03, 2015

User Review: "B.I. made simple. Pentaho rocks!"

Score 8 out of 10
Vetted Review
Verified User
Review Source


We are an Enterprise customer. They handle problems INSTANTLY when they are critical, including initiation an immediate WebEx screen share call when needed. Smaller/less-critical problems are handled within 1-2 days -- and NEVER fall off their radar, no matter how small.

As needed, we can also leverage "professional services" from them -- much of which is included in our Enterprise contract.

Finally, when a problem I have discovered turns out to be a bug..they create a JIRA for the fix, and make me a watcher. I love seeing notes come in showing me status updates of bugs filed because of something I found.

They really are TOP-NOTCH.

Read Sandro Frattura's full review
Deepak Paramanand profile photo
November 04, 2014

User Review: "Pentaho the best BI integrator"

Score 7 out of 10
Vetted Review
Verified User
Review Source


They were responsive to our questions when we raised issues.
They gave us workarounds when required.
They were quite knowledgeable when it came to issue analysis and providing fixes.
They were forthright in informing us if a bug was not due for release soon.
Read Deepak Paramanand's full review

Feature Scorecard Summary

Pixel Perfect reports (12)
Customizable dashboards (11)
Report Formatting Templates (12)
Drill-down analysis (12)
Formatting capabilities (12)
Integration with R or other statistical packages (7)
Report sharing and collaboration (11)
Publish to Web (11)
Publish to PDF (13)
Report Versioning (8)
Report Delivery Scheduling (11)
Delivery to Remote Servers (3)
Pre-built visualization formats (heatmaps, scatter plots etc.) (10)
Location Analytics / Geographic Visualization (10)
Predictive Analytics (9)
Multi-User Support (named login) (13)
Role-Based Security Model (12)
Multiple Access Permission Levels (Create, Read, Delete) (12)
Single Sign-On (SSO) (4)
Responsive Design for Web Access (6)
Dedicated iOS Application (3)
Dedicated Android Application (3)
Dashboard / Report / Visualization Interactivity on Mobile (7)
Javascript API (3)
iFrames (3)
Java API (3)
Themeable User Interface (UI) (3)
Customizable Platform (Open Source) (3)

About Pentaho

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Pentaho Integrations

Pentaho Technical Details

Operating Systems: Unspecified
Mobile Application:No