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

AWS Database Migration Service vs Oracle Data Integrator (ODI) 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
4.5
Organizations save up to $150,000 annually using AWS Database Migration Service, offering significant cost savings over legacy tools.
Sentiment score
7.6
Oracle Data Integrator provides high ROI, reducing custom ETL efforts and costs, with Cloud version enhancing implementation and efficiency.
 

Customer Service

Sentiment score
5.3
AWS Database Migration Service support is inconsistent, with helpful expertise but often involves delays, budget considerations, or repeated exchanges.
Sentiment score
5.9
ODI support gets mixed reviews; quick solo responses but struggles in multi-product setups, often leading users to forums.
I am happy with the technical support from AWS.
When working with AWS GovCloud, we often did not get an answer in time because AWS seemed more focused on the commercial side.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
 

Scalability Issues

Sentiment score
6.8
AWS Database Migration Service is scalable and adaptable, but may face compatibility and latency issues with large data sets.
Sentiment score
7.6
Oracle Data Integrator scales well, integrating with WebLogic, while configuration and setup impact its performance in various environments.
Even if there was a failure, we could catch it and rerun it.
While scalability is good, latency exists due to our business nature.
AWS's scalable nature involves a human approach, meaning it is not auto-scalable.
 

Stability Issues

Sentiment score
7.2
AWS Database Migration Service is reliable and stable, with occasional manual interventions needed for large data volumes or constant migrations.
Sentiment score
7.3
Oracle Data Integrator is stable and efficient, with minor configuration challenges resolved in newer versions like 12.1.3 and 12cR2.
For DMS version upgrades, we schedule downtime during business hours so that midnight workloads are not interrupted and morning business can run smoothly.
 

Room For Improvement

AWS Database Migration Service needs improved functionality, compatibility, monitoring, and documentation to enhance user experience and platform support.
ODI users seek improved performance, usability, integration, and cost-efficiency, with better error handling, authentication, and automation features.
DMS works within AWS ecosystem, but they also have to look for third party solutions. Now Snowflake is a bigger player, or Databricks.
Sometimes, those who implement the service face problems and resolve it, but I may not even know what problems they faced.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
 

Setup Cost

AWS Database Migration Service is cost-effective long-term, with pricing varying by usage, migration complexity, and regional differences.
Oracle Data Integrator has complex, costly pricing with various licensing options; discounts and packages can reduce expenses for enterprises.
 

Valuable Features

AWS Database Migration Service offers scalable, cost-effective migration with easy administration, real-time synchronization, and high data security.
Oracle Data Integrator features flexible, customizable integration with diverse technologies, enhancing performance and efficiency in data integration tasks.
The scalability option is another valuable feature because AWS provides its own compute behind it, so I can scale up and scale down at any given point.
You can copy the database at first without impacting your current database, and then use CDC to copy incremental changes.
AWS offers a way to build jobs that are scalable, expandable for new and current tables, and can be deployed quickly.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
 

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)
Oracle Data Integrator (ODI)
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
71
Ranking in other categories
Data Integration (7th)
 

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.
Jozsef Gazsik - PeerSpot reviewer
Offers a very good development environment and supports the use of multiple programming languages
We are using a graphical tool called PowerDesigner to create logical and physical models. From that, we create code that can be run by Oracle Data Integrator, which then maps the data based on these models and sends it to its destination. It is currently very integrated with Oracle The Oracle…
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
862,514 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Mar 31, 2014
Oracle GoldenGate vs. Oracle Active Dataguard
As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
16%
Manufacturing Company
7%
Insurance Company
6%
Financial Services Firm
18%
Computer Software Company
11%
Government
9%
Manufacturing Company
7%
 

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...
What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
Oracle Integration Cloud Service has a fairly easy initial setup, and Oracle offers initial support and guidance for those who might find the setup to be challenging. There are complications that c...
What do you like most about Oracle Data Integrator (ODI)?
In comparison with other products of the same range, licensing mode is really attractive, no need to license according technology/topology to be used and an incredible Versatility to build any Data...
What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?
If I use the whole Oracle system, it can be cost-effective. ODI is cheaper compared to Informatica PowerCenter ( /products/informatica-powercenter-reviews ) and IBM DataStage. However, for tools li...
 

Also Known As

AWS Data Migration Service
ODI
 

Overview

 

Sample Customers

Veoci, Trimble, Nasdaq, shaadi.com, Hotelbeds, SysAid, Verizon, Expedia, Pega
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about AWS Database Migration Service vs. Oracle Data Integrator (ODI) and other solutions. Updated: July 2025.
862,514 professionals have used our research since 2012.