• Home
  • AWS Glue vs. Oracle GoldenGate

AWS Glue vs Oracle GoldenGate comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo

AWS Glue

Read 37 AWS Glue reviews
12,012 views|8,420 comparisons
92% willing to recommend
Oracle Logo

Oracle GoldenGate

Read 47 Oracle GoldenGate reviews
10,338 views|7,458 comparisons
96% willing to recommend
Comparison Buyer's Guide
Download the complete report
Buyer's Guide
AWS Glue vs. Oracle GoldenGate
March 2024
Executive Summary

We performed a comparison between AWS Glue and Oracle GoldenGate 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 GoldenGate Report (Updated: March 2024).
Download the complete report
768,578 professionals have used our research since 2012.
Featured Review
Sunil Morya
Easy to set up, useful for batch processing, and is free to try
The solution helps organizations gain flexibility in defining the structure of the data. You can define and then include the original data... Read more →
Gerson Silveira
A robust and reliable data replication and integration providing real-time, heterogeneous data movement that...
It's an incredible tool, as it's quite impressive to construct the gateway. The process is surprisingly quick, and it has been around for a... Read more →
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I like that it's flexible, powerful, and allows you to write your own queries and scripts to get the needed transformations.""I appreciate AWS Glue for its cost-effectiveness.""The solution integrates well with other AWS products or services.""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.""It is AWS-integrated. There is end-to-end integration with the other AWS services. It is also user-friendly.""The most valuable feature of AWS Glue is scalability.""We no longer had to worry much about infrastructure management because AWS Glue is serverless, and Amazon takes care of the underlying infrastructure.""AWS Glue is fast and managed by AWS. Hence, you don't have to worry about capacity and the performance of Glue jobs. It has integrations with other data stores of AWS. The product offers metadata management, logging, and ETL processing capabilities. It comes with a powerful feature, Glue Studio, which helps to do queries interactively within the community. It is a managed service and very secure. Another popular and mature service is S3."

More AWS Glue Pros →

"CDC is the most valuable feature.""The solution's existing SaaS platform for data integration gives us an edge.""Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support.""This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.""The product is reliable for data integrity.""I am impressed with the tool's possibility of integrating different systems in a unified place.""Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful.""Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."

More Oracle GoldenGate Pros →

Cons
"The product has only a few built-in transformations.""There is a learning curve to this tool.""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.""Overall, I consider the technical support to be fine, although the response time could be faster in certain cases.""I haven't looked into Glue in terms of seeking out flaws. I've not come across missing features.""The setup and installation is a bit complex without advanced knowledge or training.""The mapping area and the use of the data catalog from Glue could be better.""We face performance issues when using AWS Glue for data transformation and integration."

More AWS Glue Cons →

"Lacks the ability to become a full-scale ETL tool.""It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear.""Microservices Architecture is not user-friendly.""It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure.""Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration.""There are a lot of bugs in the solution.""The solution needs to improve its latency, monitoring and support.""Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."

More Oracle GoldenGate 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 →

  • "The one feature that I think Oracle could perhaps consider is, at the moment, the Veridata option is an extra cost. Golden Gate is an expensive product. You pay a lot for the best. But not including the Veridata license to prove that everything is working correctly... The big improvement for me would be to have that license built in. That would take it to the next level. That would make it a much better product. You may want to look at buying term licenses if you've just got a single migration to do. In that situation, you might want a term license for perhaps a year to save a lot of money, rather than buying a perpetual license."
  • "The licensing model should be improved to be more cost-effective for the end users."
  • "We do like the price of this solution."
  • "Pricing is based on anual licensing with additional costs for support packages."
  • "The price of this solution is good."
  • "We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee."
  • "Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."
  • "We have purchased corporate licensing to use Oracle GoldenGate."

    • More Oracle GoldenGate Pricing and Cost Advice →

    report
    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
    768,578 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    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 being the primary purpose of all the mentioned technologies, each have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA's must learn and understand the functionality of both and know which technique can be used and in what scenario. Let's discuss the differences between Oracle Active Dataguard and Oracle GoldenGate. Oracle Active Dataguard is simple and the most economical solution for replication. The concept of active dataguard is a super set of traditional dataguard. It offers real time data protection and availability. Here in active replication you can place your secondary database in read-only mode, where the secondary database is available to users for limited usage like reporting and query offloading. Active Dataguard promises zero data loss across large distances without hampering performance. Other benefits to count on you can consider the capability of Active Dataguard to automatically repair the physical corruption without incurring any performance impact and availability of… Read more →
    Questions from the Community
    How do you select the right cloud ETL tool?
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Read all 2 answers   →
    How does Talend Open Studio compare with AWS Glue?
    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 »
    What are the most common use cases for AWS Glue?
    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 »
    Read all 2 answers   →
    What do you like most about Oracle GoldenGate?
    Top Answer:The product is reliable for data integrity.
    Read all 32 answers   →
    What is your experience regarding pricing and costs for Oracle GoldenGate?
    Top Answer:It's a middleware. The price depends on the customers and the number of licenses they buy.
    Read all 25 answers   →
    What needs improvement with Oracle GoldenGate?
    Top Answer:Microservices Architecture is not user-friendly. It would have been great if the product would have stayed with the classic architecture and expanded into Microservices. However, it has completely… more »
    Read all 29 answers   →
    Ranking
    1st
    out of 42 in Cloud Data Integration
    Views
    12,012
    Comparisons
    8,420
    Reviews
    32
    Average Words per Review
    419
    Rating
    7.8
    6th
    out of 100 in Data Integration
    Views
    10,338
    Comparisons
    7,458
    Reviews
    26
    Average Words per Review
    382
    Rating
    8.2
    Comparisons
    Also Known As
    GoldenGate
    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 GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.

    Oracle GoldenGate Features

    Oracle GoldenGate has many valuable key features, including:

    • Simple to use web interface
    • Fast and easy installation or provisioning
    • Command line access via AdminClient that can run anywhere
    • RESTful APIs for DevOps
    • Offers built-in monitoring but also can be easily adapted to roll your own monitoring
    • APIs are protected by Cross Site Request Forgery (CSRF) authentication.

    Oracle GoldenGate Benefits

    Some of the benefits of using Oracle GoldenGate include:

    • Oracle GoldenGate is deeply integrated with the Oracle Database (logging, redo, backup and recovery layer, security, administration, data guard, data vault, autonomous database etc.).

    • It is the most stable, performant, and reliable CDC / replication solution for Oracle.

    • High performance: Oracle GoldenGate is capable of sub-second latency for data movement. featuring low impact capture, routing, transformation, and delivery of transactional data.

    • GoldenGate is the only CDC / replication tool that keeps pace with new and emerging innovations (security, features, data types, etc) in the core Oracle Database.

    • The solution supports a wide range of use cases, from conventional OLTP data replication and high availability to data lake ingestion or multi-cloud ingestion, SaaS application replication, and messaging replication.
    • GoldenGate is the only CDC / replication technology certified for Exadata, Exadata Cloud Service, and Exadata Cloud at Customer.

    • For fault-tolerance, GoldenGate has its own mechanism to keep track of how much work is completed and how much is pending. This mechanism is independent of any database and ensures, with the help of automatic gap-resolution, that no data loss occurs.

    • GoldenGate uses its own proprietary format files for keeping the committed data coming from the source database, making it independently functional irrespective of the database in use.

    • To maintain the performance and consistency, only committed data is sent. Uncommitted data is captured by GoldenGate, but is discarded after receiving a Rollback.

    • With GoldenGate, data sending is in “near real time,” which reduces the possibility of latency.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by Oracle GoldenGate users.

    PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."

    Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”

    A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."

    An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."






    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
    Top Industries
    REVIEWERS
    Computer Software Company47%
    Financial Services Firm18%
    Pharma/Biotech Company12%
    Consumer Goods Company6%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company14%
    Manufacturing Company7%
    Insurance Company7%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company19%
    Healthcare Company12%
    Comms Service Provider8%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Computer Software Company13%
    Manufacturing Company8%
    Government7%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise13%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise12%
    Large Enterprise73%
    REVIEWERS
    Small Business42%
    Midsize Enterprise8%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    Buyer's Guide
    AWS Glue vs. Oracle GoldenGate
    March 2024
    Free Report: AWS Glue vs. Oracle GoldenGate
    Find out what your peers are saying about AWS Glue vs. Oracle GoldenGate and other solutions. Updated: March 2024.
    DOWNLOAD NOW
    768,578 professionals have used our research since 2012.

    AWS Glue is ranked 1st in Cloud Data Integration with 37 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 47 reviews. AWS Glue is rated 7.8, while Oracle GoldenGate is rated 8.2. 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 GoldenGate writes "Performs real-time replication without data loss, but we cannot do much automation". AWS Glue is most compared with AWS Database Migration Service, Informatica PowerCenter, SSIS, Informatica Cloud Data Integration and Talend Open Studio, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and SAP Data Services. See our AWS Glue vs. Oracle GoldenGate 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.