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. - 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 format
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.
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

Online Training

Course Taken: DI1000 Pentaho Data Integration Fundamentals
A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great!
The Course
The 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE.
Course Description:

Read Stephanie Dozier'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