What users are saying about
100 Ratings
100 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101

Add comparison

Likelihood to Recommend

Pentaho

The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.
No photo available

Feature Rating Comparison

BI Standard Reporting

Pentaho
7.0
Pixel Perfect reports
Pentaho
6.8
Customizable dashboards
Pentaho
7.2
Report Formatting Templates
Pentaho
7.0

Ad-hoc Reporting

Pentaho
6.3
Drill-down analysis
Pentaho
7.1
Formatting capabilities
Pentaho
6.7
Integration with R or other statistical packages
Pentaho
6.3
Report sharing and collaboration
Pentaho
5.0

Report Output and Scheduling

Pentaho
6.7
Publish to Web
Pentaho
6.2
Publish to PDF
Pentaho
7.6
Report Versioning
Pentaho
6.6
Report Delivery Scheduling
Pentaho
7.0
Delivery to Remote Servers
Pentaho
6.2

Data Discovery and Visualization

Pentaho
6.2
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.2
Location Analytics / Geographic Visualization
Pentaho
6.6
Predictive Analytics
Pentaho
5.9

Access Control and Security

Pentaho
7.4
Multi-User Support (named login)
Pentaho
7.6
Role-Based Security Model
Pentaho
7.3
Multiple Access Permission Levels (Create, Read, Delete)
Pentaho
7.4
Single Sign-On (SSO)
Pentaho
7.1

Mobile Capabilities

Pentaho
6.2
Responsive Design for Web Access
Pentaho
5.7
Dedicated iOS Application
Pentaho
6.5
Dedicated Android Application
Pentaho
6.5
Dashboard / Report / Visualization Interactivity on Mobile
Pentaho
6.1

Application Program Interfaces (APIs) / Embedding

Pentaho
6.1
REST API
Pentaho
6.8
Javascript API
Pentaho
6.4
iFrames
Pentaho
5.2
Java API
Pentaho
6.0
Themeable User Interface (UI)
Pentaho
5.6
Customizable Platform (Open Source)
Pentaho
6.4

Pros

  • The built-in ETL tools are easy to learn, and can quickly import and transform any data you have.
  • The excellent visualizations and charts are pleasing to the eye, and looks are important in sales and marketing presentations.
  • The rollout was fast, we installed the software and were building dashboards within minutes.
No photo available

Cons

  • Most of the companies use star schema in their Data Warehouses but they are not the pure star schemas. There are the bridge tables, group tables but when using Schema Workbench to design a cube, it gets very painful for the developers to accommodate such schema in it. To do this, I have to go to the XML file and add the new elements. I would love to see the feature where Schema Workbench can accommodate the bridge tables as they are the part of star schema too.
  • When it comes to ETL, I have found PDI to be the best tool, but at the report side, it is not as good as the other tools available in the market. Especially the users always complain about the graphs in the Pentaho Analyzer. I think. the UI needs a lot of improvement.
  • PDI is slow reading the JSON files. There is a fast JSON input step available in the marketplace but I think I would be great if Pentaho can make the JSON reading even faster.
  • When I export the repository, I see the files names are encoded with UTF-8 encoding. It would be great, if the spaces and the special characters can be preserved while exporting a BA repository.
Nikhil Karkare profile photo

Likelihood to Renew

Pentaho8.8
Based on 11 answers
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
Adam O'Connor profile photo

Usability

Pentaho5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand profile photo

Support

Pentaho9.9
Based on 2 answers
They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.
Deepak Paramanand profile photo

Online Training

Pentaho9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier profile photo

Implementation

Pentaho5.0
Based on 1 answer
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand profile photo

Alternatives Considered

Pentaho is not as robust or as reputable as Microsoft ETL tools, but it is great for simpler ETL solutions. It has limitations and often lacks the ability for fine-tuning, but it gets the job done and is consistently reliable. Cheaper than other products, it's a great place to start for a company interested in creating a data warehouse.
No photo available

Return on Investment

  • Pentaho has improved our overall business process.
  • Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
  • We have a started a big project using Pentaho that is going to include all the business processes in the organization.
Nikhil Karkare profile photo

Pricing Details

Pentaho

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details