Overall Satisfaction with Pentaho
Pentaho 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
Pentaho is more powerful with more functionality. Also it is Java based and is therefore platform independent.
Upgrading Pentaho
Yes - The new release is fully compatible with earlier release. There is no unexpected impact.