AWS Glue vs Oracle Data Integrator (ODI) comparison

Amazon Web Services (AWS) and Oracle are both solutions in the Cloud Data Integration category. Additionally, 89% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 83% of Oracle users who would recommend it.

AWS Glue

Read 48 AWS Glue reviews

8,384 Views
6,222 Comparison Views

89% willing to recommend

Oracle Data Integrator (ODI)

Read 70 Oracle Data Integrator (ODI) reviews

9,313 Views
5,716 Comparison Views

83% willing to recommend

AWS Glue

Oracle Data Integrator (ODI)

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between AWS Glue and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed AWS Glue vs. Oracle Data Integrator (ODI) Report (Updated: January 2025).

Buyer's Guide

AWS Glue vs. Oracle Data Integrator (ODI)

January 2025

Download the complete report

Helped 838,713 peers since 2012

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 Glue

Average Rating

7.8

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Cloud Data Integration (1st)

Oracle Data Integrator (ODI)

Average Rating

8.2

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (7th)

Featured Reviews

Muthuvel Sivaraman

AVP at a manufacturing company with 10,001+ employees

Handles a huge volume of data and is serverless, but it can be considered costly by some users

We use Amazon's services to provide technical support for the product. If you want to have support, Oracle and others offer a single support, and other tools have a direct support window. For Amazon, we need to pay 10 percent of my billing amount for the tool to get support services. Whether to raise a support ticket or not is an issue since ten percent is a huge amount. My company ends up using all the options without help from support. It is very difficult for any common man to understand why there is a need to pay ten percent for support. If I find an issue in the product, and I need to get support from AWS to fix it, then I need to pay ten percent of the tool's bill amount to Amazon. AWS is a very tricky tool because everything is evolving nowadays. AWS engineers are getting hired from other places, and even after that, if I am not getting any technical support, then things will be very nasty. There are some good engineers who help users outside the normal support cycle, but it doesn't meet their needs. I rate the technical support a four out of ten.

Read full review

Jagadish Sau

Technical lead at a transportation company with 10,001+ employees

Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved

My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution. The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI). My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use. My rating for Oracle Data Integrator (ODI) is seven out of ten.

Read full review

Quotes from Members

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

Pros

"I appreciate AWS Glue for its cost-effectiveness."

"If I'm working with big data, common languages like Python work quite nicely, which is advantageous."

"The solution is stable and reliable."

"Transformations are valuable because you can modify or override complex data logic from an open source or Spark to solve issues."

"Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs."

"AWS Glue is very quick to start without cold starts, unlike AWS Lambda."

"The AWS Glue Data Catalog provides metadata management and schema discovery. AWS Glue simplifies data transformation with automatic schema detection, incremental data updates, and integration with other AWS services."

"It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly."

More AWS Glue pros

"It's completely user-friendly."

"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 initial setup is easy."

"ODI's most valuable features are it utilizes the database engine and is very lightweight."

"It's scalable."

"Oracle Data Integrator offers a very good development environment and supports the use of multiple programming languages, including Python. It runs scenarios effectively, even when executing complex, long SQL scripts that are not runnable on other clients."

"The most valuable feature is Data movement."

"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."

More Oracle Data Integrator (ODI) pros

Cons

"I have encountered challenges with multi-region support."

"It is very difficult to learn the tool and remember the syntaxes comparatively."

"Cost-wise, AWS Glue is expensive, so that's an area for improvement. The process for setting up the solution was also complex, which is another area for improvement."

"I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features."

"The drawbacks associated with the product stem from the fact that, based on the data volume, it can become very costly."

"Only people who can code, either in Java or Python, can use the product freely. Those who don't know Java or Python might find using AWS Glue difficult."

"Beginners need additional support as it currently lacks some features required for complex transformations, often necessitating custom Python coding."

"In terms of improvement, the performance of AWS Glue could be faster."

More AWS Glue cons

"Reverse engineering is complicated and challenging to manage."

"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."

"Oracle support services are not up to the mark."

"I would only point out some minor bugs or glitches in the development interface (ODI studio)."

"Technical Support could be better."

"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."

"The stability of the software could be improved. Sometimes, the software just crashes. "

"We used a third party to do the implementation of ODI."

More Oracle Data Integrator (ODI) cons

Pricing and Cost Advice

"The pricing is a bit higher than other solutions like Athena and EC2. If the pricing becomes more scaled or flexible, it will be good because you have to pay 44 cents just for one DPU for an hour. If you increase DPUs to 5 or 10, the pricing gets multiplied. There are also some time limits like 0 to 10 minutes or 10 to 20 minutes. If the pricing is according to the minutes, it would be better because you have to limit your job to 10 minutes or 20 minutes."

"The overall cost of AWS Glue could be better. It cost approximately $1,000 a month. There is paid support available from AWS Glue."

"Its price is good. We pay as we go or based on the usage, which is a good thing for us because it is simple to forecast for the tool. It is good in terms of the financial planning of the company, and it is a good way to estimate the cost. It is also simple for our clients. In my opinion, it is one of the best tools in the market for ETL processes because of the fact that you pay as you use, which separates it from other big tools such as PowerCenter, Pentaho Data Integration, and Talend."

"It is an expensive product. I rate its pricing a nine out of ten."

"Technical support is a paid service, and which subscription you have is dependent on that. You must pay one of them, and it ranges from $15,000 to $25,000 per year."

"AWS Glue is a high-priced solution that bills the client $150,000 to $250,000 annually."

"I rate pricing an eight out of ten."

"I rate the tool an eight on a scale of one to ten, where one is expensive, and ten is expensive."

More AWS Glue pricing and cost advice

"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."

"I have yet to determine the exact figure for Oracle Data Integrator (ODI) pricing, but it has lower pricing than Informatica."

"The license can be costly, but in certain complex cases, ODI proves to be the optimal solution."

"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."

"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."

"We found that the cost compared to other integration tools is a little high, but the solution works great."

"ODI comes included when buying the cloud version of the Oracle database license."

"The solution is very expensive."

More Oracle Data Integrator (ODI) pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

838,713 professionals have used our research since 2012.

Comparison Review

it_user99375

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…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

13%

Manufacturing Company

Insurance Company

Financial Services Firm

17%

Computer Software Company

13%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

See all answers

How does Talend Open Studio compare with AWS Glue?

We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...

See all answers

What are the most common use cases for AWS Glue?

AWS Glue's main use case is for allowing users to discover, prepare, move, and integrate data from multiple sources. The product lets you use this data for analytics, application development, or ma...

See all answers

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...

See all answers

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...

See all answers

What is your experience regarding pricing and costs for Oracle Data Integrator (ODI)?

The pricing of Oracle Cloud Services is not favorable as it charges daily regardless of usage, unlike competitors who charge only for days used.

See all answers

Comparisons

AWS Database Migration Service vs AWS Glue

Compared 36% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs AWS Glue

Compared 6% of the time

SSIS vs AWS Glue

Compared 5% of the time

SnapLogic vs AWS Glue

Compared 5% of the time

Matillion ETL vs AWS Glue

Compared 3% of the time

More AWS Glue Competitors

Oracle Integration Cloud Service vs Oracle Data Integrator (ODI)

Compared 17% of the time

Informatica PowerCenter vs Oracle Data Integrator (ODI)

Compared 14% of the time

SSIS vs Oracle Data Integrator (ODI)

Compared 11% of the time

Azure Data Factory vs Oracle Data Integrator (ODI)

Compared 10% of the time

Pentaho Data Integration and Analytics vs Oracle Data Integrator (ODI)

Compared 4% of the time

More Oracle Data Integrator (ODI) Competitors

Product Reports

Buyer's Guide

AWS Glue

February 2025

Download AWS Glue product report

Buyer's Guide

Oracle Data Integrator (ODI)

February 2025

Download Oracle Data Integrator (ODI) product report

Also Known As

No data available

ODI

Overview

AWS Glue is a serverless cloud data integration tool that facilitates the discovery, preparation, movement, and integration of data from multiple sources for machine learning (ML), analytics, and application development. The solution includes additional productivity and data ops tooling for running jobs, implementing business workflows, and authoring.

AWS Glue allows users to connect to more than 70 diverse data sources and manage data in a centralized data catalog. The solution facilitates visual creation, running, and monitoring of extract, transform, and load (ETL) pipelines to load data into users' data lakes. This Amazon product seamlessly integrates with other native applications of the brand and allows users to search and query cataloged data using Amazon EMR, Amazon Athena, and Amazon Redshift Spectrum.

The solution also utilizes application programming interface (API) operations to transform users' data, create runtime logs, store job logic, and create notifications for monitoring job runs. The console of AWS Glue connects all of these services into a managed application, facilitating the monitoring and operational processes. The solution also performs provisioning and management of the resources required to run users' workloads in order to minimize manual work time for organizations.

AWS Glue Features

AWS Glue groups its features into four categories - discover, prepare, integrate, and transform. Within those groups are the following features:

Automatic schema discovery: AWS Glue crawlers connect to the organization's source or target data source through a prioritized list of classifiers to determine the schema for users' data. This feature creates metadata in companies' AWS Glue Data Catalog.
Schemas for data stream management: The AWS Glue Schema Registry enables users to validate and control the evolution of streaming data through registered Apache Avro schemas for no additional charge.
Automatic scaling based on workload: This feature dynamically scales resources up and down based on workload. The feature controls job resources, removing them depending on how much the workload can be split up.
FindMatches: This feature is for machine learning-based data deduplication and cleansing, and works by finding records that are imperfect matches of each other to remove useless data copies.
Edit, debug, and test ETL code: This feature helps users who have chosen to interactively develop their ETL code by providing development endpoints for editing, debugging, and testing the code it generates for them.
AWS Glue DataBrew: An interactive, point-and-click visual interface for specialists to clean and normalize data without the need to write any code.
AWS Glue Interactive Sessions: This feature simplifies the development of data integration jobs by enabling data engineers to interactively prepare and explore data.
AWS Glue Studio Job Notebooks: This AWS Glue feature provides serverless notebooks with minimal setup, allowing developers to start working in a timely manner.
Complex ETL pipeline building: This feature allows the product to be invoked on a schedule, on demand, or based on an event, allowing users to start multiple jobs in parallel or specify dependencies to build complex ETL pipelines.
AWS Glue Studio: This AWS Glue feature allows users to visually transform data through a drag-and-drop interface. The product automatically generates the code for ETL processes for users' data.

AWS Glue Benefits

AWS Glue offers a wide range of benefits for its users. These benefits include:

Users of other AWS products can easily onboard with AWS Glue, as it is integrated across a wide range of the company's services.
The solution is serverless, which allows for a lower total cost of ownership.
AWS Glue offers more power for users, as it automates much of the effort in building, maintaining, and running ETL jobs.
The product allows customers to easily discover and search across all their AWS datasets through AWS Glue Data Catalog.
AWS Glue does not require additional payment for managing and enforcing schemas for data streams.
The solution facilitates the authority of scalable ETL jobs for beginners and non-coding experts through a drag-and-drop interface.

Reviews from Real Users

Mustapha A., a cloud data engineer at Jems Groupe, likes AWS Glue because it is a product that is great for serverless data transformations.

Liana I., CEO at Quark Technologies SRL, describes AWS Glue as a highly scalable, reliable, and beneficial pay-as-you-go pricing model.

Amazon Web Services (AWS)

Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.

Oracle Data Integrator Features

ODI has many valuable key features. Some of the most useful ones include:

Automatic documentation generation
Visualization of data flows in the interfaces
Customization of generated code
Automatic reverse-engineering of existing applications or databases
Graphical development and maintenance of transformation and integration interfaces
Robust data integrity control features, assuring the consistency and correctness of data
Powerful core differentiators
Heterogeneous ELT, declarative design and knowledge modules
Flexibility and modularity
Oracle Data Integrator repository
Topology navigator
Operator Navigator
Security Navigator
Integrator Console
ODI domains

Oracle Data Integrator Benefits

There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:

Efficient architecture: Oracle Data Integrator has a simple architecture that utilizes the source and target servers to perform complex transformations, making it an efficient solution.

Supports all platforms: ODI gives you platform independence by supporting all platforms, hardware, and OSes with the same software.

Cost-effective: Oracle Data Integrator reduces costs associated with initial hardware and software acquisition, and also decreases maintenance costs because it eliminates the need for an ETL Server and an ETL engine.

Automatic detection of faulty data: By using ODI, faulty data is recycled before insertion in the target application, providing you with a data quality firewall.

Easy development and maintenance: With a low learning curve, Oracle Data Integrator increases developer productivity while facilitating ongoing maintenance.

Active integration: ODI includes all styles of data integration: data-based, event-based and service-based.

Reviews from Real Users

Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.

Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”

Ashok S., Applications Support Manager at a marketing services firm, mentions, "The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."

Oracle

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University

Buyer's Guide

AWS Glue vs. Oracle Data Integrator (ODI)

January 2025

Free Report: AWS Glue vs. Oracle Data Integrator (ODI)

Find out what your peers are saying about AWS Glue vs. Oracle Data Integrator (ODI) and other solutions. Updated: January 2025.

DOWNLOAD NOW

838,713 professionals have used our research since 2012.

See our AWS Glue vs. Oracle Data Integrator (ODI) report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.