Review: "Pentaho- An adequate BI solution for users on a budget!"https://www.trustradius.com/business-intelligence-biPentahoUnspecified7.51001012016-02-26T19:52:18.050Z
Overall Satisfaction with Pentaho
Pentaho's BI stack is being used by our entire company. We use their tooling for ETL, delivering reports, and as a sort of end-point for a custom web app that we've built. The end point uses xaction and Mondrian to deliver data to our front end. We also make use of the community edition of the BI server--this houses several reports that our analyst team has built as well as resources necessary to support our custom app. In the near future we'll also be using the tool's big data plugins to ingest data into our data warehouse from hive/hadoop.
- ETL, fairly wide support for a number of different data sources, a good API for writing plugins, and great out-of-the-box functionality.
- Community support and great documentation for using their tooling.
- Mondrian/OLAP, great engine for processing MDX queries.
- pentaho's analyzer tool/front-end. This doesn't come close to competing with products like Tableau.
- Pentaho Report Designer, this looks like something that was built in the early 90's and is extremely clunky to use for new-users
- Schema Workbench, would be nice to see better support for snowflake type schemas
In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that it provides 95% of the data integration functionality that these other tools do without having to spend a fortune to do so.
This is one of the areas where I think pentaho has done a great job--and with every iteration of the product they seem to include more and more data sources to connect to. Given the data we've been working with, I don't think we've come across a situation yet where we haven't had a relatively simple connector to use.
The access control capabilities are generally sufficient, but not stellar. Most of the data sharing and access control is managed completely through pentaho's BI server, and there doesn't seem to be super strict security around the configuration and setup of permissions, who can view what reports, etc. The dashboarding capability of "putting a bunch of reports together" is extremely clunky, it's something we steer clear of trying to implement where possible.
Pentaho is very well suited for organizations looking for end-to-end BI solutions without wanting to break the bank--particularly because the community edition has most of the functionality necessary to get you started, and it's free. Honestly though, if you have deep pockets there are probably more complete solutions out there in terms of functionality
Pentaho Feature Ratings
Pixel Perfect reports
Report Formatting Templates
Integration with R or other statistical packages
Report sharing and collaboration
Publish to Web
Publish to PDF
Report Delivery Scheduling
Multi-User Support (named login)
Role-Based Security Model
Multiple Access Permission Levels (Create, Read, Delete)
Responsive Design for Web Access
Dashboard / Report / Visualization Interactivity on Mobile