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

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

Featured Reviews

Akil Saji - PeerSpot reviewer
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.
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…

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."
"AWS has made it easy for developers like me to create and manage GraphQL APIs."
"The scalability is great. It's one of the reasons we chose the solution."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"Besides loading data, we do most of our transformations in ODI."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
 

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."
"In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial."
"Technical Support could be better."
"The performance of the user interface is in need of improvement."
"The solution lacks some functions and features."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"There could be better compatibility with other ETL tools and cloud platforms."
"Oracle support services are not up to the mark."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
 

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."
"The Oracle Data Integrator (ODI) pricing isn't expensive, but it's not cheap, so it's in the middle. I'd rate the pricing as three out of five."
"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."
"The solution is expensive because of the model they use. The cost is for the license and for support."
"I rate the platform pricing as five out of ten."
"The solution is very expensive."
"ODI comes included when buying the cloud version of the Oracle database license."
"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
865,384 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
No data available
Financial Services Firm
17%
Government
9%
Computer Software Company
9%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for AWS AppSync?
We initially had limited knowledge about AWS costs. As beginners, we ran many instances for over a month. Consequently, we received a bill from Amazon for around $20, which was unexpected. This hig...
What needs improvement with AWS AppSync?
In AppSync, assigning roles and permissions to APIs is necessary for accessing other AWS services. Automating this task when creating APIs would be beneficial. Regular updates might soon address th...
What is your primary use case for AWS AppSync?
Our company handles in-house projects and serves clients globally. My role with AppSync involves creating GraphQL APIs. There are different types of APIs, such as REST API, GraphQL API, and WebSock...
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

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 AWS AppSync vs. Oracle Data Integrator (ODI) and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.