Confluent vs Pentaho Data Integration and Analytics comparison

The compared Confluent and Hitachi Vantara solutions aren't in the same category. Confluent is ranked #3 in SA , with an average rating of 7.8, and holds a 8.5% mindshare in the category. Hitachi Vantara is ranked #18 in DI , with an average rating of 7.7, and holds a 1.7% mindshare. Additionally, 95% of Confluent users are willing to recommend the solution, compared to 94% of Hitachi Vantara users who would recommend it.

Confluent

Read 25 Confluent reviews

5,083 Views
2,745 Comparison Views

95% willing to recommend

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,447 Views
1,884 Comparison Views

94% willing to recommend

Confluent

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Confluent and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.

Find out in this report how the two Streaming Analytics solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Confluent vs. Pentaho Data Integration and Analytics Report (Updated: September 2025).

Buyer's Guide

Confluent vs. Pentaho Data Integration and Analytics

September 2025

Download the complete report

Helped 869,760 peers since 2012

Review summaries and opinions

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

Categories and Ranking

Confluent

Average Rating

8.2

Reviews Sentiment

6.3

Number of Reviews

Ranking in other categories

Streaming Analytics (3rd)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (18th)

Mindshare comparison

Confluent and Pentaho Data Integration and Analytics aren’t in the same category and serve different purposes. Confluent is designed for Streaming Analytics and holds a mindshare of 8.5%, down 9.7% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.7% mindshare, up 1.1% since last year.

Streaming Analytics Market Share Distribution
Product	Market Share (%)
Confluent	8.5%
Apache Flink	14.8%
Databricks	12.5%
Other	64.2%

Streaming Analytics

Data Integration Market Share Distribution
Product	Market Share (%)
Pentaho Data Integration and Analytics	1.7%
Informatica PowerCenter	6.0%
SSIS	5.7%
Other	86.6%

Data Integration

Featured Reviews

PavanManepalli

AVP - Sr Middleware Messaging Integration Engineer at Wells Fargo

Has supported streaming use cases across data centers and simplifies fraud analytics with SQL-based processing

I recommend that Confluent should improve its solution to keep up with competitors in the market, such as Solace and other upcoming tools such as NATS. Recently, there has been a lot of buzz about Confluent charging high fees while not offering features that match those of other tools. They need to improve in that direction by not only reducing costs but also providing better solutions for the problems customers face to avoid frustrations, whether through future enhancement requests or ensuring product stability. The cost should be worked on, and they should provide better solutions for customers. Solutions should focus on hierarchical topics; if a customer has different types of data and sources, they should be able to send them to the same place for analytics. Currently, Confluent requires everything to send to the same topic, which becomes very large and makes running analytics difficult. The hierarchy of topics should be improved. This part is available in MQ and other products such as Solace, but it is missing in Confluent, leading many in capital markets and trading to switch to Solace. In terms of stability, it is not the stability itself that needs improvement but rather the delivery semantics. Other products offer exactly-once delivery out of the box, whereas Confluent states it will offer this but lacks the knobs or levers for tuning configurations effectively. Confluent has hundreds of configurations that application teams must understand, which creates a gap. Users are often unaware of what values to set for better performance or to achieve exactly-once semantics, making it difficult to navigate through them. Delivery semantics also need to be worked on.

Read full review

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

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…

Read full review

Quotes from Members

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

Pros

"Confluent facilitates the messaging tasks with Kafka, streamlining our processes effectively."

"The most valuable feature that we are using is the data replication between the data centers allowing us to configure a disaster recovery or software. However, is it's not mandatory to use and because most of the features that we use are from Apache Kafka, such as end-to-end encryption. Internally, we can develop our own kind of product or service from Apache Kafka."

"I would rate the scalability of the solution at eight out of ten. We have 20 people who use Confluent in our organization now, and we hope to increase usage in the future."

"The most valuable is its capability to enhance the documentation process, particularly when creating software documentation."

"Some of the best features are that it's very quick to set up, very easy to have a centralized area that gives us a history of changes, and the ability to give feedback on any information placed onto the pages."

"The solution can handle a high volume of data because it works and scales well."

"Their tech support is amazing; they are very good, both on and off-site."

"Kafka Connect framework is valuable for connecting to the various source systems where code doesn't need to be written."

More Confluent pros

"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."

"The solution has a free to use community version."

"This solution allows us to create pipelines using a minimal amount of custom coding."

"It is easy to use, install, and start working with."

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."

"It's very simple compared to other products out there."

"I find the drag and drop feature in Pentaho Data Integration very useful for integration."

"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."

More Pentaho Data Integration and Analytics pros

Cons

"I am not very impressed by Confluent. We continuously face issues, such as Kafka being down and slow responses from the support team."

"It could be improved by including a feature that automatically creates a new topic and puts failed messages."

"It would help if the knowledge based documents in the support portal could be available for public use as well."

"Confluent has fallen behind in being the tool of the industry. It's taking second place to things such as Word and SharePoint and other office tools that are more dynamic and flexible than Confluent."

"There is a limitation when it comes to seamlessly importing Microsoft documents into Confluent pages, which can be inconvenient for users who frequently work with Microsoft Office tools and need to transition their content to Confluent."

"Areas for improvement include implementing multi-storage support to differentiate between database stores based on data age and optimizing storage costs."

"It could be more user-friendly and centralized. A way to reduce redundancy would be helpful."

"Confluent's price needs improvement."

More Confluent cons

"There is not a data quality or MDM solution in the Pentaho DI suite."

"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."

"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."

"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."

"Communicating with the vendor is challenging, and this hinders its performance in free tool setups."

"Larger data jobs take more time to execute."

"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."

"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

"Confluent has a yearly license, which is a bit high because it's on a per-user basis."

"It comes with a high cost."

"The pricing model of Confluent could improve because if you have a classic use case where you're going to use all the features there is no plan to reduce the features. You should be able to pick and choose basic services at a reduced price. The pricing was high for our needs. We should not have to pay for features we do not use."

"The solution is cheaper than other products."

"Confluent is highly priced."

"Confluent is an expensive solution as we went for a three contract and it was very costly for us."

"On a scale from one to ten, where one is low pricing and ten is high pricing, I would rate Confluent's pricing at five. I have not encountered any additional costs."

"Confluence's pricing is quite reasonable, with a cost of around $10 per user that decreases as the number of users increases. Additionally, it's worth noting that for teams of up to 10 users, the solution is completely free."

More Confluent pricing and cost advice

"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"

"The cost of these types of solutions are expensive. So, we really appreciate what we get for our money. Though, we don't think of the solution as a top-of-the-line solution or anything like that."

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"There was a cost analysis done and Pentaho did favorably in terms of cost."

"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."

"It does seem a bit expensive compared to the serverless product offering. Tools, such as Server Integration Services, are "almost" free with a database engine. It is comparable to products like Alteryx, which is also very expensive."

More Pentaho Data Integration and Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Streaming Analytics solutions are best for your needs.

See recommendations

869,760 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

13%

Retailer

Manufacturing Company

Financial Services Firm

18%

Computer Software Company

11%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	6
Midsize Enterprise	4
Large Enterprise	16

By reviewers
Company Size	Count
Small Business	17
Midsize Enterprise	16
Large Enterprise	25

Questions from the Community

What do you like most about Confluent?

I find Confluent's Kafka Connectors and Kafka Streams invaluable for my use cases because they simplify real-time data processing and ETL tasks by providing reliable, pre-packaged connectors and to...

See all answers

What is your experience regarding pricing and costs for Confluent?

They charge a lot for scaling, which makes it expensive.

See all answers

What needs improvement with Confluent?

People do not appreciate that Confluent is pushing us more towards Teams because they want to use a true Microsoft Word-type format where we can format our sentences better, instead of just saying ...

See all answers

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...

See all answers

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, ...

See all answers

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...

See all answers

Comparisons

Amazon Kinesis vs Confluent

Compared 13% of the time

Apache Flink vs Confluent

Compared 12% of the time

Databricks vs Confluent

Compared 9% of the time

Amazon MSK vs Confluent

Compared 7% of the time

AWS Glue vs Confluent

Compared 5% of the time

More Confluent Competitors

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 14% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 9% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Confluent

October 2025

Download Confluent product report

Buyer's Guide

Pentaho Data Integration and Analytics

September 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

No data available

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

Confluent is an enterprise-ready, full-scale streaming platform that enhances Apache Kafka.

Confluent has integrated cutting-edge features that are designed to enhance these tasks:

Speed up application development and connectivity
Enable transformations through stream processing
Streamline business operations at scale
Adhere to strict architectural standards

Confluent is a more complete distribution of Kafka in that it enhances the integration possibilities of Kafka by introducing tools for managing and optimizing Kafka clusters while providing methods for making sure the streams are secure. Confluent supports publish-and-subscribe as well as the storing and processing of data within the streams. Kafka is easier to operate and build thanks to Confluent.

Confluent's software is available in three different varieties:

A free, open-source streaming platform that makes it simple to start using real-time data streams
An enterprise-grade version of the product with more administrative, ops, and monitoring tools
A premium cloud-based version.

Confluent Advantage Features

Confluent has many valuable key features. Some of the most useful ones include:

Multi-language
- Clients: C++, Python, Go, and .NET
- REST proxy: Can connect to Kafka from any connected network device
- Admin REST APIs: RESTful interface for performing administrator operations

Pre-built ecosystem
- Connectors: More than 100 supported connectors, including S3, Elastic, HDFS, JDBC
- MQTT proxy: Gain access to Kafka from MQTT gateways and devices
- Schema registry: Centralized database to guarantee data compatibility

Streaming database
- ksqlDB: Materialized views and real-time stream processing

GUI management
- Control panel: GUI for scalable Kafka management and monitoring
- Health+: Smart alerts and cloud-based control centers

DevOps automation that is flexible
- Confluent for Kubernetes: Complete API to deploy on Kubernetes
- Automated Ansible deployment on non-containerized environments

Dynamic performance
- Self-balancing clusters: Automated partition re-balancing across brokers in the cluster
- Tiered storage: Older Kafka data offloading to object storage with transparent access

Security that is enterprise-grade
- Role-based access control: Granular user/group access authorization
- Audit logs that are structured: Logs of user actions kept in dedicated Kafka topics
- Secret protection: Sensitive information is encrypted

Global resilience
- Linking clusters: A real-time, highly reliable, and consistent bridge across on-premises and cloud environments
- Multiple-region clusters: Single Kafka cluster with automated client failover distributed across multiple data centers
- Replicator: Asynchronous replication that is based on the Kafka Connect framework

Support
- Round the clock enterprise support from Kafka experts

Reviews from Real Users

Confluent stands out among its competitors for a number of reasons. Two major ones are its robust enterprise support and its open source option. PeerSpot users take note of the advantages of these features in their reviews:

Ravi B., a solutions architect at a tech services company, writes of the solution, “KSQL is a valuable feature, as is the Kafka Connect framework for connecting to the various source systems where you need not write the code. We get great support from Confluent because we're using the enterprise version and whenever there's a problem, they support us with fine-tuning and finding the root cause.”

Amit S., an IT consultant, notes, “The biggest benefit is that it is open source. You have the flexibility of opting or not opting for enterprise support, even though the tool itself is open source.” He adds, “The second benefit is it's very modern and built on Java and Scala. You can extend the features very well, and it doesn't take a lot of effort to do so.”

Confluent

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

ING, Priceline.com, Nordea, Target, RBC, Tivo, Capital One, Chartboost

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Buyer's Guide

Confluent vs. Pentaho Data Integration and Analytics

September 2025

Free Report: Confluent vs. Pentaho Data Integration and Analytics

Find out what your peers are saying about Confluent vs. Pentaho Data Integration and Analytics and other solutions. Updated: September 2025.

DOWNLOAD NOW

869,760 professionals have used our research since 2012.

See our Confluent vs. Pentaho Data Integration and Analytics report.

We monitor all Streaming Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.