TrustRadius
Pentaho Review 13 of 24
User Review: "An implementor view on Pentaho tools."
https://www.trustradius.com/business-intelligence-biPentahoUnspecified7.5100101
No photo available
February 23, 2016

User Review: "An implementor view on Pentaho tools."

Score 7 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

We used the Pentaho Data Integration tool to pre-process some data and fill thr production database. It was used in the department where I worked. Being a software developer I made a decision to use PDI instead of writing scripts on Python. The main advantage of PDI was supporting scaling out of the box, and the ability to run on multiple machines. When you need something less than a Hadoop cluster but bigger than self-made quick scripts it fits well.
  • The main strength of Pentaho (PDI) is that it is free. No need for additional license approvals to implement something quickly using the UI tool.
  • It has Pentaho Reporting - the ability to use reporting on top of PDI transformations is a powerful feature. PDI can handle data extraction, and with reporting you can create a simple report on this data. They all just work with each other without additional integration required.
  • And most of Pentaho projects are open-source. That helps a lot when debugging something.
  • Help documentation is an area for improvements. A lot of features and side effects just not documented.
  • PDI uses swt. It has a lot of troubles with this dependency. It is run on Java, but with swt - and you are stuck with a platform that supports swt. ARM architecture does not have swt support out of the box.
  • Online jobs/transformations creation. Jobs/transformations are just xml. So the lack of online editor is just 'it was not implemented yet'.
  • Strange /Pentaho-solutions placement. Application is not deployed on a server in a standard way. Instead - a server should be embedded into a 'Pentaho solution' - very strange architecture.
Did not have any other products similar to what Pentaho offers out-of-the box for free. The closest was to write some scripts manually so in our case PDI has beat Python scripts.
The most powerful feature and reason we use this software. As I already wrote - it can handle most of the possible data out of the box. From sql sources, to no-sql, and read from HDFS etc.
Did not use this feature. The reason was to use it required a user to install/run bi server, but we are not comfortable with the design bi server brings. We would prefer to use some self-contained functionalities of what can we get from Pentaho like reporting, or a PDI, and implement access control.
There are different Pentaho features, and each one has its own specific scenario where it is best suited. Reporting - is for generating boring Excel like reports, with calculations etc. For data visualization reporting is not a [good] tool. PDI is used for creation data transformations, from almost any source of data. But it is very heavy weighted. It has Hadoop and other support. But hand made code runs faster than transformation made in Spoon. And there are some algorithms that can be much easily written manually.

Pentaho Feature Ratings

Pixel Perfect reports
10
Customizable dashboards
Not Rated
Report Formatting Templates
Not Rated
Drill-down analysis
Not Rated
Formatting capabilities
Not Rated
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
Not Rated
Publish to Web
Not Rated
Publish to PDF
10
Report Versioning
Not Rated
Report Delivery Scheduling
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
Not Rated
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
Not Rated
Role-Based Security Model
Not Rated
Multiple Access Permission Levels (Create, Read, Delete)
Not Rated
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