Pentaho

Pentaho

Data integration & business analytics platform

4.2/5 (36 reviews)

Pentaho Overview

Pentaho’s objective is to help organizations across multiple industries harness the value from all their data, including big data and IoT (Internet of Things), enabling them to find new revenue streams, operate more efficiently, deliver outstanding service and minimize risk.

Pentaho provides data solutions to enterprise level organizations across the healthcare, retail, financial services and government sectors. It enables business users to access, manage and combine data from multiple sources, and decision makers to then drill-down into data through interactive visual analysis. Data insights can then be used to make information-driven decisions with business analytics tools from Pentaho.

The Pentaho solution supports big data, data integration, embedded analytics, business analytics, internet of things analytics, and cloud business analytics. It also includes services such as custom dashboards, consulting services, training, certification program, enterprise support, technical support and workshops.

Pricing

Starting from
N/A
Pricing options
Free Trial
Open Source
Value for money

Devices

Business size

S
M
L

Markets

Australia, Canada, Europe, Germany, India and 4 others, Latin America, Middle-East and Africa, United Kingdom, United States

Supported Languages

English, French, German

Pentaho Reviews

Overall rating
4.2/5
89% positive reviews
15
Excellent
17
Very good
3
Average
0
Poor
1
Terrible
Felix F.

Once you understand the basics of this program it is very, but very easy to use

Used Daily for 1+ year
Reviewed on 2018/05/22
Review Source: SoftwareAdvice

Pros

"higher visual interface to processes, has a good number of functions (and very easy to understand) for data reporting, integration, data mining and ETL.. very simple but effective Big data transform

You can build many dimensional model and load the results of the transformation into a database to develop any report whit low margin of error through a dimensional model and load the results of the transformation into a database to develop specialized reports , low margin of error-Automate the steps for execution"

Cons

Its a great tool to use, nothing to dislike about the product. Nothing to dislike, everything is good. All the features are really good.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10
Kavan D.

Pentaho, a great open source BI suit with strong community support

Used Daily for 2+ years
Reviewed on 2017/06/16
Review Source: SoftwareAdvice

One of the best opensource BI tool, also well integrated with existing platforms. It will be interesting to see how will it get integrated with fast evolving Big data technologies. Pentaho 7.1 is step in right direction.

Pros

- We mature DI (Data integration) module
- Easy to learn design console (Spoon)
- wide community support
- Very well integrated with different platforms
- Innovating fast in Big data world specially Pentaho 7.1

Cons

- Not very well documented for latest releases one of the reasons is many innovation are happening very fast

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

7.0/10
Senando B.

Great partner of IT business analyst

Used Daily for 1+ year
Reviewed on 2019/01/15
Review Source: SoftwareAdvice

Using this kind of software brings ease and accurate data reports that helps the company on decision making

Pros

Easy to use, compatible in many database such as mysql, ms sql server, different type of output to choose such as excel, html, richtext, etc.

Cons

Some version are slow on initializing and fetching data such as Pentaho report designer version 5 and above. Unlike version 3 which has smooth process, that was base on my experience.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10
Riyaadh K.

ETL on the fly

Used Other for 2+ years
Reviewed on 2018/10/31
Review Source: SoftwareAdvice

Pros

Drag and drop functionality makes it easy to create transformations. Able to analyse data from multiple sources quickly and efficiently. Jobs can be scheduled in order to run specific tasks and transformations at a certain time.

Cons

Can take some time to figure out how to use it as there are lots of components involved. Can be a bit slow or run into out of memory issues for bigger queries but upping the virtual memory in the configuration can fix this issue.

Rating breakdown

Ease of Use

Likelihood to recommend

9.0/10
James W.

Saves me not only hours, but DAYS

Used Daily for 6-12 months
Reviewed on 2017/02/23
Review Source: SoftwareAdvice

Pros

Pentaho has nice schema browsing features whereby one not need know anything about the underlying schema in order to design a transformation. Automatic multi-threading by default.

Cons

When outputting to a table, Talend has an option to Drop if exists, and create. Pentaho has a Truncate [prior to load], but no option create the table as part of the data flow nor an option to drop an existing table.

Rating breakdown

Value for Money
Ease of Use

Likelihood to recommend

10.0/10

Pentaho Pricing

Starting from
N/A
Pricing options
Free Trial
Open Source
Value for money

Contact Pentaho for pricing information.

Pentaho Features

  • API
  • Activity Dashboard
  • Ad hoc Reporting
  • Business Intelligence
  • Charting
  • Customizable Reporting
  • Dashboard Creation
  • Data Filtering
  • Data Import/Export
  • Data Visualization
  • Drag & Drop Interface
  • Graphical Data Presentation
  • Real Time Analytics
  • Reporting & Statistics
  • Visual Analytics

  • Monitoring
  • Real Time Data
  • Real Time Reporting
  • Third Party Integration
  • Trend Analysis

Additional information for Pentaho

Key features of Pentaho

  • API
  • Access control
  • Active Directory integration
  • Activity dashboard
  • Ad hoc analysis
  • Ad hoc query
  • Ad hoc reporting
  • Agile views
  • Auditing
  • Automatic notifications
  • Blended big data
  • Business analysis
  • Business analytics
  • Business intelligence
  • Certification program
  • Charting
  • Content permissions
  • Custom visualizations
  • Customizable branding
  • Customizable reporting
  • Dashboard creation
  • Data analytics
  • Data backup & recovery
  • Data filtering
  • Data import/export
  • Data ingestion
  • Data integration
  • Data manipulation
  • Data mining
  • Data profiling
  • Data refinery
  • Data transformation
  • Data visualization
  • Data warehousing
  • Database integration
  • Drag & drop integration
  • Enterprise reporting
  • Filtered views
  • Geographic maps
  • Graphical data presentation
  • Graphical extract-transform-load (ETL) tool for big data
  • Hadoop distributions support
  • Heatmap
  • Imbedded analytics
  • Integrated debugger
  • Integrated enterprise scheduler
  • Interactive analysis
  • Interactive dashboards
  • Interactive reporting
  • Interactive visualizations
  • IoT analytics
  • IoT systems integration
  • Job roll-back & restart
  • Mobile BI
  • Multi-dimensional analytics
  • Multi-tenacy
  • Native Kafka plug-in
  • NoSQL stores integration
  • ODS
  • OLAP
  • Performance management
  • Performance monitoring
  • Pipeline management
  • Predictive analytics
  • Predictive analytics
  • Prototype & publish data models
  • Real time analytics
  • Self service portal
  • Self-service reports
  • Single sign on
  • Version control
  • Visual analytics
  • Visual design & automation
  • Workflow management

Benefits

  • Intuitive web-based data access wizard and interactive reporting for business users.

  • Pentaho offers powerful data integration and federation for IT and developers, accessing and integrating diverse data types; from Excel to Hadoop.

  • Interactive visual analysis allows decision makers to drill into data for greater insight.

  • Pentaho offers an extensive library of interactive visualizations to find patterns and anomalies, including geo-mapping, heat grids and scatter/bubble charts.

  • Drill-down functionality into supporting reports and dashboards provides deeper analysis whilst extreme scale in-memory data caching allows for speed-of-thought analysis with large data volumes.

  • Access, manage and blend data from any source using data integration tools from Pentaho. Integrate business analytics with other applications, including Google Maps.

  • Turn data into insights and make information-driven decisions with Pentaho's business analytics tools.

  • Pentaho FAQs

    Below are some frequently asked questions for Pentaho.

    Q. What type of pricing plans does Pentaho offer?

    Pentaho offers the following pricing plans:

    Pricing model: Open Source

    Free Trial: Available

    Contact Pentaho for pricing information.

    Q. What are the main features of Pentaho?

    Pentaho offers the following features:

    • API
    • Access control
    • Active Directory integration
    • Activity dashboard
    • Ad hoc analysis
    • Ad hoc query
    • Ad hoc reporting
    • Agile views
    • Auditing
    • Automatic notifications
    • Blended big data
    • Business analysis
    • Business analytics
    • Business intelligence
    • Certification program
    • Charting
    • Content permissions
    • Custom visualizations
    • Customizable branding
    • Customizable reporting
    • Dashboard creation
    • Data analytics
    • Data backup & recovery
    • Data filtering
    • Data import/export
    • Data ingestion
    • Data integration
    • Data manipulation
    • Data mining
    • Data profiling
    • Data refinery
    • Data transformation
    • Data visualization
    • Data warehousing
    • Database integration
    • Drag & drop integration
    • Enterprise reporting
    • Filtered views
    • Geographic maps
    • Graphical data presentation
    • Graphical extract-transform-load (ETL) tool for big data
    • Hadoop distributions support
    • Heatmap
    • Imbedded analytics
    • Integrated debugger
    • Integrated enterprise scheduler
    • Interactive analysis
    • Interactive dashboards
    • Interactive reporting
    • Interactive visualizations
    • IoT analytics
    • IoT systems integration
    • Job roll-back & restart
    • Mobile BI
    • Multi-dimensional analytics
    • Multi-tenacy
    • Native Kafka plug-in
    • NoSQL stores integration
    • ODS
    • OLAP
    • Performance management
    • Performance monitoring
    • Pipeline management
    • Predictive analytics
    • Predictive analytics
    • Prototype & publish data models
    • Real time analytics
    • Self service portal
    • Self-service reports
    • Single sign on
    • Version control
    • Visual analytics
    • Visual design & automation
    • Workflow management

    Q. Who are the typical users of Pentaho?

    Pentaho has the following typical customers:

    Large Enterprises, Mid Size Business, Small Business

    Q. What languages does Pentaho support?

    Pentaho supports the following languages:

    English, French, German

    Q. What type of pricing plans does Pentaho offer?

    Pentaho has the following pricing plans:

    Open Source

    Q. Does Pentaho support mobile devices?

    Pentaho supports the following devices:

    iPhone, iPad

    Q. What other apps does Pentaho integrate with?

    Pentaho integrates with the following applications:

    AlayaCare, Bitium, Predixion, bpm'online CRM, bpm'online financial CRM, bpm'online marketing, bpm'online real estate, bpm'online sales, bpm'online service, bpm'online studio

    Q. What level of support does Pentaho offer?

    Pentaho offers the following support options:

    FAQs, Online Support, Phone Support, Video Tutorials