TrustRadius
Pentaho Review 11 of 24
User Review: "Pentaho for Quality Assurance"
https://www.trustradius.com/business-intelligence-biPentahoUnspecified7.5100101
No photo available
February 24, 2016

User Review: "Pentaho for Quality Assurance"

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

At our organization we are building a data ware house for data migration and analytics. After researching several options we went for the Pentaho community edition which is an open source tool. Pentaho played big role in the implementation of ETL jobs and QA testing. The features available in Pentaho covered all of our scenarios, plus it allowed us to plug in external jars to use for any unsupported activity.
  • Pentaho allows for migration from one system to another system without much trouble.
  • Minimum code or almost no code expertise is required. Just get your SQL and Pentaho will do rest.
  • It is difficult to verify millions of rows. But with Pentaho you can do that, this makes the QA task easier.
  • Pentaho does make comparison of data between two systems fairly easier compared to other systems, but it lags in terms of output you get. The output has a merge difference option which will show a difference transaction only but if you have large data set columns it is not easy to find issues.
  • Date formatting and number formatting is again an issue, both the systems should have the same datatype. It was difficult for us to compare as a new system had updated data types and pentaho failed to compare these.
Except SQL server all other db we are able to merge data easily, with SQL server to oracle we had some connectivity issues which can be overcome easily over the time.
As we used the Community edition we didn't have any access control capabilities. But sharing data and connections was fairly easy. By just sharing kettle properties you can get most of the settings. On security again, our edition was the Community edition so we didn't bother that much.

Pentaho is well suited for:


  • Migration of large data.
  • Reading XML file and processing data.
  • QA Testing.
  • Data modeling.
  • Data processing.
It is less appropriate for:

  • DataType validation
  • Reporting

Pentaho Feature Ratings

Pixel Perfect reports
7
Customizable dashboards
9
Report Formatting Templates
7
Drill-down analysis
8
Formatting capabilities
8
Report sharing and collaboration
8
Publish to Web
8
Publish to PDF
8
Report Versioning
9
Report Delivery Scheduling
8
Pre-built visualization formats (heatmaps, scatter plots etc.)
8
Location Analytics / Geographic Visualization
9
Predictive Analytics
10
Multi-User Support (named login)
6
Role-Based Security Model
6
Multiple Access Permission Levels (Create, Read, Delete)
6
Responsive Design for Web Access
Not Rated
Dedicated iOS Application
Not Rated
Dedicated Android Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated