TrustRadius
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.https://dudodiprj2sv7.cloudfront.net/product-logos/tH/rx/4APKV7V3F5EA.JPEGA powerful ETL tool which is open sourcePentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.,Populate relational database Transform and clean data Create periodic job and generate report Aggregate data,It will be helpful to have modules supporting Google Adwords and Facebook API and Twilio API It has "add constant", but does not have "multiply constant" module. Unit transform module,9,,10,Number of users is 1 since only I have experience with that. Type of user is Data Scientist. It is used only in the data team.,10,8,7,YesB.I. 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 - Fast and Furious Data IntegrationPentaho Data Integration is used to move data into our data warehouse solution, used for various projects.,Data Integration. PDI handles pretty much any type of data source and can transform data and conform it to any type of business logic. Object Oriented ETl Coding. Code developed in PDI can be shared across numerous jobs/transformations. This allows for resusable and maintainable code. Flexibility and plugins. If the function that you are looking for is not built into the tool, it's fairly straightforward to either download or develop plugins. There is a huge community of users that build new functionality all the time. Scaleable and cloud ready. PDI is able to cluster and scale out to handle huge data sets.,The speed at which some trouble issues get resolved could be improved.,9,Talend,10,We are able to be agile with our code development. We are able to have faster turn around on code development, integrate to standard tools like Git and Jenkins, and save time to release products.,1,10Pentaho - Jumping On The Band WagonPentaho is currently being used for several functions within my department. The Data Integration is used as our primary ETL tool. The software does a great job with data cleansing and standardizing from multiple sources. The tool is easy enough to learn using videos out on You Tube or using the Pentaho Kettle Solutions book. We also use the Schema Editor for creating the semantic layer in the User Console reporting tool. Having defined objects available in the User consoles makes it easy for a data analyst to quickly log in and quickly get a report together. We are in the healthcare industry so much of what is being asked is counts of patients, encounters by diagnosis, practice or time period. All these items can quickly be answered very quickly via the user console.,A data analyst has quick access to data that would otherwise need to be pulled straight for the database. Additionally, the data dictionary is tied to an object so up keep is easy and users can scroll over the object to exactly what that measure or object represents. Report presentation is clean and professional. Pentaho comes with a pretty extensive set of charting and graphing functionality out of the box that in other tools would have to be developed. Easy file output with sufficient types available to choose from. (.pdf, .xlsx, .csv) The Data Integration tool is without question the best tool in the set. There is no limit to your transformation options. You can transform virtually any text file, excel file or script into a table, spreadsheet or even report. Many times we are given list of patients and file formats vary from practice to practice. With Pentaho DI we have the flexibility to take what has been provided and standardize.,Pentaho could use some improvement of the integration of ldap into the User Console. We have unsuccessfully been able to deploy the Pentaho User Console to partners because it does not support a federated ldap model. Even attempts at integrating to our primary ldap has proven fruitless. The Pentaho Suite as a whole tends to be a resource hog. Since we work with such large data sets we often find that large requests hang up or get an "oops error" which is a standard Pentaho error when the data set is too large. It would be nice to have some indication of our limits so that we are not guessing or we can limit the data set up front. Upgrades on the Suite are a bit cumbersome for our Administrators. There is not a standard backup and install package so upgrades often involve our administrator on the phone with Pentaho during the upgrades to walk through a custom install.,7,,8,Because of the security issue we have had to spin up an additional reporting portal using another vendor. This means we have two reporting tools that we must maintain and support. Since Pentaho is used by a limited audience it gets sidelined as a solution that requires our customers and partners to access their reporting via the web.,9,Creation of reports via the User Interface are very easy. The interface offers a drag and drop method of pulling data together and filters are easily applied to create the data set needed. A fairly simple report can be completed in roughly 3-5 minutes. Adding new objects to the cube can be done through the Schema Editor. The User Interface offers a standard formatThree Years with Pentaho and No RegretsPentaho serves several roles in our environment. We use it for report design and delivery. The designer tool is fairly straightforward and once reports are complete they are immediately accessible to our end users. Pentaho is used for Business Intelligence which includes totals, trends, and forecasts of sales and subscriptions of our services. Pentaho's web-based analysis tool allows our end-users to drag & drop measures and dimensions and instantly convert raw data into a variety of graphical representations. Before we had Pentaho, each view might have required a long query or static report that was hand-exported to Excel. With Pentaho's analysis tool, our sales, finance, and marketing teams have instant insight and infinitely flexible views of our data. In the IT department, we use Pentaho as a scheduling engine for data maintenance jobs as its interface allows us to manage multiple shards from a single source.,Pentaho works as advertised -- it provides a truly drag-and-drop customizable interface for your data. The Enterprise Suite has everything you need to start working and showing results right away. Pentaho's customer support has been responsive and timely when we've had issues.,The Report Designer interface can seem clunky at times when trying to perform additional calculations on previously calculated fields or pass values to subreports. There is inconsistency within the tools in Data Integration -- it is clear the various tools were authored by different engineers at different times. It is not always obvious what goes where. There is inconsistency between all the products within the Pentaho Suite. Each has a different look and feel and none work the same way. The product is not without flaws, but so far none have been insurmountable. Upgrading to the latest version has proven to be EXTREMELY challenging for both us AND Pentaho customer services.,10,,10,10
Unspecified
Pentaho
100 Ratings
Score 7.5 out of 101
TRScore

Pentaho Reviews

Pentaho
100 Ratings
Score 7.5 out of 101
Show Filters 
Hide Filters 
Showing 11 of 100 Pentaho ratings and reviews.
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-11 of 11)
  Vendors can't alter or remove reviews. Here's why.
Yinghua Hu profile photo
March 01, 2016

Pentaho Review: "A powerful ETL tool which is open source"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

10
Pentaho is free and powerful. It is user friendly and with ample documentation.
Read Yinghua Hu's full review
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

Likelihood to Renew

10
Pentaho is integral to our business now. We are married to it! :-)
Read Sandro Frattura's full review
Alex Meadows profile photo
August 19, 2015

Review: "Pentaho - Fast and Furious Data Integration"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

10
The flexibility of the tool and the quality of support from Pentaho make this a great, relatively inexpensive alternative to the larger proprietary tools.
Read Alex Meadows's full review
Stephanie Dozier profile photo
March 16, 2015

User Review: "Pentaho - Jumping On The Band Wagon"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

8
Although the security piece is a major game changer in our shop, Pentaho is a great tool overall. I have known other shops to work out their security issues with Pentaho and do great things so we'll need to get through this growing pain point as well and make Pentaho our positive game changer. I am excited to see the improvements in Pentaho 5 and look forward to evangelizing it's benefits over the more high priced solutions out there.
Read Stephanie Dozier's full review
Kenneth Panacy profile photo
November 05, 2014

Review: "Three Years with Pentaho and No Regrets"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

10
Pentaho continues to fulfill our needs as previously described. We are regularly finding new uses for it as we expand our business and our technology stack.
Read Kenneth Panacy'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

Likelihood to Renew

6
We have moved to homegrown ETL and have matured as a company as to what we need from a BI tool. Our focus is now rich and intuitive data visualization with blazing speed. Our customers had already used MicroStrategy/Tableau in the past so that bar was already set very high. Unfortunately Pentaho could not give us a better if not similar experience as the tools our Customers had already used.
Read Deepak Paramanand's full review
Adam O'Connor profile photo
September 16, 2014

Review: "Pentaho Report Designer Integated with Odoo v7!"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

10
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration.
Read Adam O'Connor's full review
Itamar Steinberg profile photo
December 05, 2014

"Data Integration with Pentaho Kettle review"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

9
Basically, the cost is very affordable, if you have already done everything and the project is working then you don't want to replace it because that means making a whole new project. Also I think its very good and the competitor will not overcome the functionality. So you will find your self spending a lot of time and money to get to the same place.
Read Itamar Steinberg's full review
Julia Gusman profile photo
November 05, 2014

Pentaho Review: "My Favorite Data Integration Tool is still Kitchen"

Score 10 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

10
Pentaho Data Integration is making my day-to-day work with data more effective. I have found that Pentaho Data Integration can connect to more data sources more easily than SSIS. Being open standards Pentaho can run in almost any environment - meaning it can run in the cloud as well as in client's environment and supports different operating systems.
Read Julia Gusman's full review
Nathan Smith profile photo
November 04, 2014

User Review: "Pentaho: a strong open source BI suite"

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

8
It has consistently met our needs.
Read Nathan Smith's full review
No photo available
June 10, 2014

User Review: "Pentaho Open Source"

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Renew

7
It was a fun tool to use and learn.
Read this authenticated review

Feature Scorecard Summary

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

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