AWS Glue vs Oracle Data Integrator (ODI) comparison

Amazon Web Services (AWS) and Oracle are both solutions in the Cloud Data Integration category. Additionally, 91% 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 47 AWS Glue reviews

9,044 Views
6,563 Comparison Views

91% willing to recommend

Oracle Data Integrator (ODI)

Read 70 Oracle Data Integrator (ODI) reviews

9,925 Views
6,074 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 831,158 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 (6th)

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

"It's fairly straightforward as a product; it's not very complicated."

"I also like that you can add custom libraries like JAR files and use them. So, the ability to use a fast processing engine and embed basic jobs easily are significant advantages."

"Its user interface is quite good. You just need to choose some options to create a job in AWS Glue. The code-generation feature is also useful. If you don't want to customize it and simply want to read a file and store the data in the database, it can generate the code for you."

"AWS Glue is a good solution for developers, they have the ability to write code in different languages and other software."

"I like its integration and ability to handle all data-related tasks."

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

"The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features."

"The solution is serverless so it allows us to transform data while optimizing the cost and performance of Spark jobs."

More AWS Glue pros

"Oracle provides great documentation."

"It is an ETL tool, which does the extract, transform, and load."

"It effectively manages errors through its logging and exception-handling capabilities."

"Besides loading data, we do most of our transformations in ODI."

"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."

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

"The most valuable feature is Data movement."

"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."

More Oracle Data Integrator (ODI) pros

Cons

"There could be an enhanced way of managing pure metadata management or data cataloging."

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

"While working on AWS Glue, I could not find any training material for it."

"One area that could be improved is the ETL view. The drag-and-drop interface is not as user-friendly as some other ETL tools."

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

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

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

"If there's a cluster-related configuration, we have to make worker notes, which is quite a headache when processing a large amount of data."

More AWS Glue cons

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

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

"ODI could improve the ease of use. There is a steep learning curve to use the solution."

"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."

"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."

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

"It needs easier security."

More Oracle Data Integrator (ODI) cons

Pricing and Cost Advice

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

"If you are using the solution for an enterprise business, it will be expensive."

"AWS Glue uses a pay-as-you-go approach which is helpful. The price of the overall solution is low and is a great advantage."

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

"I would rate the solution a six or seven on a scale of one to ten, with ten being very expensive. Specifically, I rate its pricing a six out of ten."

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

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

"It is not expensive. AWS Glue works on the serverless architecture. We get charged for the time the server is up. For our use case, we have to use it once in a day, and it is not expensive for us."

More AWS Glue pricing and cost advice

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

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

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

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

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

"There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system."

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

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

831,158 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

16%

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 35% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs AWS Glue

Compared 7% of the time

Informatica PowerCenter vs AWS Glue

Compared 5% of the time

SSIS vs AWS Glue

Compared 5% of the time

IBM InfoSphere DataStage 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 9% of the time

Oracle GoldenGate vs Oracle Data Integrator (ODI)

Compared 4% of the time

More Oracle Data Integrator (ODI) Competitors

Product Reports

Buyer's Guide

AWS Glue

January 2025

Download AWS Glue product report

Buyer's Guide

Oracle Data Integrator (ODI)

January 2025

Download Oracle Data Integrator (ODI) product report

Also Known As

No data available

ODI

Learn More

Amazon Web Services (AWS)

Oracle

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.

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

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

831,158 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.