Pentaho for Quality Assurance
February 24, 2016
Pentaho for Quality Assurance
Score 8 out of 10
Vetted Review
Verified User
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.