Compare AWS Glue vs. Oracle Data Integrator (ODI)

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use AWS Glue? Share your opinion.
Find out what your peers are saying about Seeburger, MuleSoft, Matillion and others in Cloud Data Integration. Updated: November 2020.
447,439 professionals have used our research since 2012.
Quotes From Members

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

Pros
"Data catalog and triggers are the two best features for me. AWS Glue has its own data catalog, which makes it great and really easy to use. Triggers are also really good for scheduling the ETL process.""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."

More AWS Glue Pros »

"​All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration.""It's completely user-friendly.""The most valuable feature that we use is the Knowledge Modules.""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.""The scalability is great. It's one of the reasons we chose the solution."

More Oracle Data Integrator (ODI) Pros »

Cons
"The start-up time is really high right now. For instance, when you start up a new job, you have to wait for five or eight minutes before it starts. If the start-up time is reduced to one or two minutes, it will be great. It will be better to have a direct linkage to Redshift in AWS. If we can use data catalogs from Redshift, it will be so easy to create some data catalogs. Currently, we can only use data catalogs from S3.""Currently, it supports only two languages in the background: Python and Scala. From our customization point of view, it would be helpful if it can also support Java in the background."

More AWS Glue Cons »

"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons""Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts.""The performance of the user interface is in need of improvement.""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.""The resource management aspect of the solution could be improved."

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

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

More Oracle Data Integrator (ODI) Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
447,439 professionals have used our research since 2012.
Questions from the Community
Top Answer: AWS Glue and Azure Data factory for ELT best performance cloud services.
Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution. The other question is how up to date do you want your… more »
Top Answer: But I never had been a specialist in ODI since we focussed on OWB and possible DevOps enhancements, But together with IKAN we worked on migration projects from OWB to ODI with Databtech (i.e Angelo… more »
Ranking
9th
Views
2,296
Comparisons
2,137
Reviews
2
Average Words per Review
482
Avg. Rating
8.0
4th
Views
20,957
Comparisons
13,562
Reviews
10
Average Words per Review
512
Avg. Rating
8.5
Popular Comparisons
Compared 24% of the time.
Compared 16% of the time.
Compared 11% of the time.
Compared 5% of the time.
Compared 15% of the time.
Also Known As
ODI
Learn
Amazon
Oracle
Overview

AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics. You can create and run an ETL job with a few clicks in the AWS Management Console. You simply point AWS Glue to your data stored on AWS, and AWS Glue discovers your data and stores the associated metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once cataloged, your data is immediately searchable, queryable, and available for ETL.

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Offer
Learn more about AWS Glue
Learn more about Oracle Data Integrator (ODI)
Sample Customers
bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workdayGriffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
Top Industries
VISITORS READING REVIEWS
Computer Software Company33%
Media Company17%
Comms Service Provider10%
Financial Services Firm7%
REVIEWERS
Financial Services Firm33%
Retailer10%
University10%
Hospitality Company10%
VISITORS READING REVIEWS
Computer Software Company49%
Comms Service Provider13%
Retailer5%
Financial Services Firm4%
Company Size
No Data Available
REVIEWERS
Small Business33%
Midsize Enterprise13%
Large Enterprise54%
Find out what your peers are saying about Seeburger, MuleSoft, Matillion and others in Cloud Data Integration. Updated: November 2020.
447,439 professionals have used our research since 2012.
AWS Glue is ranked 9th in Cloud Data Integration with 2 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration Tools with 9 reviews. AWS Glue is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.6. The top reviewer of AWS Glue writes "It can generate the code and has a good user interface, but it lacks Java support". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". AWS Glue is most compared with Talend Open Studio, Informatica PowerCenter, SSIS, IBM InfoSphere DataStage and Matillion ETL, whereas Oracle Data Integrator (ODI) is most compared with Informatica PowerCenter, Oracle Integration Cloud Service, SSIS, Oracle GoldenGate and Talend Data Management Platform.

See our list of .

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.