TrustRadius: an HG Insights company

Pentaho

Score5.1 out of 10

132 Reviews and Ratings

Get a Demo

What is Pentaho?

Pentaho is a suite of open source business intelligence and analytics products, now offered and supported by Hitachi Data Systems since the June 2015 acquisition.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Pentaho has to offer, as determined by TrustRadius' reviewers.
Based on 132 ratings of Pentaho's features
View all features

Top Performing Features

  • Customizable dashboards

    Customizable dashboards are dashboards providing the builder some degree of control over the look and feel and display options.

    Category average: 8.3

  • Report Delivery Scheduling

    Report Delivery Schedule is the ability to have reports delivered to a destination at a specific data and time.

    Category average: 8.3

  • Multiple Access Permission Levels (Create, Read, Delete)

    Multiple access permission levels means that different levels of users have different rights.

    Category average: 8.2

Areas for Improvement

  • Single Sign-On (SSO)

    Allows users to use one set of login credentials to access multiple applications

    Category average: 8.6

  • iFrames

    An iFrame is an HTML document embedded inside another HTML document on a website

    Category average: 7.7

  • Mobile Application

    A dedicated app for iOS and/or Android.

    Category average: 7.2

Reviews

What users are saying about Pentaho.
View all reviews

Data integration made easy

Incentivized
Rafael GrandizoliView profile
Gerente de Operações in Product Management at MUV (11-50 employees employees)

Pros

  • Data Integration with (almost) any source
  • ETL jobs
  • Manage and scheduling recurrent process

Cons

  • Report development could be easier
  • Better integration with online repository
  • Native deployment and development environments

Return on Investment

  • Less time spent daily on exporting data from platforms (CSV, XLS, etc)
  • Prepare and enrich data from multiple sources
  • Automate report generation and schedule sending to clients or teams

Alternatives Considered

AWS Lambda

Other Software Used

Zoho Analytics (formerly Zoho Reports), Tableau Public, Amazon EC2 Auto Scaling

Usability

Integrate and connect all data sources with Ai engineering in the cloud environment

Ali KazempourView profile
Information Technology Adviser in Information Technology at Information Technology Adviser (1-10 employees employees)

Pros

  • Integrate and synchronize with big data easily
  • Import data from any sources and different databases
  • Managing data in on-premise, hybrid and cloud environments.
  • Compatibility and flexibility of the platform with any type of scenario and any business or industry
  • Various tools in the software suite to transformation of data
  • Simple interface appearance and creative UI graphics

Cons

  • It has good modules and they should work on more variety and new modules suitable for the service
  • Initial configuration is a bit time consuming and complicated for novice users and need smart config wizard

Return on Investment

  • Data integration and fast reporting
  • Smart Visualize and analyze data

Alternatives Considered

Cleo Integration Cloud, AWS Glue and Oracle Data Integrator

Other Software Used

MicroStrategy Analytics, SAP Data Intelligence, Google Cloud AI

Usability

My Experience with Pentaho data integrator

Incentivized
zahit bogus
Business Intelligence Consultant in Information Technology at EMO A.Ş (501-1000 employees employees)

Pros

  • I frequently use the Pentaho tool for data manipulation and data migration.
  • I use the PentahoETL tool when designing ETL processes, transporting data to the database and designing the data warehouse.
  • It is an ideal ETL tool for transporting XML and JSON-based data.

Cons

  • The error codes we received in the Pentaho ETL tool are not clear enough. Explanations need to be more detailed for quick resolution of the problem.
  • Scheduling ETL packages through the windows Task Scheduler makes things difficult. This process will be more efficient through the Pentaho tool.
  • Database connection information is timed out after a certain period of time. I sometimes have this problem even though the database password hasn't changed.

Other Software Used

Microsoft SQL Server, Oracle Data Integrator

Trust Pentaho to deliver a smooth data mining experience

Incentivized
Verified User
Analyst in Sales (10,001+ employees employees)

Use Cases and Deployment Scope

We use Pentaho to store, collaborate & present data in a more modular form, which in turn helps us in making better business decisions & also allows end-users to navigate through complex data tables in a comfortable & easy manner. Pentaho not only helps in loading up the required data quickly, but it also helps in making sure the data is well structured & presented in a simple way.

Pros

  • Excellent OLAP Services
  • Multiple tools for data mining & extraction
  • Plethora of options to transform data as per your needs

Cons

  • Data Integration takes up too much time due to server loads.
  • Data visualization has limited options to customize.
  • Data modeling can take too much time depending on complexities of the model.

Return on Investment

  • Helps in mining the data effectively & quickly.
  • Minimizes the need for human intervention, automates the tasks brilliantly.
  • Can be more expansive when it comes to data modeling.

Other Software Used

Movavi Video Editor Plus, Movie Maker Online (moviemakeronline.com), Canva

Usability

Best for Reporting and Dashboard

Verified User
Analyst in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

I use Pentaho for reporting and dashboard development. We develop the reports and integrate them with different database sources. It really helps us to achieve our business goals. I would suggest Pentaho for everyone who is looking to utilize one of the best BI tools for enhancing features with satisfying business requirements. I really love it.

Pros

  • Reporting
  • Integration
  • Flexibility

Cons

  • Cost
  • DB connector
  • High user friendly

Return on Investment

  • Enhanced decision making
  • Work management
  • Effective business growth

Alternatives Considered

Tableau Online

Other Software Used

Slack

Usability