Skip to main content
TrustRadius
Oracle GoldenGate

Oracle GoldenGate

Overview

What is Oracle GoldenGate?

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

Read more

Learn from top reviewers

GoldenGate Bridges the gaps between Production and BCP

Rating: 10 out of 10
May 18, 2021
IncentivizedVetted ReviewVerified User
Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary database to the BCP copy of the datab...
Continue reading
Gene Baker
Manager - Information Technology
Vice President, Chief Architect, Development Manager and Software Engineer
WySTAR Global Retirement Solutions, a Wells Fargo Company
Oracle GoldenGate3 years of experience

GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity

Rating: 8 out of 10
December 13, 2020
IncentivizedVetted ReviewVerified User
GoldenGate (GG) is being used by the utility company I work for in various areas. Data Analytics is the main use of GG at the moment. Normally, the sheer level of database h...
Continue reading
Chris Oros
Analyst - Information Technology
IT Analyst
Duquesne Light Co.
Oracle GoldenGate2 years of experience

OGG - always in-sync

Rating: 8 out of 10
December 8, 2020
IncentivizedVetted ReviewVerified User
Our company in EMEA region has two data centers, working in the Active/Passive(standing by) mode. We use Oracle GoldenGate to "clone" the live data transactions from the maste...
Continue reading
Verified user
Strategist
Oracle GoldenGate4 years of experience

Replicate as much as you can as frequent as you can

Rating: 8 out of 10
December 7, 2020
IncentivizedVetted ReviewVerified User
Currently [Oracle] GoldenGate is being used to replicate a backup database for disaster recovery and also integrating different data sources to a single database.
Continue reading
Verified user
Team Lead
Oracle GoldenGate1 year of experience

Oracle Golden Gate is efficient and high performance

Rating: 10 out of 10
December 5, 2020
IncentivizedVetted ReviewVerified User
Oracle GoldenGate is being used by the departments as required and as needed. Especially we used for migration purpose. We are migrating the databases from on-premises to Clou...
Continue reading
Jacob Biguvu
Engineer - Information Technology
Cloud DBA/Developer (Cloud and On-Premises)
Capital One, Walmart
Oracle GoldenGate7 years of experience

Oracle GoldenGate Review

Rating: 8 out of 10
December 4, 2020
IncentivizedVetted ReviewVerified User
We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tons of applications to assign installation and repair jobs to fiel...
Continue reading
Verified user
Engineer
Oracle GoldenGate1 year of experience

An OK tool for data replication--not great but not completely terrible

Rating: 7 out of 10
December 3, 2020
IncentivizedVetted ReviewVerified User
Oracle GoldenGate is used in a traditional manner for homogeneous data replication between production and non-production environments. This allows the different environments t...
Continue reading
Verified user
Professional
Oracle GoldenGate5 years of experience

GoldenGate is best for real-time data needs.

Rating: 10 out of 10
December 4, 2019
IncentivizedVetted ReviewVerified User
It's used by our Computer Services Department to create reporting databases as well as for DR. The replication is unidirectional and replicates data in four non-production env...
Continue reading
João Leal
Engineer - Information Technology
Oracle Services Engineer
TAP
Oracle GoldenGate3 years of experience

The Golden Gate to Success!

Rating: 8 out of 10
October 7, 2019
IncentivizedVetted ReviewVerified User
Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery ...
Continue reading
Verified user
Engineer
Oracle GoldenGate2 years of experience

GG is great for what it is, but be aware of its limitations

Rating: 6 out of 10
September 18, 2019
IncentivizedVetted ReviewVerified User
We use GoldenGate to sync up data from our customer and care system to Oracle Analytics Database
Continue reading
Serge Trikur
Professional - Information Technology
Sr System Admin
PGE
Oracle GoldenGate2 years of experience

Oracle Golden Gate implementation at courier services

Rating: 8 out of 10
September 18, 2019
IncentivizedVetted ReviewVerified User
We use it for our core system to support our main database for courier services. The core system is used by all of the operations and sales teams, as well as the Board of Dire...
Continue reading
budhi setyawan
Advisor - Corporate
consultant
TIKI JNE
Oracle GoldenGate5 years of experience

Oracle GoldenGate Review

Rating: 7 out of 10
September 17, 2019
IncentivizedVetted ReviewVerified User
GoldenGate is being used as a DR solution and as well as a method for replicating from a transactional to reporting DB. It is used across the whole organization. It addresses ...
Continue reading
Verified user
Administrator
Oracle GoldenGate5 years of experience

GoldenGate for active applications across datacenters

Rating: 8 out of 10
September 17, 2019
IncentivizedVetted ReviewVerified User
We use Oracle GoldenGate for multiple reasons such as data replication, to maintain active/active databases for critical applications and not but least for database migration ...
Continue reading
Verified user
Director
Oracle GoldenGate10 years of experience

Oracle GoldenGate - The best logical replication tool in the market.

Rating: 10 out of 10
September 17, 2019
IncentivizedVetted ReviewVerified User
Oracle GoldenGate is used widely across the organization. We use it for heterogeneous replication, active-active and active hot standby, and offloading reporting.
Continue reading
Verified user
Professional
Oracle GoldenGate12 years of experience

GoldenGate Rocks

Rating: 10 out of 10
September 17, 2019
IncentivizedVetted Review
We use it to move data between databases to a dw for reporting purposes. We also use it to transform data as it moves, and we use it to populate pdb's to enable our services a...
Continue reading
Verified user
Team Lead
Oracle GoldenGate6 years of experience
Log in with LinkedIn to see content from your network

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

Data Integration

$250.00

Cloud
Per License

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://cloud.oracle.com/en_US/goldenga…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Oracle Goldengate demo

YouTube

Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_31st May

YouTube

2017 05 19 22 04 Oracle Goldengate Demo

YouTube

Webinar On Oracle Goldengate Different Types of Architecture and Installation of Goldengate_14 June

YouTube

Oracle 12c Golgen Gate Essentials Training - DEMO

YouTube

Configuring Integrated Extract and Integrated Replicat Using Oracle GoldenGate 12c on Linux

YouTube
View more demos
Return to navigation

Product Details

What is Oracle GoldenGate?

Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables:
-Real-time business intelligence and stream analytics for improved business insight
-Query offloading to maximize OLTP performance
-Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability

Documentation

Video Oracle GoldenGate Cloud Service - Get an overview of this cloud based real-time data integration and replication service that provides quick, easy, accurate and safe data movement to the cloud. https://youtu.be/liBgUwHgVew

Oracle GoldenGate Video

GoldenGate Cloud for real-time replication

Oracle GoldenGate Integrations

Oracle GoldenGate Competitors

Oracle GoldenGate Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Oracle GoldenGate Downloadables

Frequently Asked Questions

Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.

Azure Data Factory, AWS Database Migration Service, and Informatica Cloud Data Integration are common alternatives for Oracle GoldenGate.

Reviewers rate Oracle Implementation Satisfaction highest, with a score of 9.7.

The most common users of Oracle GoldenGate are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(221)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Real-time Data Replication Capabilities: Users have praised Oracle GoldenGate for its real-time data replication capabilities, allowing immediate access to data without additional processes. This feature ensures that users can work with the most up-to-date information at all times.

Seamless Modification of Data: Some reviewers have highlighted the time-saving feature of modifying data during transit with Oracle GoldenGate, especially beneficial for making seamless changes to large datasets before synchronization. This functionality streamlines the process of data manipulation and enhances efficiency in handling extensive amounts of information.

Flexibility in Data Replication: Customers value the product's support for multiple data sources beyond just Oracle databases, appreciating its flexibility in handling various replication scenarios. The ability to replicate data from diverse sources contributes to a more comprehensive approach to managing information across different platforms.

Syncing Large Objects: Some users have experienced lag issues when syncing large objects like CLOBs and BLOBs in Oracle GoldenGate, which can be cumbersome in an Oracle environment. This has led to potential delays in data synchronization processes.

Setup Complexity: Reviewers have mentioned that setting up Oracle GoldenGate can be time-consuming, especially with multiple databases, and they find the structure could be more intuitive. The intricate setup process has caused frustration among users seeking a more streamlined configuration experience.

Costly Metrics UI: Users feel that the metrics UI is an additional costly product and prefer using open-source options like Grafana. They also express a need for improved documentation for easier access to information, highlighting the lack of clarity on metric tracking functionalities within Oracle GoldenGate.

Reviews

(1-25 of 41)
Companies can't remove reviews or game the system. Here's why

GoldenGate Bridges the gaps between Production and BCP

Rating: 10 out of 10
Incentivized
May 18, 2021
GB
Gene Baker
Vice President, Chief Architect, Development Manager and Software Engineer
WySTAR Global Retirement Solutions, a Wells Fargo Company (Financial Services, 10,001+ employees)
Vetted Review
Verified User
Oracle GoldenGate
3 years of experience
View profile
Use Cases and Deployment Scope
Oracle GoldenGate is used as part of our business continuity plan. We use it to replicate in near realtime, transactions from the primary database to the BCP copy of the database. We also use it to maintain a reporting instance of our transactional database so we can offload read-only type queries in order to minimize performance impacts on the transactional database. We are experimenting with using GoldenGate to perform some transformations for us so that we can create data marts for various teams within the organization. That is still in the POC stage.
Pros and Cons
  • Replication
  • Business Continuity
  • Query offloading
Likelihood to Recommend
I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.

GoldenGate - Ideal Synchronization for Low/Moderate Data Complexity

Rating: 8 out of 10
Incentivized
December 13, 2020
CO
Chris Oros
IT Analyst
Duquesne Light Co. (Utilities, 1001-5000 employees)
Vetted Review
Verified User
Oracle GoldenGate
2 years of experience
Use Cases and Deployment Scope
<p>GoldenGate (GG) is being used by the utility company I work for in various areas. </p> <p>Data Analytics is the main use of GG at the moment. Normally, the sheer level of database hits required by our daily Business Intelligence reports would place a heavy burden on the disk groups in our core ASM; however, with GG, we are able to seamlessly replicate that data in real-time into a separate database using separate resources. By doing this, we are able to alleviate potential bandwidth issues posed by our BI group’s database querying. It should be noted that GG does not require all tables to be replicated: we only replicate under 100 of the thousands of tables in the main databases. Our GG database is not normalized, so we are essentially combining disparate databases into one, which has its advantages and disadvantages.</p> <p>Another use we currently have for GoldenGate is on a large project level. As part of a data conversion effort, we are using GoldenGate to replicate data into a separate database in real-time. This will allow us to save 12+ hours during our conversion, as well will not need to execute an RMAN backup in order to move data into our target database. In other words, we are directly replicating data into our target database, so right when we are ready to switch servers/databases for the go-live of our project, we will be ready to immediately start to convert data.</p>
Pros and Cons
  • Replicates data without "missing" items. This is key, as there was initial concern that with the amount of tables and columns involved, certain items were bound to be "missed", though we have not seen this (outside of an anomalous server crash incident that wasn't due to GG).
  • Replicates data in real-time. Proof of concept for GG was intuitive for end users, as the data is immediately available. There are no "jobs" or "interfaces" that need to be run: the data is immediately available on the target database for viewing
  • GG is able to modify data "in transit", which can save loads of time if you were to need to instead modify large amounts of data after it is synchronized to the target database. As one would expect, this is seamless with low complexity modification, by can become untenable with larger blocks of data (e.g. CLOBs).
Likelihood to Recommend

Oracle [GoldenGate] is well suited for data replication where real-time results are important, such as data reporting. There is potential to have the users query the replicated database, which can have separate resources set up to be compressed or using lower performing or cheaper resources.

As mentioned, columns with LOBs can become a headache, as they will need to be synchronized in their own group many times. Tables containing data in CHAR, VARCHAR, NUMBER, DATE, or other non-LOB columns, however, are able to be replicated quite seamlessly.

[Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.

OGG - always in-sync

Rating: 8 out of 10
Incentivized
December 08, 2020
Verified User
Vetted Review
Verified User
Oracle GoldenGate
4 years of experience
Use Cases and Deployment Scope
Our company in EMEA region has two data centers, working in the Active/Passive(standing by) mode. We use Oracle GoldenGate to "clone" the live data transactions from the master database (which resides in the currently active data center) to the standing-by database (which is in the limited read-only mode, and resides in our passive data center). If the active DC is down and DR is required, the standing-by database in the passive DC will be promoted to the master one which can take R/W transactions, and the OGG will reverse the uni-direction data copy. This pattern is applied on all business critical IT application's DB instances.
Pros and Cons
  • As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well.
  • For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target).
  • It is robust and the performance meets our SLA, even for a large amount of data volume.
  • The error report is not only detailed but hits the right points, so trouble shooting is easy.
Likelihood to Recommend
Oracle GoldenGate is very handy to deal with Data Center to Data Center DB copy (near real time), uni-directional or bi-directional, it is also suitable to copy the data from production environment to the testing/dev environments. If you also have to deal with the problem of decoupling the reporting purposed read from the busy transaction-intensive operational DB instance, OGG will be also a good candidate. However Oracle GoldenGate is like the other Oracle products, quite expensive, so the small/medium company may not be able to afford the cost.

Replicate as much as you can as frequent as you can

Rating: 8 out of 10
Incentivized
December 07, 2020
Verified User
Vetted Review
Verified User
Oracle GoldenGate
1 year of experience
Use Cases and Deployment Scope
Currently [Oracle] GoldenGate is being used to replicate a backup database for disaster recovery and also integrating different data sources to a single database.
Pros and Cons
  • Documentation is easy to follow
  • Downtime seems very minimal
  • Able replicate in real-time
Likelihood to Recommend
If you need to integrate many data sources together, [Oracle] GoldenGate is well suited to easily do that while maintaining data integrity.

Oracle Golden Gate is efficient and high performance

Rating: 10 out of 10
Incentivized
December 05, 2020
JB
Jacob Biguvu
Cloud DBA/Developer (Cloud and On-Premises)
Capital One, Walmart (Financial Services, 10,001+ employees)
Vetted Review
Verified User
Oracle GoldenGate
7 years of experience
View profile
Use Cases and Deployment Scope
Oracle GoldenGate is being used by the departments as required and as needed. Especially we used for migration purpose. We are migrating the databases from on-premises to Cloud. The real problem is to complete the migration with zero-downtime. We need a revert plan (rollback strategy) when it fails. [Oracle] GoldenGate helped a lot in completing this migration task with Zero-downtime. [Oracle GoldenGate] is real-time data capture, continuous delivery of transaction data across different sources.
Pros and Cons
  • OGG can be used and integrated with heterogeneous databases as well as homogeneous databases.
  • OGG is easy setup as well as easy learning curve
  • OGG supports large databases
  • OGG support many uses cases (topologies) such as unidirectional replication, bidirectional, peer-to-peer, Broadcast, Cascading replication etc.
  • OGG can be used not only for CDC (change capture), can be used to full load
Likelihood to Recommend
  • when you want to migrate databases with Zero-down migration (on-prem to on-prem/ on-prem to cloud/cloud to cloud / cloud to on-prem)
  • when you want to replicate the entire database between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
  • when you want to replicate the specific tables between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
  • when you want to replicate the data set between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)
  • when you want to create Read-Only databases
  • when you want to create two master database - using bidirectional databases

Oracle GoldenGate Review

Rating: 8 out of 10
Incentivized
December 04, 2020
Verified User
Vetted Review
Verified User
Oracle GoldenGate
1 year of experience
Use Cases and Deployment Scope
We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tons of applications to assign installation and repair jobs to field technicians. In some of the applications, we can't afford latency or replication errors. GoldenGate has been a great tool.
Pros and Cons
  • I was able to find what I needed, but it took longer than I think it needed to. The system was navigable, but not until I had training on it. Before that I was clueless on how to find anything.
  • It allows the replication in real time from the Oracle database in RAC to the contingency database, through the immediate replication of the data in the redo logs, without the need to wait for them to be written at the level of the archive logs.
  • You can have multiple different data sources coming into this Oracle GoldenGate. You are not limited to only Oracle databases.
Likelihood to Recommend
GoldenGate helps us to keep a replica of the database consistent, in real time, which is used for reportage in read only mode, In this way we manage to reduce the load of the production database, redirecting all the generation of reports to the contingency site, leaving all the processing capacity available for the provision of services of the productive applications. We are also replicating data from a source database to a target database. GoldenGate works well for that purpose.

An OK tool for data replication--not great but not completely terrible

Rating: 7 out of 10
Incentivized
December 03, 2020
Verified User
Vetted Review
Verified User
Oracle GoldenGate
5 years of experience
Use Cases and Deployment Scope
Oracle GoldenGate is used in a traditional manner for homogeneous data replication between production and non-production environments. This allows the different environments to be utilized for different purposes with the same source data. Some environments are for real-time data analysis while others are backend reporting and analysis.
Oracle GoldenGate allows us to split highly responsive, mission critical systems from lower environments while retaining clean copies of source data.
Pros and Cons
  • Integrates with Oracle databases and Oracle database servers (particularly exadata - engineered systems)
  • Easy to define source and destination data attributes and configuration
  • Robust error reporting
Likelihood to Recommend
Oracle database data replication is very straightforward but still a bit too complicated to configure (versus an out-of-the-box, easy-to-configure data replication tool). Oracle GoldenGate is advertised as being able to replicate data between different database products (vendors) as well as different versions of the space database product (so Oracle 11g replicated to Oracle 12c). Given that it's complicated to configure for Oracle database to Oracle database (same version), I'm sure any of the other advertised configurations are more complicated. These complexities make Oracle GoldenGate a difficult sell internally. It needs to be more straightforward and out of the box to configure and utilize.

GoldenGate is best for real-time data needs.

Rating: 10 out of 10
Incentivized
December 04, 2019
JL
João Leal
Oracle Services Engineer
TAP (Aviation & Aerospace, 10,001+ employees)
Vetted Review
Verified User
Oracle GoldenGate
3 years of experience
View profile
Use Cases and Deployment Scope
It's used by our Computer Services Department to create reporting databases as well as for DR. The replication is unidirectional and replicates data in four non-production environments. This enables us to perform long-running queries without affecting the performance of our production systems. We have a lot of clients using it. It can migrate data between databases in realtime.
Pros and Cons
  • Flexibility to migrate data.
  • Fast transactions between source and target databases .
  • Easy to analyze problems when occur.
  • Good for disaster recovery and data protection database.
Likelihood to Recommend
If you want to migrate databases quickly or put some schemas from the production, quality, or testing databases, you can use GoldenGate (but it is expensive). I only use it for Oracle Source and Oracle Target databases.

The Golden Gate to Success!

Rating: 8 out of 10
Incentivized
October 07, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
2 years of experience
Use Cases and Deployment Scope
Oracle GoldenGate is being used by our core software development team. We are using it as a real-time data replication solution to achieve high availability/disaster recovery for our data, to prepare a read-replica database to offload query-based requests, and to perform real-time business intelligence related operations on our synced data.
Pros and Cons
  • No Downtime during System Migration. Replicating data onto other servers in preparation for a system migration does not result in any downtime.
  • Initial setup of Oracle GoldenGate is easy and straightforward. Instructions are precise and simple to follow.
  • Thorough and Insightful Documentation. All troubleshooting and tuning issues are well-known by the community, and hence are well-documented online.
Likelihood to Recommend
Oracle GoldenGate is well-suited for Enterprise-level companies which require mission-critical security and performance along with their real-time data replication needs. Oracle GoldenGate integrates well with other Oracle products as well such as: Oracle Fusion Middleware, Oracle Veridata, Oracle XStream, and Oracle Active Guard. If you plan to use Oracle's products with your data replication workflow, Oracle GoldenGate is the way to go.

GG is great for what it is, but be aware of its limitations

Rating: 6 out of 10
Incentivized
September 18, 2019
ST
Serge Trikur
Sr System Admin
PGE (Utilities, 1001-5000 employees)
Vetted Review
Verified User
Oracle GoldenGate
2 years of experience
Use Cases and Deployment Scope
We use GoldenGate to sync up data from our customer and care system to Oracle Analytics Database
Pros and Cons
  • When it works, it works great
Likelihood to Recommend
The product works well in normal circumstances but fails to deliver when some flexablity is required. For example when syncing source to target it works really well, but when you reverse the process the system can be a bit buggy.

Oracle Golden Gate implementation at courier services

Rating: 8 out of 10
Incentivized
September 18, 2019
bs
budhi setyawan
consultant
TIKI JNE (Logistics and Supply Chain, 5001-10,000 employees)
Vetted Review
Verified User
Oracle GoldenGate
5 years of experience
Use Cases and Deployment Scope
We use it for our core system to support our main database for courier services. The core system is used by all of the operations and sales teams, as well as the Board of Directors. All of the transactions should be backed up and maintained in our backup servers as well as our disaster recovery. We use GoldenGate to replicate our database.
Pros and Cons
  • Oracle GoldenGate has been able to replicate all of our data in different servers and locations.
  • It also supports large databases
  • It supports a high volume of daily transactions of our sales.
Likelihood to Recommend
GoldenGate is the best software to replicate main databases for backup and for disaster recovery. It will not be suitable for interconnected systems that are based on messaging.

Oracle GoldenGate Review

Rating: 7 out of 10
Incentivized
September 17, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
5 years of experience
Use Cases and Deployment Scope
GoldenGate is being used as a DR solution and as well as a method for replicating from a transactional to reporting DB. It is used across the whole organization. It addresses a need for disaster recovery on different data centers including the cloud.
Pros and Cons
  • Replication of data.
  • Easy of set up.
  • Notification of status.
Likelihood to Recommend
It is well-suited for disaster recovery. It is less appropriate for time-sensitive data replication.

GoldenGate for active applications across datacenters

Rating: 8 out of 10
Incentivized
September 17, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
10 years of experience
Use Cases and Deployment Scope
We use Oracle GoldenGate for multiple reasons such as data replication, to maintain active/active databases for critical applications and not but least for database migration with zero downtime. We're happy with the usage and its purposes. It is being used across the whole organization. We use OEM monitoring to alert the monitoring team when there is a lag on the DB sync.
Pros and Cons
  • Data replication to keep our data up-to-date and used for reporting purposes.
  • Data migration with zero downtime.
  • Data sync between two data centers to keep the system active/active with load balancing.
Likelihood to Recommend
Oracle GoldenGate is well suited for active applications to maintain high availability of applications across the data centers.

Oracle GoldenGate - The best logical replication tool in the market.

Rating: 10 out of 10
Incentivized
September 17, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
12 years of experience
Use Cases and Deployment Scope
Oracle GoldenGate is used widely across the organization. We use it for heterogeneous replication, active-active and active hot standby, and offloading reporting.
Pros and Cons
  • Oracle's new AutoCDR (conflict detection and resolution) feature makes setting up active-active replication fairly easy. We were able to setup active-active replication using the AutoCDR feature in a very short time.
  • We had plans for separating reporting and ingestion from our primary DW system. This system generates an excess of 1TB of redo during ingestion. GoldenGates coordinated replicate helped us achieve this almost impossible task with ease.
  • In my previous workplace, for a large telecom company, we had to publish data from the store of records as a service. We used GoldenGate BigData adapters to replicate data to a Kafka endpoint.
  • For quick application failovers, we use GoldenGate Active-Passive replication with connection failover defined in the WebLogic connection settings.
Likelihood to Recommend
Oracle GoldenGate is extremely useful for heterogenous replication and active-active replications.
I have been able to replicate data between Oracle and targets such as TeraData, JMS queue, TIBCO EMS, Kafka, Hbase and Cassandra very easily. GoldenGate is one of the best logical replication product available in the market today, and with the latest innovations, it is only getting better.

Though we were able to set it up, when the source is a DataWarehouse with a lot of large transactions and heavy redo generation in a short amount of time, GoldenGate is not the best product of choice.

GoldenGate Rocks

Rating: 10 out of 10
Incentivized
September 17, 2019
Verified User
Vetted Review
Reseller
Oracle GoldenGate
6 years of experience
Use Cases and Deployment Scope
We use it to move data between databases to a dw for reporting purposes. We also use it to transform data as it moves, and we use it to populate pdb's to enable our services architecture.
Pros and Cons
  • GoldenGate, using CDC, moves data between databases and database technologies to enable near real-time propagation.
  • GoldenGate can transform data as it moves from tables in the same or different databases.
  • GoldenGate can move data between database platforms.
Likelihood to Recommend
It's well suited for moving data logically from database to database to allow near real-time reporting. It's not as well suited for unusual data types.

The best replication tool on the market

Rating: 10 out of 10
Incentivized
September 16, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
9 years of experience
Use Cases and Deployment Scope
We use GoldenGate to replicate some of the data from the production database to a data warehouse. It is used by the IT department. By using GoldenGate we don't impact the production database. We can run queries or reports or any long queries from the replicated database using GoldenGate. At one time we even used GoldenGate as a DR database and replicated entire production database. By doing so, one time when we had an outage and lost the production database, this DR became available to us and switched it to the primary. So we have a lot of advantages when using GoldenGate. We can replicate some tables or all tables and different scenarios of replicating data using functions and triggers. The business problem it addressed was less impact on production databases, more realtime data available to the business without putting an overload on production databases.
Pros and Cons
  • Realtime replication and zero data loss.
  • Less lag and more reliable.
  • No downtime for our primary database.
Likelihood to Recommend
It is well suited for a DR database and reporting purposes.

Synchronize your data with ease

Rating: 8 out of 10
Incentivized
September 16, 2019
Mh
Mohamad habba
Technology channels manager
Magrabi Retails (Retail, 501-1000 employees)
Vetted Review
Verified User
Oracle GoldenGate
2 years of experience
Use Cases and Deployment Scope
We are using OGG to synchronize our UAT/Production database with Oracle Cloud. The set up is being done by administrators and used only by the channels manager and administrator. One of the problems we found is the product cost, specifically after moving from Oracle Classic to OCI. In addition, we didn't find clear documentation to describe what we exactly can do with sequences synchronization. The user interface is another product and we have to purchase it to be able to monitor GG performance and issues.
Pros and Cons
  • Initiating integration and configuring source and target is easy.
  • Easy integration with different types of DB.
  • Availability to synchronize specific tables/DB schemas.
Likelihood to Recommend
It is one of the best products to use to synchronize databases of all different types.

Sr. Database Engineer

Rating: 8 out of 10
Incentivized
September 16, 2019
AK
Anuj Kumar
Senior Database Engineer
LinkedIn (Internet, 10,001+ employees)
Vetted Review
Verified User
Oracle GoldenGate
5 years of experience
View profile
Use Cases and Deployment Scope
We have multiple data centers and all of them share the same copy of DB. We use GoldenGate to do cross datacenters replication for Oracle and My SQL DBs as an HA solution. As our DBs are one of the busiest in the world and have a very tight SLA for replication lag which we can achieve by GoldenGate. We have explored few other products like SharePlex but GG done the work for us. GoldenGate is a de-facto standard for replication in our organization.
Pros and Cons
  • GoldenGate is tightly integrated with Oracle databases and supports all features like encryption, LOBs, compressions etc.
  • GoldenGate is very flexible, you can customize it as per your requirement. Whether it is high transaction DB or a DR site, it can work anywhere.
  • We can dump data in multiple formats with big data adaptor like kafka, hdfs, xml etc.
  • We can achieve high throughput by splitting extracts and replicats. Also from integrated capture and replication it is so smart that it spawn parallel process based on the load.
  • Goldengate is very useful in cross platform migration.
Likelihood to Recommend
Very well suited for Oracle database bi-directional replications. Excellent tool for dumping Oracle data to other sources like NoSQL, XML, HDFs etc. Setting up replication is easy and quick. Within no time we can start dumping data to other sources. Also CDR rules are easy to configure in active-active replication. It is very useful in case of zero downtime migration where DB size is huge, also we can utilize it in database upgrades.

GoldenGate for building data pipelines

Rating: 10 out of 10
Incentivized
September 16, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
3 years of experience
Use Cases and Deployment Scope
We have built a data change pipeline using GG technology by plugging in Kafka in front. Also, it's helped us in fault tolerance as a live DR database is readily available in a separate DC in case current DC goes down. In both modes, it's been super helpful to ensure data is sent in an async manner to reporting systems. It's saved us in cases of DC failures.
Pros and Cons
  • Data replication in real-time.
  • Fault tolerance.
  • No data loss.
Likelihood to Recommend
It has helped us in fault tolerance, as a live DR database is readily available in a separate DC in case the current DC goes down. This saves us in the case of data center failures.

GoldenGate Replication

Rating: 10 out of 10
Incentivized
September 16, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
3 years of experience
Use Cases and Deployment Scope
It is being used by an existing product in one of the business units which supports the payment platform. We are also planning to use it for a new application pipeline which is currently under development using bi-directional replication.
Pros and Cons
  • The unidirectional and bidirectional capability of data replication.
  • Data quality assurance including both DDL & DML replication.
  • Validation and data quality measurement facility available through Veridata.
  • Also helps in zero downtime based migration.
Likelihood to Recommend
GoldenGate is easy to integrate and manage with a low learning curve and administrative efforts. We had a platform requirement where we had to basically decide to go with an application that is supporting bidirectional replication or we do go through available tools in the market. Since we had some other available vendor who supports this feature we found the data quality validation a unique feature and went with this tool.

GoldenGate product review

Rating: 8 out of 10
Incentivized
September 16, 2019
Verified User
Vetted Review
Verified User
Oracle GoldenGate
1 year of experience
Use Cases and Deployment Scope
This is one of our DB products that are used for replication. I have used GoldenGate in the past before Oracle, and this product, though with its faults, is still one of the industry leaders. This product is used across banking, credit cards, CFO and Insurance LOB's.
Pros and Cons
  • Ease of use
  • Support from Oracle on the product
  • Business presence and reputation
Likelihood to Recommend
Well suited for large data replication.

Great Replication Solution for Heterogeneous database solutions.

Rating: 10 out of 10
Incentivized
March 28, 2019
RG
Ravi Gupta
Information Technology Architect
Los Angeles County Office of Education (Education Management, 1001-5000 employees)
Vetted Review
Verified User
Oracle GoldenGate
9 years of experience
View profile
Use Cases and Deployment Scope
We have been using Oracle GoldenGate (OGG) for our replication needs. We have a mix of database environments including Oracle, DB2 and Microsoft SQL Server. We use Oracle GoldenGate to replicate across the mix of these different RDBMS. OGG is reliable, fast, has high throughput and allows heterogeneous replication.

We also use OGG Management Pack which is an extra license cost and includes Oracle GoldenGate Monitor, Oracle GoldenGate Director and Oracle GoldenGate Veridata.
Pros and Cons
  • Supports both homogeneous and heterogeneous replications.
  • Supports DDL replication if both source and target databases are Oracle.
  • Supports multiple replication topology such as unidirectional, bi-directional, cascading, peer to peer and multicasting.
  • Can interface with JMS and Big Data Systems.
Likelihood to Recommend
We have been very impressed by Oracle GoldenGate and would recommend it for any RDBMS replication needs.

Oracle GoldenGate: Continuous and Real-time data movement

Rating: 8 out of 10
Incentivized
December 21, 2018
Verified User
Vetted Review
Verified User
Oracle GoldenGate
1 year of experience
Use Cases and Deployment Scope
Oracle GoldenGate is used by organization, which provides high availability and real-time data integration solutions. To be specific, the company needs a platform that allows business applications to benefit from continuous access to real-time information in a diverse IT environment without compromising performance.
Pros and Cons
  • It provides continuous capture and delivery of data from source to target due to its real-time data feed feature.
  • It maintains the reliability and accuracy of transactional data.
  • It is very easy to install.
  • Complete data recovery is possible in case of failures.
Likelihood to Recommend
We use Oracle GoldenGate with some monitoring tools to improve its availability, performance, accessibility, and integration of critical data across the enterprise.

Goldengate for active-active data replication

Rating: 8 out of 10
Incentivized
December 06, 2018
Verified User
Vetted Review
Verified User
Oracle GoldenGate
5 years of experience
Use Cases and Deployment Scope
Goldengate is being used for production replication for an active-active application that is critical to business needs.
Pros and Cons
  • Active-active replication
  • Simple setup
  • Reliable transactional replication
  • Great support
Likelihood to Recommend
Good for simple transactions but distributed for complex multi-site distributed transactions; careful set up is required.
Return to navigation