We changed our name from IT Central Station: Here's why

AWS Glue vs Oracle Data Integrator (ODI) comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about MuleSoft, Informatica, Amazon and others in Cloud Data Integration. Updated: January 2022.
564,729 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.""One of the best features of the solution is its ability to easily integrate with other AWS services.""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.""The facility to integrate with S3 and the possibility to use Jupyter Notebook inside the pipeline are the most valuable features.""Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs."

More AWS Glue Pros →

"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 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.""The scalability is great. It's one of the reasons we chose the solution."

More Oracle Data Integrator (ODI) Pros →

Cons
"There is a learning curve to this tool.""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.""Overall, I consider the technical support to be fine, although the response time could be faster in certain cases.""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.""The crucial problem with AWS Glue is that it only works with AWS. It is not an agnostic tool like Pentaho. In PowerCenter, we can install the forms from Google and other vendors, but in the case of AWS Glue, we can only use AWS."

More AWS Glue Cons →

"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects.""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."
  • "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."
  • "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."
  • More AWS Glue Pricing and Cost Advice →

  • "The solution is expensive because of the model they use. The cost is for the license and for support."
  • 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.
    564,729 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: 
    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… more »
    Top Answer: 
    Glue is a NoSQL-based data ETL tool that has some advantages over IIS and ISAs.
    Top Answer: 
    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 come… more »
    Top Answer: 
    What is the OLAP that you are using? Hosted in Cloud or on-premise?  The target DB should have its tool to extract data.
    Top Answer: 
    I know I'm late to the party but here are my comments to this. I would ask what version of ODI are you running, but for the most part it doesn't matter. I will say that since you are saying Mapping… more »
    Ranking
    3rd
    Views
    11,139
    Comparisons
    9,445
    Reviews
    5
    Average Words per Review
    606
    Rating
    8.0
    5th
    Views
    20,934
    Comparisons
    14,507
    Reviews
    6
    Average Words per Review
    778
    Rating
    8.7
    Comparisons
    Also Known As
    ODI
    Learn More
    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, workday
    Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University
    Top Industries
    VISITORS READING REVIEWS
    Computer Software Company27%
    Media Company14%
    Comms Service Provider11%
    Financial Services Firm8%
    REVIEWERS
    Financial Services Firm32%
    Retailer9%
    University9%
    Hospitality Company9%
    VISITORS READING REVIEWS
    Computer Software Company39%
    Comms Service Provider16%
    Financial Services Firm8%
    Government5%
    Company Size
    No Data Available
    REVIEWERS
    Small Business31%
    Midsize Enterprise15%
    Large Enterprise54%
    Find out what your peers are saying about MuleSoft, Informatica, Amazon and others in Cloud Data Integration. Updated: January 2022.
    564,729 professionals have used our research since 2012.

    AWS Glue is ranked 3rd in Cloud Data Integration with 5 reviews while Oracle Data Integrator (ODI) is ranked 5th in Data Integration Tools with 6 reviews. AWS Glue is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.6. The top reviewer of AWS Glue writes "Easy to perform ETL on multiple data sources, and easy to use after you learn it". 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, AWS Database Migration Service, Informatica PowerCenter, IBM InfoSphere DataStage and Confluent, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Oracle GoldenGate and SAP Data Services.

    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.