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.
Pentaho is free and powerful. It is user friendly and with ample documentation.
Pentaho is well suited for ETL processing and database population. It is less appropriate for visualization and analytics. Key question is the benefit it can bring and the cost and robustness.
Yes - The new release is fully compatible with earlier release. There is no unexpected impact.