AWS Glue vs Oracle Integration Cloud Service comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
11,616 views|8,101 comparisons
92% willing to recommend
Oracle Logo
3,249 views|2,125 comparisons
86% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between AWS Glue and Oracle Integration Cloud Service based on real PeerSpot user reviews.

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration.
To learn more, read our detailed Cloud Data Integration Report (Updated: June 2024).
772,649 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It is a stable and scalable solution.""The most valuable feature for me is the visual interface of AWS Glue.""The solution integrates well with other AWS products or services.""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.""The solution's technical support is good. Whenever we raise a use case where we face an issue in our company, we get a response from the solution's technical team.""AWS Glue's most valuable features are the data catalog, including crawlers and tables, and Glue Studio, which means you don't have to use custom code.""Our entire use case was very easily handled or solved using this solution.""The solution is highly user-friendly, and its features are easy to use. The new addition of AWS Glue Data Catalog is also very beneficial, making the tool even more helpful for its users."

More AWS Glue Pros →

"People are able to scale up, learn it quickly, and start delivering.""The solution is scalable.""The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects.""The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive.""The most valuable feature is the ease of customization.""The Oracle integration tool is the most comfortable tool for using those Oracle products.""The most valuable feature of Oracle Integration Cloud Service is its ease of use. We do not depend on any tool to develop it. Everything is on the browser and is easy to integrate, even for someone who does not understand a lot about coding.""Oracle Integration Cloud Service offers a lot of adaptors."

More Oracle Integration Cloud Service Pros →

Cons
"The mapping area and the use of the data catalog from Glue could be better.""The technical support for this solution could be improved. In future, we would like to connect more services like Athena or Kinesis to help control more loads of data.""The solution’s stability could be improved.""The solution should offer features for streaming data in addition to batching data.""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.""It would be better if it were more user-friendly. The interesting thing we found is that it was a little strange at the beginning. The way Glue works is not very straightforward. After trying different things, for example, we used just the console to create jobs. Then we realized that things were not working as expected. After researching and learning more, we realized that even though the console creates the script for the ETL processes, you need to modify or write your own script in Spark to do everything you want it to do. For example, we are pulling data from our source database and our application database, which is in Aurora. From there, we are doing the ETL to transform the data and write the results into Redshift. But what was surprising is that it's almost like whatever you want to do, you can do it with Glue because you have the option to put together your own script. Even though there are many functionalities and many connections, you have the opportunity to write your own queries to do whatever transformations you need to do. It's a little deceiving that some options are supposed to work in a certain way when you set them up in the console, but then they are not exactly working the right way or not as expected. It would be better if they provided more examples and more documentation on options.""The product is expensive for data streaming. This area needs improvement.""Glue could perform better. It sometimes takes too long to test a Glue job. Google Cloud Platform offers more Python scripts than AWS."

More AWS Glue Cons →

"Now the platform is not built in a way that you can define.""The bulk processing needs improvement.""Our client was quite concerned about the cost, which is something that could be reduced.""Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release.""The support and resources were lacking — they weren't there.""The logging capabilities could be enhanced. Currently, logs are only retained for a few days, which can be inconvenient for administrators. Ideally, we'd like the option to configure log retention periods, like a month or fifteen days, instead of the current one-week limit.""It has lengthy documentation, making the process of building applications more time-consuming.""They should provide tutorials for beginners to learn about the processes."

More Oracle Integration Cloud Service 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."
  • "This solution is affordable and there is an option to pay for the solution based on your usage."
  • "AWS Glue is quite costly, especially for small organizations."
  • "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."
  • "The overall cost of AWS Glue could be better. It cost approximately $1,000 a month. There is paid support available from AWS Glue."
  • More AWS Glue Pricing and Cost Advice →

  • "It specifies how much data you use and how much storage you require, among other things."
  • "The price of Oracle Integration Cloud Service is good. It is reasonable and is priced well for the market segment. The model they use is on a per-package unit and we have a two-year subscription."
  • "The solution is less expensive than other products."
  • "The price is fair."
  • "The price of Oracle Integration Cloud Service is reasonable to start with, but when you scale it becomes expensive."
  • "The solution is cost-effective."
  • "Its pricing is relatively lower than other vendors."
  • "The price is cheaper than all other cloud integration providers."
  • More Oracle Integration Cloud Service Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
    772,649 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: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… more »
    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:I would rate the pricing a four out of ten, with one being very cheap and ten being very expensive.
    Ranking
    1st
    Views
    11,616
    Comparisons
    8,101
    Reviews
    32
    Average Words per Review
    419
    Rating
    7.8
    Views
    3,249
    Comparisons
    2,125
    Reviews
    19
    Average Words per Review
    745
    Rating
    8.2
    Comparisons
    Also Known As
    Oracle ICS
    Learn More
    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 Integration Cloud Service is a cloud-based integration tool that seamlessly integrates on-premise applications with Oracle Cloud (SaaS) or other cloud apps (for example, Workday, Salesforce, etc.) to other cloud apps. Oracle’s solution combines all the capabilities of application integration, process automation, visual application building, and integration analytics into a single unified cloud service. The solution offers real-time and batch-based integration, structured and unstructured processes, case management, stream analytics, and integration insight. All of these capabilities together allow users to service all their end-to-end integration needs in one cohesive platform.

    Oracle Integration Cloud Service Features

    Oracle Integration Cloud Service has many valuable key features. Some of the most useful ones include:

    • Visual application builder service
    • Integration insight
    • Process automation
    • Visual application design
    • SaaS and on-premises integration
    • Stream analytics
    • Easy setup

    Oracle Integration Cloud Service Benefits

    There are many benefits to implementing Oracle Integration Cloud Service. Some of the biggest advantages the solution offers include:

    • Powerful dashboards: The solution provides users with all the information they need via powerful dashboards that require no coding, configuration, or modification.
    • Agility: Oracle Integration Cloud Service brings agility to organizations with an easy, visual, low-code platform that simplifies day-to-day tasks by getting employees, customers, and partners the services they need to work anywhere, anytime, on any device.
    • Visual development environment: With the solution’s visual development environment, users can rapidly create and host engaging business applications.
    • Top-tier security: With Oracle Integration Cloud Service, users are protected with various forms of top-tier security, including physical protection, OS security, and virtualization layer security, as well as tenant isolation for devoting more resources towards a specific user or customer.
    • More than 50 native app adapters: Because the solution has more than 50 native app adapters, users can quickly connect to thousands of SaaS or on-premises applications seamlessly.

    Reviews from Real Users

    Oracle Integration Cloud Service is a solution that stands out when compared to many of its competitors. Some of its major advantages are that it has good adapters, is user friendly, and produces a solid ROI.

    Rishabh S., Business and Technology Delivery Associate Manager at Accenture, says, “It has good performance, easy integration, is user-friendly, and also has helpful technical support. The dashboard provided by Oracle Integration Cloud for monitoring and error handling is very intuitive. You do not need a third-party dashboard or logging framework when you initiate the integration. There are a lot of adapters, which is what I like the most.”

    “The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects,” says PeerSpot user Arun N., Technical Manager at a financial services firm.

    Kanhaiya C., Solution Architect at Tata Consultancy, explains, "Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."

    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Calix, Avaya, Land Lakes, Leader, PWC, Vale
    Top Industries
    REVIEWERS
    Computer Software Company47%
    Financial Services Firm18%
    Pharma/Biotech Company12%
    Consumer Goods Company6%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company14%
    Manufacturing Company8%
    Insurance Company7%
    REVIEWERS
    Computer Software Company38%
    Financial Services Firm23%
    Educational Organization8%
    Pharma/Biotech Company8%
    VISITORS READING REVIEWS
    Educational Organization36%
    Computer Software Company11%
    Financial Services Firm8%
    Manufacturing Company5%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise13%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise72%
    REVIEWERS
    Small Business22%
    Midsize Enterprise22%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise43%
    Large Enterprise44%
    Buyer's Guide
    Cloud Data Integration
    June 2024
    Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: June 2024.
    772,649 professionals have used our research since 2012.

    AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Oracle Integration Cloud Service is ranked 3rd in Integration Platform as a Service (iPaaS) with 32 reviews. AWS Glue is rated 7.8, while Oracle Integration Cloud Service is rated 8.0. The top reviewer of AWS Glue writes "Provides serverless mechanism, easy data transformation and automated infrastructure management". On the other hand, the top reviewer of Oracle Integration Cloud Service writes "An integration tool that is highly compatible and easy to maintain". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, Informatica Cloud Data Integration, SSIS and Confluent, whereas Oracle Integration Cloud Service is most compared with Oracle Data Integrator (ODI), Mule Anypoint Platform, Oracle GoldenGate, Azure Data Factory and Microsoft Azure Logic Apps.

    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.