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

Equalum vs Pentaho Data Integration and Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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

Equalum
Ranking in Data Integration
54th
Average Rating
9.2
Reviews Sentiment
7.1
Number of Reviews
7
Ranking in other categories
Data Replication (16th), Cloud Data Integration (27th)
Pentaho Data Integration an...
Ranking in Data Integration
22nd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
53
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2025, in the Data Integration category, the mindshare of Equalum is 0.2%, up from 0.1% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.6%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

reviewer1525674 - PeerSpot reviewer
Frees staff to focus on data workflow and on what can be done with data, and away from the details of the technology
There are areas they can do better in, like most software companies that are still relatively young. They need to expand their capabilities in some of the targets, as well as source connectors, and native connectors for a number of large data sources and databases. That's a huge challenge for every company in this area, not just Equalum. If I had the wherewithal to create a tool that could allow for all that connectivity, it would be massive, out-of-the-box. There are all the updates every month. An open source changes constantly, so compatibility for these sources or targets is not easy. And a lot of targets are proprietary and they actually don't want you to connect with them in real time. They want to keep that connectivity for their own competitive tool. What happens is that a customer will say, "Okay, I've got Oracle, and I've got MariaDB, and I've got SQL Server over here, and I've got something else over there. And I want to aggregate that, and put it into Google Cloud Platform." Having connectors to all of those is extremely difficult, as is maintaining them. So there are major challenges to keeping connectivity to those data sources, especially at a CDC level, because you've got to maintain your connectors. And every change that's made with a new version that comes out means they've got to upgrade their version of the connector. It's a real challenge in the industry. But one good thing about Equalum is that they're up for the challenge. If there's a customer opportunity, they will develop and make sure that they update a connector to meet the needs of the customer. They'll also look at custom development of connectors, based on the customer opportunity. It's a work in progress. Everybody in the space is in the same boat. And it's not just ETL tools. It's everybody in the Big Data space. It's a challenge. The other area for improvement, for Equalum, is their documentation of the product. But that comes with being a certain size and having a marketing team of 30 or 40 people and growing as an organization. They're getting there and I believe they know what the deficiencies are. Maintaining and driving a channel business, like Equalum is doing, is really quite a different business model than the direct-sales model. It requires a tremendous amount of documentation, marketing information, and educational information. It's not easy.
Ryan Ferdon - PeerSpot reviewer
Low-code makes development faster than with Python, but there were caching issues
If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was. It was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

Quotes from Members

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

Pros

"It's a really powerful platform in terms of the combination of technologies they've developed and integrated together, out-of-the-box. The combination of Kafka and Spark is, we believe, quite unique, combined with CDC capabilities. And then, of course, there are the performance aspects. As an overall package, it's a very powerful data integration, migration, and replication tool."
"The main impact for Oracle LogMiner is the performance. Performance is drastically reduced if you use the solution’s Oracle Binary Log Parser. So, if we have 60 million records, initially it used to take a minute. Now, it takes a second to do synchronization from the source and target tables."
"It's got it all, from end-to-end. It's the glue. There are a lot of other products out there, good products, but there's always a little bit of something missing from the other products. Equalum did its research well and understood the requirements of large enterprise and governments in terms of one tool to rule them all, from a data migration integration perspective."
"All our architectural use cases are on a single platform, not multiple platforms. You don't have to dump into different modules because it is the same module everywhere."
"Equalum has resulted in system performance improvements in our organization. Now, I am ingressing data off of multiple S3 sources, doing data processing, and formatting a schema. This would usually take me a couple of days, but now it takes me hours."
"Equalum provides a single platform for core architectural use cases, including CDC replication, streaming ETL, and batch ETL. That is important to our clients because there is no other single-focus product that covers these areas in that much detail, and with this many features on the platform. The fact that they are single-minded and focused on CDC and ETL makes this such a rich solution. Other solutions cover these things a little bit in their multi-function products, but they don't go as deep."
"Equalum is real-time. If you are moving from an overnight process to a real-time process, there is always a difference in what reports and analytics show compared to what our operational system shows. Some of our organizations, especially finance, don't want those differences to be shown. Therefore, going to a real-time environment makes the data in one place match the data in another place. Data accuracy is almost instantaneous with this tool."
"I found two features in Equalum that I consider the most valuable. One is that Equalum is a no-code tool. You can do your activities on its graphical interface, which doesn't require complex knowledge of extracting, changing, or loading data. Another feature of Equalum that I like the most is that it monitors the data transfers and tells you if there's any issue so that you can quickly check and correct it. Equalum also tells you where the problem lies, for example, if it's a hardware or communication issue."
"Pentaho Data Integration is easy to use, especially when transforming data."
"The solution has a free to use community version."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"I find the drag and drop feature in Pentaho Data Integration very useful for integration."
"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 is easy to use, install, and start working with."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"This solution allows us to create pipelines using a minimal amount of custom coding."
 

Cons

"Their UI could use some work. Also, they could make it just a little faster to get around their user interface. It could be a bit more intuitive with things like keyboard shortcuts."
"I should be able to see only my project versus somebody else's garbage. That is something that would be good in future. Right now, the security is by tenants, but I would like to have it by project, e.g., this project has this source and flows in these streams, and I have access to this on this site."
"There is not enough proven integration with other vendors. That is what needs to be worked on. Equalum hasn't tested anything between vendors, which worries our clients. We need more proven vendor integration. It is an expensive product and it needs to support a multi-vendor approach."
"Right now, they have a good notification system, but it is in bulk. For example, if I have five projects running and I put a notification, the notification comes back to me for all five projects. I would like the notification to come back only for one project."
"They need to expand their capabilities in some of the targets, as well as source connectors, and native connectors for a number of large data sources and databases. That's a huge challenge for every company in this area, not just Equalum."
"The deployment of their flows needs improvement. It doesn't work with a typical Git branching and CI/CD deployment strategy."
"If you need to use the basic features of Equalum, for example, you don't even need data integration, then many competitors in the market can give you basic features. For instance, if you need batch ETL, you can pick among solutions in the market that have been around longer than Equalum. What needs improvement in Equalum is replication, as it could be faster. Equalum also needs better integration with specific databases such as Oracle and Microsoft SQL Server."
"I experience difficulties when handling millions of rows, as the data movement from one source to another becomes challenging."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
"I would like to see more improvements with AS400 DB2."
"​I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support.​"
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
 

Pricing and Cost Advice

"Equalum licensing costs vary, but I won't be able to give information on its fees."
"Equalum is rather expensive compared to its competitors. So, you have to make up that cost in time savings, and we usually do that. If we are saving money, it is because we are reducing our development time."
"Equalum was reasonably priced. It is not like those million dollar tools, such as Informatica."
"As soon as you have more than six users, Equalum is lower in cost [than Talend] and if the group gets bigger, it's quite a big delta. If more users want to use it, you don't end up with an increase in licensing costs, so that makes it very easy. And if you need more licenses or more sources, it's a very simple upgrade methodology."
"They have a very simple approach to licensing. They don't get tied up with different types of connectivity to different databases. If you need more connectors or if you need more CPU, you just add on. It's component-based pricing."
"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."
"The solution reduced our ETL development time by a lot because a whole project used to take about a month to get done previously. After having Lumada, it took just a week. For a big company in Brazil, it saves a team at least $10,000 a month."
"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."
"There is a good open source option (Community Edition)​."
"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
"I believe the pricing of the solution is more affordable than the competitors"
"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."
"I primarily work on the Community Version, which is available to use free of charge."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
850,028 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
18%
Computer Software Company
16%
Financial Services Firm
13%
Healthcare Company
10%
Financial Services Firm
22%
Computer Software Company
15%
Government
8%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why should I use Equalum instead of LogMiner?
You'd want to use the Equalium Oracle Binary Log Parser because it's just better than the LogMiner. Sure, LogMiner is made by Oracle and probably the team knows some insight to make it efficient th...
Is Equalum compatible with all databases?
I'm using Equalum's data replication software for Oracle because that's the one database it's designed for. While it may sound limiting, when you find out how many solutions it can provide for you ...
Can I use Equalum for free?
No, it's not free but you can benefit from a free trial, though. There's an option to try their platform for a limited amount of time, so that may be useful to help you decide if you want to contin...
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

No data available
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

SIEMENS, GSK, Wal-Mart, T Systems
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Equalum vs. Pentaho Data Integration and Analytics and other solutions. Updated: April 2025.
850,028 professionals have used our research since 2012.