No more typing reviews! Try our Samantha, our new voice AI agent.

HiT Software DBMoto 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:
 

Categories and Ranking

HiT Software DBMoto
Average Rating
9.0
Reviews Sentiment
7.6
Number of Reviews
2
Ranking in other categories
Data Replication (17th)
Pentaho Data Integration an...
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
61
Ranking in other categories
Data Integration (8th)
 

Mindshare comparison

HiT Software DBMoto and Pentaho Data Integration and Analytics aren’t in the same category and serve different purposes. HiT Software DBMoto is designed for Data Replication and holds a mindshare of 3.3%, up 1.2% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.7% mindshare, down 1.7% since last year.
Data Replication Mindshare Distribution
ProductMindshare (%)
HiT Software DBMoto3.3%
NetApp SnapMirror7.2%
Vision Solutions Double-Take5.9%
Other83.6%
Data Replication
Data Integration Mindshare Distribution
ProductMindshare (%)
Pentaho Data Integration and Analytics1.7%
Informatica Intelligent Data Management Cloud (IDMC)3.7%
SSIS3.6%
Other91.0%
Data Integration
 

Featured Reviews

reviewer1489908 - PeerSpot reviewer
Systems Engineer at a tech services company with 11-50 employees
User-friendly, easy to manage, with good support
We use HiT Software DBMoto for migration and reporting The most valuable features are that is easy to install and it is user-friendly. Pricing is an area that needs improvement. We started to use this product a year ago. It's a stable solution. We have not experienced any issues. It's a…
Michelle Lawson - PeerSpot reviewer
Principal Software Engineer at a tech vendor with 10,001+ employees
Streamlines complex data workflows and has supported automated customer payment notifications
I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

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 good product that is user-friendly and easy to manage, and I would recommend it to others."
"DBMoto was very simple to set up and move our tables to the Oracle DB."
"The most valuable features are that is easy to install and it is user-friendly."
"Using the solution we were able to reduce our ETL deployment time by between 10 and 20 percent, and when it comes to personnel costs, we have gained 10 percent."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"Easy to use, support for all databases (jdbc and odbc connection), xls, csv, files, txt, SAS, R."
"I would say this is the best ETL tool in the market, considering this is open source and ease to use, very nice GUI."
"The amount of data that it loads and processes is good."
"Since we started using Pentaho Data Integration and Analytics, many of our manual tasks have become automatic, and we have increased our time for productive things."
"We have been able to expose data services through the use of CDA relying on the same database as the reporting tools, thus avoiding inconsistencies among the data shown by reports and data acquired by external systems."
"I love the fact that we haven't come up with a problem yet that we haven't been able to address with this tool."
 

Cons

"Pricing is an area that needs improvement."
"This product would be improved with additional built-in functions for simpler date conversion, as well as for data type transformations."
"They could improve the logging generator. Sometimes the error description is so generic that it is not possible to detect the problem."
"The technical support does not reply in a timely manner. The support they have in place does not work very well."
"To improve Pentaho Data Integration and Analytics, I suggest developing capabilities for cloud-based solutions instead of being solely on-premises."
"While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"Some old plugins, after a long time, still doesn’t work properly enough."
"Stability is a bit of an issue. The GUI quite often ‘freezes’ and there is no alternative to killing the session."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
 

Pricing and Cost Advice

"I found the price to be quite reasonable."
"Customers pay a license fee yearly."
"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."
"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."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."
"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."
"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."
"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."
"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 Replication solutions are best for your needs.
900,747 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
16%
Educational Organization
8%
Construction Company
8%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business18
Midsize Enterprise17
Large Enterprise32
 

Questions from the Community

Ask a question
Earn 20 points
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

DBMoto
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

JAS Forwarding Worldwide, Animal, Financiera Pagos Internacionales C.F., Bur de Credito, Qualitas-IT, EFCO Corporation, Andrews Consulting, ASL Modena, BancAssurance Popolari S.p.A., Banco BICSA, Cheshire County Council, Epson Precision, Ferrari North America
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication. Updated: June 2026.
900,747 professionals have used our research since 2012.