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

AWS AppSync 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:
 

Categories and Ranking

AWS AppSync
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
2
Ranking in other categories
Cloud Data Integration (25th)
Oracle Data Integrator (ODI)
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
73
Ranking in other categories
Data Integration (12th)
 

Featured Reviews

Akil Saji - PeerSpot reviewer
AWS Cloud Developer at Mobil80 Solutions and Services Pvt. Ltd.
Ease of creating APIs with ongoing updates needed for automation
AWS has made it easy for developers like me to create and manage GraphQL APIs. The ease of use is a main advantage, allowing even beginners to start from scratch and learn through AppSync. Before AWS, developing and managing APIs was quite complex. AWS provided AppSync, which assists developers and startup founders. Startups blooming everywhere benefit from this service, welcoming those who lack prior knowledge. When working on AWS, I notice that Amazon regularly implements new features. For instance, with the Lambda service, AWS is transitioning from an old editor to a new one. Similarly, AppSync frequently introduces updates and changes. This trend is making the user interface more accessible, even for individuals without a technical background. Additionally, the cost is attractive, as AWS operates on a pay-as-you-go basis. These factors make AppSync both easy to use and cost-effective.
Hafiz Mannan - PeerSpot reviewer
Head of Data Services – Services Partner at 3 As Technologies
Facilitates complex data integration with ease and flexibility
It would be great if ODI could link the designer, mapping, and workflows in a more simplified manner, maybe in one combined interface. It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame instead of having the designer separately, mapping separately, and monitoring and session management separately. With respect to data quality challenges, it would be great to give an option to fix data quality issues based on AI. Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent. One of the main disadvantages of the Oracle Data Integrator (ODI) is that it sometimes takes a lot of resources when handling multiple jobs. The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement, and certain parallel threads should be added along with the ability to configure multiple jobs from the same data directory structure.

Quotes from Members

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

Pros

"AWS has made it easy for developers like me to create and manage GraphQL APIs."
"Support for multiple data sources and formats is a fantastic feature."
"The ODI client can be configured so that Excel data can automatically be pumped into Oracle Forms directly."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click."
"Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"It allows a single skill set to handle virtually all of the data transport and transformation needs of a company."
"I love working with ODI because it tests your thought limits and creativity and the possibilities are endless when it comes to innovative tasks."
"ODI has made it possible for our organization to rapidly build robust integrations that process large data."
 

Cons

"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."
"Moving to other clouds is impossible without significantly rearchitecting your applications."
"Customer service 5/10 - Technical support needs to be improved."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"I encountered many problems with the ODI web agent (service that actually executes all the integration tasks) in the 11g version, which was not stable."
"The stability of the ODI studio is not strong enough. It crashes occasionally."
"Technical service is a 6, and Oracle needs to improve this."
"The solution lacks some functions and features."
"Customer Service: It could be better. Technical Support: It could be better."
"They need to work on the multiuser development environment and include the ability to comply with different kinds of SDLCs."
 

Pricing and Cost Advice

"Licensing fees are paid on a monthly basis, and it is a pay-as-you-go model."
"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."
"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."
"I rate the platform pricing as five out of ten."
"ODI comes included when buying the cloud version of the Oracle database license."
"Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset."
"Being an ODI developer, I never had to pay for this product. I know that the pricing/licensing is not really low, but the product is really good."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
"The solution is expensive because of the model they use. The cost is for the license and for support."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
909,725 professionals have used our research since 2012.
 

Comparison Review

it_user99375 - PeerSpot reviewer
Database Administrator at a tech services company with 51-200 employees
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
Comms Service Provider
21%
Manufacturing Company
14%
Healthcare Company
12%
Outsourcing Company
5%
Financial Services Firm
14%
Government
9%
Outsourcing Company
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business26
Midsize Enterprise12
Large Enterprise44
 

Questions from the Community

What is your experience regarding pricing and costs for AWS AppSync?
My experience with pricing, setup cost, and licensing was good and easy. About the pricing and setup cost, there is no major setup cost required for AWS AppSync, which is a really great thing becau...
What needs improvement with AWS AppSync?
The current features of AWS AppSync are enough for any developer, but it has some areas for improvement. AWS AppSync can provide first-class support for SQL RDS since writing SQL via VTL is clunky ...
What is your primary use case for AWS AppSync?
My main use case for AWS AppSync is to deploy the application by connecting my frontend and backend application. AWS AppSync serves as a GraphQL API Gateway that sits between my frontend and backen...
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...
 

Also Known As

AppSync
ODI
 

Overview

 

Sample Customers

ACBL, Puresec, IDT, ASU, Public Good, cookpad, ALDO, ticketmaster
Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Palantir and others in Cloud Data Integration. Updated: August 2026.
909,725 professionals have used our research since 2012.