Try our new research platform with insights from 80,000+ expert users

Elastic Search vs Pentaho Data Integration and Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.4
Elastic Search offers high ROI, efficiency, and cost-effectiveness, with significant time-saving and security benefits despite some licensing costs.
Sentiment score
7.9
Pentaho offers cost-effective integration, reducing ETL time, lowering expenses, and enhancing competitiveness with open-source flexibility and efficiency.
It is stable, and we do not encounter critical issues like server downtime, which could result in data loss.
The main benefits observed from using Elastic Search include improvements in operational efficiency, along with cost, time, and resource savings.
We have not purchased any licensed products, and our use of Elastic Search is purely open-source, contributing positively to our ROI.
 

Customer Service

Sentiment score
6.5
Elastic Search's customer service is praised for responsiveness and knowledge, but complex issue support may require improvement.
Sentiment score
5.2
Users rely on community support over customer service due to mixed experiences, despite responsive technical support and Hitachi's involvement.
I would rate technical support from Elastic Search as three out of ten.
Communication with the vendor is challenging
 

Scalability Issues

Sentiment score
7.3
Elastic Search is scalable and integrates well, but challenges exist with large datasets and disaster recovery under rapid scaling.
Sentiment score
7.3
Pentaho excels in scalability and efficient data handling but faces challenges with exceptionally large data and complex growth scenarios.
I would rate its scalability a ten.
I would rate the scalability of Elasticsearch as an eight.
I can actually add more storage and memory because I host it in the cloud.
Pentaho Data Integration handles larger datasets better.
 

Stability Issues

Sentiment score
7.7
Elastic Search is stable and reliable, though version updates and data management can affect performance under stress.
Sentiment score
7.1
Pentaho Data Integration offers reliability for small to midsize operations but may lag and freeze with complex uses.
The stability of Elasticsearch was very high.
The data transfer sometimes exceeded the bandwidth limits without proper notification, which caused issues.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
 

Room For Improvement

Elastic Search needs improvements in security, scalability, usability, stability, integration, support, and enhanced features for a better user experience.
Pentaho needs improvements in big data performance, error handling, UI, scheduling, backward compatibility, cloud integration, and Python support.
This can create problems for new developers because they have to quickly switch to another version.
The consistency and stability of Elasticsearch are commendable, and they should keep up the good work.
The architecture of Elastic Search could be improved as it is complicated for most general users to build up the environment and maintain the cluster.
Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
 

Setup Cost

Elastic Search's free open-source version can incur back-end costs for advanced features, expertise, and premium support.
Pentaho offers a cost-effective solution with its free Community Edition and affordable subscription-based Enterprise Edition for varying needs.
 

Valuable Features

Elastic Search is valued for scalability, fast indexing, powerful analysis, security features, cloud readiness, and strong community support.
Pentaho provides an intuitive, open-source platform for efficient ETL development and data integration with minimal coding and broad compatibility.
The most valuable feature of Elasticsearch was the quick search capability, allowing us to search by any criteria needed.
Elastic Search makes handling large data volumes efficient and supports complex search operations.
The full text search capabilities are particularly beneficial for handling large volumes of data.
It's easy to use and friendly, especially for larger data sets.
 

Categories and Ranking

Elastic Search
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
Indexing and Search (1st), Cloud Data Integration (9th), Search as a Service (1st), Vector Databases (3rd)
Pentaho Data Integration an...
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
53
Ranking in other categories
Data Integration (19th)
 

Featured Reviews

Anand_Kumar - PeerSpot reviewer
Captures data from all other sources and becomes a MOM aka monitoring of monitors
Scalability and ROI are the areas they have to improve. Their license terms are based on the number of cores. If you increase the number of cores, it becomes very difficult to manage at a large scale. For example, if I have a $3 million project, I won't sell it because if we're dealing with a 10 TB or 50 TB system, there are a lot of systems and applications to monitor, and I have to make an MOM (Mean of Max) for everything. This is because of the cost impact. Also, when you have horizontal scaling, it's like a multi-story building with only one elevator. You have to run around, and it's not efficient. Even the smallest task becomes difficult. That's the problem with horizontal scaling. They need to improve this because if they increase the cores and adjust the licensing accordingly, it would make more sense.
Aqeel UR Rehman - PeerSpot reviewer
Transform data efficiently with rich features but there's challenges with large datasets
Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
861,803 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
15%
Financial Services Firm
14%
Manufacturing Company
9%
Government
9%
Financial Services Firm
21%
Computer Software Company
14%
Government
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about ELK Elasticsearch?
Logsign provides us with the capability to execute multiple queries according to our requirements. The indexing is very high, making it effective for storing and retrieving logs. The real-time anal...
What is your experience regarding pricing and costs for ELK Elasticsearch?
We used the open-source version of Elasticsearch, which was free.
What needs improvement with ELK Elasticsearch?
It would be useful if a feature for renaming indices could be added without affecting the performance of other features. However, overall, the consistency and stability of Elasticsearch are already...
Which ETL tool would you recommend to populate data from OLTP to OLAP?
Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...
What do you think can be improved with Hitachi Lumada Data Integrations?
In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...
What do you use Hitachi Lumada Data Integrations for most frequently?
My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...
 

Also Known As

Elastic Enterprise Search, Swiftype, Elastic Cloud
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

T-Mobile, Adobe, Booking.com, BMW, Telegraph Media Group, Cisco, Karbon, Deezer, NORBr, Labelbox, Fingerprint, Relativity, NHS Hospital, Met Office, Proximus, Go1, Mentat, Bluestone Analytics, Humanz, Hutch, Auchan, Sitecore, Linklaters, Socren, Infotrack, Pfizer, Engadget, Airbus, Grab, Vimeo, Ticketmaster, Asana, Twilio, Blizzard, Comcast, RWE and many others.
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Elastic Search vs. Pentaho Data Integration and Analytics and other solutions. Updated: July 2025.
861,803 professionals have used our research since 2012.