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

AWS Database Migration Service 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

AWS Database Migration Service
Average Rating
8.0
Reviews Sentiment
6.4
Number of Reviews
34
Ranking in other categories
Cloud Data Integration (2nd)
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

Avinash Gangu - PeerSpot reviewer
Centralizing database tables enhances workflow efficiency for ease of use
I was looking for some content as part of a comparison analysis. However, one of the pain points is that it is way too free-flowing. I have to skim through all the security pages to get to the crux of it. I was looking for a table that suggests which facets such services address with proofs of reference from professional conferences. The document is a 63-page read, making it very difficult to navigate without a summary. I was looking for a summary at the start, however, if I have to do it myself, I might as well integrate from AWS Docs and then Informative Exchange. The current document contains a lot of information, which is great, but there needs to be a summary indicating the story's essence. Unless there's a correction, it is not present in the document.
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…

Quotes from Members

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

Pros

"I am very impressed by the scalability of AWS Database Migration Service."
"If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"The solution is stable and reliable."
"The product's initial setup phase was very easy."
"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"This solution is very good at mini-batch processing."
"This solution allows us to create pipelines using a minimal amount of custom coding."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"It's my understanding that the product can scale."
"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."
"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."
"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."
"It has improved our data integration capabilities​."
"Data transformation within Pentaho is a nice feature that they have and that I value."
 

Cons

"One area that AWS DMS can improve on is its conversion of data types. For example, in Oracle, you have a data type called RAW, but in PostgreSQL there is no such thing. Thus, AWS DMS doesn't know what type I want to use when migrating from Oracle to PostgreSQL, and when performing the migration, AWS DMS changed the RAW data type to the byte data type, which isn't what I wanted."
"Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading."
"I was looking for a table that suggests which facets such services address with proofs of reference from professional conferences."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"This solution is compatible with only AWS."
"I think that Amazon needs to improve the migration scenarios after analytics"
"What needs improvement in AWS Database Migration Service is that it lacks a log file validation feature. If the solution could provide more details about a particular transaction, that would be helpful. The stability of AWS Database Migration Service for online CDC records also needs to be improved."
"Improvements could be made in AWS Database Migration Service. Because of that, I am moving out of DMS now to a STRIIM solution."
"Should provide additional control for the data warehouse"
"​I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse​."
"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."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"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."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."
"Larger data jobs take more time to execute."
 

Pricing and Cost Advice

"Pricing can be improved."
"Cost is the only factor that is challenging."
"I would rate the pricing a seven out of ten."
"The solution’s pricing is reasonable."
"The pricing can be better and it should be more competitive."
"AWS Database Migration Service is the least expensive solution, but is still expensive."
"In terms of pricing, I'd rate it an eight out of ten, considering it's a well-priced solution."
"The pricing is on the higher side."
"There is a good open source option (Community Edition)​."
"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."
"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"
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"You don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."
"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."
"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."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
861,481 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
16%
Manufacturing Company
7%
Insurance Company
6%
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 resources can you use to learn how to utilize AWS Database Migration Service?
As with all AWS products, you are given very useful documentation with AWS Database Migration Service. Before we started using this product, we went over it and we were able to learn the basics an...
Would you recommend AWS Database Migration Service as a cloud data integration tool?
My current company started using AWS Database Migration Service upon my recommendation, and I continue telling people how good of a product it is. However, users should keep in mind a few things. ...
Is AWS Database Migration Service an affordable solution?
Compared to similar solutions, AWS Database Migration Service falls somewhere in the middle price-wise, at least from my experience. This being said, it is not a very affordable solution, especial...
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

AWS Data Migration Service
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

Veoci, Trimble, Nasdaq, shaadi.com, Hotelbeds, SysAid, Verizon, Expedia, Pega
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about AWS Database Migration Service vs. Pentaho Data Integration and Analytics and other solutions. Updated: July 2025.
861,481 professionals have used our research since 2012.