AWS Glue vs Oracle Integration Cloud Service comparison

AWS Glue

Read 37 AWS Glue reviews

11,616 Views
8,101 Comparison Views

92% willing to recommend

Oracle Integration Cloud Se...

Read 32 Oracle Integration Cloud Service reviews

3,249 Views
2,125 Comparison Views

86% willing to recommend

AWS Glue

Oracle Integration Cloud Se...

Comparison Buyer's Guide

Download the report

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

Buyer's Guide

Cloud Data Integration

June 2024

Download the complete report

Helped 787,061 peers since 2012

Categories and Ranking

AWS Glue

Average Rating

7.8

Number of Reviews

Ranking in other categories

Cloud Data Integration (1st)

Oracle Integration Cloud Se...

Average Rating

8.0

Number of Reviews

Ranking in other categories

Integration Platform as a Service (iPaaS) (3rd)

Market share comparison

As of June 2024, in the Cloud Data Integration category, the market share of AWS Glue is 27.9% and it increased by 15.0% compared to the previous year. The market share of Oracle Integration Cloud Service is 4.3% and it decreased by 39.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Integration

Unique Categories:

No other categories found

Integration Platform as a Service (iPaaS)

8.1%

Featured Reviews

Sainagaraju Vaduka

Data solution architect at a pharma/biotech company with 5,001-10,000 employees

Oct 28, 2022

Excellent scalability, with valuable features, and profitable return on investment

We are primarily using it for batch crossing and transformations We have a large set of data and we are doing some transformations and identification. We are cleaning the data and transformations. Then we are putting the data into the destination table. So it is very comfortable. The most…

Read full review

Gustavo Magni

lead architect at Sys Manager

May 22, 2023

Has good stability and efficiently integrates with different applications

I use the solution for system integration with different applications The solution has helped our organization properly frame the integration with different platforms. The solution provides efficient integration with multiple platforms. They should include more integration for the solution with…

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

"The key role for Glue is that it hosts our metadata before rolling out our actual data. This is the major advantage of using this solution and our clients client have been very satisfied with it."

"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations."

"AWS Glue is quite better than other tools, but you have to learn it properly before you start using it."

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

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

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

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

More AWS Glue pros

"I particularly like the drag-and-drop feature for designing integrations and processes."

"Oracle Integration Cloud Service offers a lot of adaptors."

"The OIC is very good."

"It is a scalable solution."

"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."

"Provides various ways to secure services as well as providing extensive support."

"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"

"The initial setup of Oracle Integration Cloud Service was easy."

More Oracle Integration Cloud Service pros

Cons

"The solution should offer features for streaming data in addition to batching data."

"It fails to handle massive databases acquired from various sources."

"I would like to see stable libraries at the moment they are not there."

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

"The product has only a few built-in transformations."

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

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

"We face performance issues when using AWS Glue for data transformation and integration."

More AWS Glue cons

"The bulk processing needs improvement."

"The support and resources were lacking — they weren't there."

"Now the platform is not built in a way that you can define."

"The solution doesn't currently have a fully fledged workflow feature like they have in OIM."

"Oracle Integration Cloud Service can improve the downloading and uploading of files. I've submitted this issue to the Oracle Idea Labs. The issue is from the front end of Oracle Integration Cloud, we cannot download or upload a file directly or drag and drop it."

"Sometimes, the tech support is slow to get back to us. We have had to wait up to two weeks for a response."

"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."

"It has lengthy documentation, making the process of building applications more time-consuming."

More Oracle Integration Cloud Service cons

Pricing and Cost Advice

"I rate the product's pricing a five on a scale of one to ten, where one is a high price, and ten is a low price."

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

"AWS Glue follows a pay-as-you-go model, wherein the cost of the data you use will be counted as a monthly bill."

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

"AWS Glue is a paid service that doesn't come under the free trial of AWS."

"AWS Glue is quite costly, especially for small organizations."

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

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

More AWS Glue pricing and cost advice

"The price is fair."

"I would rate the pricing a four out of ten, with one being very cheap and ten being very expensive."

"Its pricing is relatively lower than other vendors."

"In the case of Oracle Integration Cloud, costs can be "predictable" as far as the platform and infrastructure are concerned."

"It specifies how much data you use and how much storage you require, among other things."

"The solution is less expensive than other products."

"The price is cheaper than all other cloud integration providers."

"The price of Oracle Integration Cloud Service is reasonable to start with, but when you scale it becomes expensive."

More Oracle Integration Cloud Service 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

787,061 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Computer Software Company

14%

Manufacturing Company

Insurance Company

Educational Organization

36%

Computer Software Company

11%

Financial Services Firm

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 Integration Cloud Service?

OIC's accuracy is quite good.

See all answers

What is your experience regarding pricing and costs for Oracle Integration Cloud Service?

I would rate the pricing a four out of ten, with one being very cheap and ten being very expensive.

See all answers

Comparisons

AWS Database Migration Service vs AWS Glue

Compared 27% of the time

Informatica PowerCenter vs AWS Glue

Compared 9% of the time

Informatica Cloud Data Integration vs AWS Glue

Compared 7% of the time

SSIS vs AWS Glue

Compared 6% of the time

Confluent vs AWS Glue

Compared 4% of the time

More AWS Glue Competitors

Oracle Data Integrator (ODI) vs Oracle Integration Cloud Service

Compared 28% of the time

Mule Anypoint Platform vs Oracle Integration Cloud Service

Compared 8% of the time

Oracle GoldenGate vs Oracle Integration Cloud Service

Compared 7% of the time

Azure Data Factory vs Oracle Integration Cloud Service

Compared 6% of the time

Microsoft Azure Logic Apps vs Oracle Integration Cloud Service

Compared 6% of the time

More Oracle Integration Cloud Service Competitors

Product Reports

Buyer's Guide

AWS Glue

June 2024

Download AWS Glue product report

Buyer's Guide

Oracle Integration Cloud Service

May 2024

Download Oracle Integration Cloud Service product report

Also Known As

No data available

Oracle ICS

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

Buyer's Guide

Cloud Data Integration

June 2024

Download Free Report

Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration. Updated: June 2024.

DOWNLOAD NOW

787,061 professionals have used our research since 2012.

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.