Pentaho Data Integration Review

Let our Business Intelligence Software Experts help you find the right Software for your Business!

Last updated: Jan 30, 2020

Pentaho Data Integration Review

ITQlick rating
(4.5/5)

Starting from $100 per user/month

Pentaho Data Integration is a data integration platform that can deliver “analytics ready” and accurate data from any source to end users. The visual tools included in this solution can eliminate complexity and...

  • Categories (4/21):

    • Dashboards & KPIs
    • Data mining
    • ETL
    • OLAP

Shlomi Lavi / updated: Jan 30, 2020

What is Pentaho Data Integration Used For?

Pentaho Data Integration is a data integration platform that can deliver “analytics ready” and accurate data from any source to end users. The visual tools included in this solution can eliminate complexity and coding and offers all data sources at the fingertips of users.

Pentaho, the company behind this data integration software, has been providing data integration and business analytics solution since 2004. The Orlando, Florida based company has served more than 1,200 enterprise customers so far including Marketo, Kiva and Swissport. The company is popular for providing cost-effective suite for data access, analysis, integration, visualization and mining.

Average Rating -

The rating of Pentaho Data Integration is 4.5 stars out of 5. The rating is based on ITQlick expert review.

Typical Customers

Pentaho Business Analytics is perfect for companies of various shapes and sizes. Retail, healthcare, manufacturing, gaming, finance, education, nonprofits and logistics industries can use this software. Mozilla, OLX and Swissport are some of the clients of Pentaho Business Analytics.

Features

Pentaho Business Analytics comes with user-friendly visual designer with drag and drop support, big data integration support, flexible and native support for big data sources and powerful management and administration features. The solution comes with a Graphical ETL tool to process and load big data sources easily and includes a wide collection of pre-built components. It’s also easy to tune and test job execution using the integrated debugger.

The complete visual big data integration tools can accelerate the deploying, developing and designing time of big data analytics and doesn’t require any coding. The software can help users to get access to data quickly and turn it into a highly professional business document. The parallel processing engine included in this data integration solution ensures enterprise scalability and high performance. The software offers flexible and native support for big data sources including Hadoop, Cloudera and Hortonworks.

Pentaho Data Integration 10 Pros

  • Pentaho Business Analytics supports visualizing and analyzing various data across multiple dimensions
  • Pentaho Business Analytics offers true mobile experience for users which can be used from anywhere
  • Pentaho Business Analytics provides 24x7 technical live support to its users
  • The interactive visual analysis feature can give users immediate access to any data
  • The business analytic software offers a 30-day free trial version for users
  • Pentaho Data Integration offers flexible and native support for all big data sources
  • Pentaho Data Integration’s big data integration tools doesn’t require any coding skills
  • The customer support of Pentaho Data Integration offers 24x7 online and phone support
  • The data integration solution is user-friendly and can be accessed by business users easily
  • The data integration software’s report presentation is feature rich, professional and clean

Pentaho Data Integration 2 Cons

  • Pentaho Business Analytics includes a Weka data-mining module that is less capable and advanced compared to other similar tools
  • Pentaho Business Analytics’ documentation is weak comparing to other similar tools and can be difficult to use for some users

Competitors & Alternatives

Talend and SSIS are the competitors of Pentaho Data Integration. Talend Data Integration provides a set of open source tools with ETL for business intelligence, massive scale integration, native connectivity to databases and real-time tracking with management, debugging, testing and tuning features. However, Talend’s interface is not highly intuitive comparing to Pentaho Data Integration.

SSIS is another popular data integration solution that comes with import/exportwizard, event handlers, variables and precedence constraints features. However, SSIS is slightly expensive comparing to Pentaho and Pentaho is more user-friendly.

Pentaho Data Integration Pricing Information

The cost of license starting from $100 per user/month. The experts at ITQlick has reviewed Pentaho Data Integration pricing and gave the software a total cost of ownership (TCO) rating of 6 out of 10. Custom price cost for your business is available upon request.

Questions to ask the vendor during a demo

Schedule a demo and access 25 must ask questions for the vendor while watching Pentaho Data Integration in action

Pentaho Data Integration Categories

Dashboards & KPIs
Data mining
ETL
OLAP
Predictive analytics
Query and Report Writer
Data integration
Enterprise Integration
Enterprise application integration: EAI
Business Intelligence
Cloud BI
Dashboards & KPIs

Specifications

Company:
Address: Pentaho, Hazeltine National Drive, Orlando, FL
Customers: Small business, Medium business, Large business
Business Area: Cross Business Areas
Platforms: Desktop, Cloud
Operating Systems: Mac OS, Windows, Linux

Pentaho Data Integration Features

Data Import/Export
Basic Reports
Online Customer Support
Basic Reports
Dashboard
Data Import/Export
Online Customer Support
Forecasting & Budgeting
OLAP
Data analysis
Dashboards & KPIs
Project Budgeting

Pentaho Data Integration Vs. Alternatives

ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick score ITQlick Score is a 1 to 100 score, based on pricing, and functionality Vs. alternative solutions
Pricing score pricing Score is a 1 to 10 score, based on the TCO (cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
License pricing license pricing (if provided by the software vendor)
Hosting
Functionality score
Fit small business
Fit medium business
Fit large business
Software review
Compare
Pentaho
ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick Score
70/100
Pricing score Pricing score ranges between 1 to 10 while 1 is low TCO and 10 is high TCO (TCO - total cost of ownership: cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
6/10
License pricing license pricing (if provided by the software vendor)
$100 per user/month
Hosting
On premise and Cloud
Functionality score
33
Fit small business
Fit medium business
Fit large business
Software review
QlikView
ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick Score
95/100
Pricing score Pricing score ranges between 1 to 10 while 1 is low TCO and 10 is high TCO (TCO - total cost of ownership: cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
3/10
License pricing license pricing (if provided by the software vendor)
$15 per user/month
Hosting
On premise and Cloud
Functionality score
15
Fit small business
Fit medium business
Fit large business
Software review
SuiteAnalytics
ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick Score
94/100
Pricing score Pricing score ranges between 1 to 10 while 1 is low TCO and 10 is high TCO (TCO - total cost of ownership: cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
3/10
License pricing license pricing (if provided by the software vendor)
$499 per month
Hosting
On premise and Cloud
Functionality score
10
Fit small business
Fit medium business
Fit large business
Software review
Sisense
ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick Score
94/100
Pricing score Pricing score ranges between 1 to 10 while 1 is low TCO and 10 is high TCO (TCO - total cost of ownership: cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
4/10
License pricing license pricing (if provided by the software vendor)
Pricing not available
Hosting
On premise and Cloud
Functionality score
35
Fit small business
Fit medium business
Fit large business
Software review
Balanced
ITQlick rating ITQlick Rating is based on the software score (below) and aggregated online reviews
ITQlick Score
92/100
Pricing score Pricing score ranges between 1 to 10 while 1 is low TCO and 10 is high TCO (TCO - total cost of ownership: cost of licences, customizations, training, hardware when relevant) Vs. alternative solutions
8/10
License pricing license pricing (if provided by the software vendor)
$125 per user/month
Hosting
Cloud
Functionality score
16
Fit small business
Fit medium business
Fit large business
Software review