Oracle GoldenGate

Oracle GoldenGate Reviews

Do you work for this company? Learn how we help vendors

Ratings and Reviews
(1-25 of 213)

Companies can't remove reviews or game the system. Here's why
Gene Baker | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Replication
  • Business Continuity
  • Query offloading
  • Requires a specialized skillset
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.
  • Partner-led
Score 8 out of 10
Vetted Review
Verified User
Review Source
<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>
  • 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).
  • GG can sometimes lag behind in synching large objects (i.e. CLOBs and BLOBs) on tables, which is odd because we are using GG on an Oracle database with an Oracle software suite. It's definitely possible to use GG on non-LOB columns, and we do, but it is best used for non-LOB columns, just based on personal experience.
  • When using GG, it is key to separate the replicat groups into manageable sizes. This can be somewhat burdensome, as maintenance will increase with each new replicat group. If tables are large enough, they need to essentially be their own group.
  • Sometimes, replicat groups need to be grouped by parent and child (if using in a normalized db). This again increases maintenance due to more groups existing. This will be especially true for large tables that are partitioned with foreign key constraints on child tables.

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.

  • In-house
Alejandro Pineda | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Oracle GoldenGate 19c in our critical business databases, to replicate the databases between datacenter from different cities. This is a part of our business continuity program. We use asynchronous replication since is a big amount of data that have to travel through the network specially from our data warehouse database.
  • Synchronous data replication.
  • Asynchronous data replication.
  • Configuration of time replication.
  • When you activate the synchronous replication the performance of the server goes down.
  • The pricing is expensive.
  • The configuration take some time to be done.
  • The compression ratio of the data that travels through network could be better.
Oracle GoldenGate is excellent when you need a high availability infrastructure and you need a contingency plan in case of disaster, or [if you] just need a backup of your main databases in a different data center.
It is less appropriate is cases [where] you just need a backup of your database. In that case, you should look [for an]other solution that can help you.
  • In-house
Jacob Biguvu | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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
  • Expensive
  • Require resources such as OGG script developer and SME
  • 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
  • In-house
December 08, 2020

OGG - always in-sync

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • The metrics UI is another product that should be purchased separately, with high price, we use open source Grafana as a replacement.
  • Documentation can be improved. Sometimes [it is] not so easy to find the correct information quickly.
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.
  • In-house
Score 8 out of 10
Vetted Review
Verified User
Review Source
Currently [Oracle] GoldenGate is being used to replicate a backup database for disaster recovery and also integrating different data sources to a single database.
  • Documentation is easy to follow
  • Downtime seems very minimal
  • Able replicate in real-time
  • Expensive, considering we were going to use Active Data Guard.
  • A lot of memory is being used.
  • No UI
If you need to integrate many data sources together, [Oracle] GoldenGate is well suited to easily do that while maintaining data integrity.
  • In-house
December 04, 2020

Oracle GoldenGate Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • The time that it takes to implement Oracle GoldenGate. Because you can have multiple databases going through it it can take a long time to set it up.
  • It was more complicated than it needed to be. Without the training I feel that it isn't intuitive. I think maybe the structure should be reinvented so that it is more intuitive.
  • GoldenGate replication is only for databases, it would be nice to use it across file and folders
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.
No
Score 7 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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
  • More integration with traditional Oracle products such as SQL*plus
  • GUI
  • More transparent integration with OEM
  • More standard error reporting similar to traditional Oracle products
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.
  • In-house
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • In certain cases, we consider how well GoldenGate is able to help us interconnect our main database directly to our backup system (we use actifio for it).
  • We have some difficulties to cut-off our size of main database, so maybe Oracle GoldenGate could make it easier by providing a function to shrink our data safely.
  • We also interconnected with our partners to share some data, specific and limited fields only, through third party services, using messaging system (ISO 8583, XML and JSON). It would be great if GoldenGate also provided such a function.
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.
  • In-house
  • Partner-led
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • Initiating integration and configuring source and target is easy.
  • Easy integration with different types of DB.
  • Availability to synchronize specific tables/DB schemas.
  • No clear documentation for some points like sequence synchronization.
It is one of the best products to use to synchronize databases of all different types.
  • Partner-led
September 16, 2019

Sr. Database Engineer

Anuj Kumar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • Memory consumption of extract is exponentially high, sometimes extract restart consumes so much memory that it impact the current application connections.
  • There are so many bugs in the system for dumping data via xml or other format like hdfs. Data corruption is so frequent that we wrote our own scripts to detect and repair xml corruption. As always we didn't get proper support from Oracle on this issue.
  • For active-active replication on busy systems, online DDL change can sometimes cause data discrepancy.
  • With integrated capture creating index on big table is a headache even thought you are creating with via gg user. Extract starts get lagging even after skipping the DDL by gg user in param file. This was not the case with classic capture.
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.
  • In-house
Yes
I am a member of the India OAUG.

There are many meetups organized by Oracle GoldenGate developers and users. At least every quarter there will be one hosted in one of the customer sites where people share their experience and feedback on the use of Oracle GoldenGate. Also I have attended IOUG conference where you can discuss issues and new features.
João Leal | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • Oracle GoldenGate Studio is expensive, and you can use Grafana instead.
  • Character set problems when migrating database.
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.
  • In-house
Score 6 out of 10
Vetted Review
Verified User
Review Source
We use GoldenGate to sync up data from our customer and care system to Oracle Analytics Database
  • When it works, it works great
  • Whenever we have to do a data subset from prod to lower environments its almost impossible for GG to find its checkpoint... we had lots of difficulty with restarting GG process after the refresh.
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.
  • In-house
  • Partner-led
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • Like most Oracle products, it is quite expensive.
  • Too many tables in single replication channels creates performance bottlenecks. You have to split your tables into multiple channels.
We have been very impressed by Oracle GoldenGate and would recommend it for any RDBMS replication needs.
No
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is used by IT to sync data across databases. The source is our SQL Server database and the target is the Oracle database. The source database is outsourced to a third party and we use GoldenGate to sync the data to our local Oracle database. The main challenge we have is that GoldenGate can't replicate DDL among different RDBMS. We have had to stop and rebuild GoldenGate multiple times due to DDL change on the source side.
  • Real Time Sync
  • Less overhead
  • Stable performance
  • Should make the high availability easier to use. Not bound to only DBFS or ACFS.
  • Need a powerful GUI tool to make the configuration easier.
  • Could it be cheaper? Or have a basic free version?
  • If it could support DDL among different RDBMS, that would be great.
Well-suited to work between Oracle databases. I worked before at Bank of America and there we used this to replicate from Oracle database to Oracle database. We just replicate the whole schema and enable DDL replication. It is really convenient. Another good example is to use it for zero downtime upgrades. I also believe the active-active is very useful, but haven't tried yet.
Not yet, but I'm interested in Oracle user groups
I am not a member of a user group yet. May join in the future. Currently I am considering join both Oracle and MySQL groups to get updated with the most recent technologies. I am also interested on how Oracle and MySQL could be connected through GoldenGate. Since they are both from Oracle, I assume GoldenGate should be better integrated between them.
A S M Omar Faruq | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Oracle GoldenGate as a part of our high availability solution. The entire database is replicated in real time to other geographical facilities and makes the system available for 24/7.
  • GoldenGate is good for real-time data replication.
  • The database upgrade and migration was possible with zero downtime because of having GoldenGate in place.
  • It also works with different databases other than Oracle
  • The monitoring side could be improved with easy to use reporting.
One of many use cases is, GoldenGate can be used in an active-active database configuration, meaning, both source and destination databases can be operational in a bi-directional fashion.
No
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Replicated source system data seamlessly flew in our Operational Data Store (ODS). Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication. With the upgrade, I now am able to replicate Big Data solution from any supported source system to Hadoop clusters.
  • Ease of installation
  • Ease of maintenance
  • Powerful output with sub-second speed
  • Supporting Big Data and Cloud environment
  • Capturing source data based on transnational log, no cost on source CPU
  • Handle the distribution and the delivery of committed data in real-time
  • Supports heterogeneous systems regarding target or source database
  • Can be implemented uni-directional, bi-directional or peer-to-peer mode
  • Zero downtime migration
  • Supports data distribution
  • Can be used for disaster recovery or data protection
  • Oracle GoldenGate Studio could be more user-friendly.
  • It would be better for Oracle Golden Gate Studio GUI to include other OGG related licensed products (i.e. Veridata or others).

  • Capture data based on transaction log
  • Handle the distribution and the delivery of committed data in real-time
  • Supports heterogeneous systems both in source or target database
  • It can work in uni-directional, bi-directional or peer-to-peer mode
  • It has a sub-second speed
  • Low impact on source and target systems
  • Platform independent universal data formatEasy to deploy - simple configuration of parameter files
  • Conflict detection and resolution
  • Supports data encryption
Yes
I am a member of the Independent Oracle User Group, ODTUG, Colombia Oracle Users Group, Costa Rica Oracle Users Group, Ecuador Oracle User Group, Grupo de Usuarios Oracle El Salvadore, Oracle User Group Guatemala, Oracle User Group Mexico, Panama Oracle User Group, Azerbeidzjan Oracle User Group, Bulgarian Oracle User Group, Oracle Gebruikersclub Holland, Oracle User Group Finland, Oracle User Group Norway, Romanian Oracle User Group, Slovenian Oracle User Group SIOUG, Spain Oracle User Group, TROUG Turkish Oracle User Group, UK Oracle User Group and All India Oracle User Group.

I am presenting in various Oracle User Groups worldwide and share my expertise with Oracle Golden Gate in many of my sessions.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have been successfully using Goldengate to sync our prod and disaster recovery environments for over a year. It decreased the time to sync and increased reliability. We are very happy with it.
  • Disaster recovery sync, faster than other products like SharePlex.
  • Integration features, we are looking at using it to sync other DBs and move data around.
  • Future use case is to offload data to Cassandra.
  • Ability to help migrate between different versions of Oracle could be improved.
  • Possible compression of data to help with transfers across data centers.
  • Cost is a little high.
Disaster recovery is the best need for us.
Mahesh Jonnalagadda | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use GoldenGate for migrations purposes as well as ad-hoc purposes for one of our critical business applications.
  • Migrations
  • Ad-hoc reporting which avoids prod performance in peak business hours
  • Lot of bugs need to be nailed down
  • Some missing functionalities
Migrations and reporting
Johnny Wu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We're in a data warehousing project where we need to replicate from multiple source/intermediary systems (MS SQL Servers and Sybase) into Oracle as our reporting platform. GoldenGate fulfilled our needs of having a reliable means of extracting live data from multiple heterogeneous databases and feed into an EDW. In that sense, it's an invaluable tool for the report writers and business analysts across the organization. There are some hiccups here and there, mostly having to do with some data transformations and certain long transactions, but overall, it performs reliably well and better than other alternative replication products we're tried.
  • GoldenGate can handle multiple database vendors (SQL Server, Sybase, DB2, Enscribe, etc.) and replicate data in real-time.
  • It's flexible and can perform data transformation/cleansing on the fly when you provide the mapping file for it. Exceptionally good error handling and data collision handling. Over some years, we have some large tables with 10 million records or more, and have seen only a very few records missing/incorrect.
  • Good support responses. GoldenGate was well-supported when it was an independent company, and even though Oracle acquired it, it still has a good support organization.
  • It's expensive. And I believe you have to purchase a license for each type of source and/or target DB that you're trying to replicate.
  • It will be slow for a single transaction that updates a large number of rows. It's better to break up such transactions into batches and run them in a loop with periodic commits (Batch Insert or Batch Update).
  • It's buggy when reading SQL Server transaction logs; may cause an abend.
It's good for replicating sources on multiple RDBMS into one or more targets' databases. It can read from online transaction logs and backups. Also it's good for performing certain ETL-type transformations so you [can] standardize your data in a reporting/staging area.

It's not good for the sole purpose of disaster recovery. You have better options (DataGuard and/or storage disk replication) for that.
richard shen | TrustRadius Reviewer
Score 1 out of 10
Vetted Review
Verified User
Review Source
We are using Oracle GoldenGate to replicate data between data centers.
  • It supports multiple data sources including IBM/Oracle/Microsoft
  • Natively supports Oracle, but not DB2
  • Has the flexibility for CDR
  • No GUI
  • Hard to manage
  • Lots of BUGS on IBM DB2, does not even support timestamp on extract
  • Performance is BAD on IBM DB2 for replication
  • Trail file has bad data sometimes
  • Hard to refresh table for IBM DB2
  • Production support is very slow and bad
Oracle to Oracle is a good choice, but not for DB2 to DB2.
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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.
  • Lack of Simple UI for Non-Technical Users. It would be nice to have an option to toggle simpler, and less advanced options to make it easier for non-technical users to understand what Oracle GoldenGate is.
  • Lack of Variety of Performance Metrics. Would prefer more detailed performance metrics to be offered out-of-the-box.
  • Some Features Won't Always Run as Expected. We have sometimes faced issues when features don't run as they are used to. They will be working at times, but there is the occasional failure in streaming.
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.
  • In-house
Score 10 out of 10
Vetted Review
Verified User
Review Source
Oracle GoldenGate is used widely across the organization. We use it for heterogeneous replication, active-active and active hot standby, and offloading reporting.
  • 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.
  • There are certain challenges using the product when the redo generation is in excess of about 120G per hour.
  • For large transaction (more than 10 million records per commit), extract get slower. Some other replication tools do such activities better.
  • Ability to recreate large transaction without breaking the transaction into individual statements may help. There are ways to make this transaction faster, but having the ability to replicate a statement as it was issued on the source may be helpful in some cases.
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.
  • In-house
September 17, 2019

GoldenGate Rocks

Score 10 out of 10
Vetted Review
Reseller
Review Source
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.
  • 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.
  • We need more rapid support for bug mitigation.
  • GoldenGate's API needs to allow for streaming from Oracle's cloud databases where we don't have access to the OS.
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.
  • In-house
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • Realtime replication and zero data loss.
  • Less lag and more reliable.
  • No downtime for our primary database.
  • GUI could use a little improvement.
It is well suited for a DR database and reporting purposes.
  • In-house

Oracle GoldenGate Scorecard Summary

Feature Scorecard Summary

Data Source Connection (2)
85%
8.5
Connect to traditional data sources (42)
92%
9.2
Connecto to Big Data and NoSQL (24)
79%
7.9
Data Transformations (2)
81%
8.1
Simple transformations (37)
93%
9.3
Complex transformations (33)
69%
6.9
Data Modeling (6)
80%
8.0
Data model creation (25)
87%
8.7
Metadata management (26)
84%
8.4
Business rules and workflow (27)
82%
8.2
Collaboration (22)
80%
8.0
Testing and debugging (30)
77%
7.7
feature 1 (5)
70%
7.0
Data Governance (2)
77%
7.7
Integration with data quality tools (27)
75%
7.5
Integration with MDM tools (21)
78%
7.8

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 Downloadables

Oracle GoldenGate Integrations

Oracle GoldenGate Competitors

Oracle GoldenGate Pricing

More Pricing Information

More pricing information from Oracle GoldenGate

SaaS Editions Pricing
Pricing DetailsTerms
Data Integration$250.00Per License

Oracle GoldenGate Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

What is Oracle GoldenGate?

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

What is Oracle GoldenGate's best feature?

Reviewers rate Simple transformations highest, with a score of 9.3.

Who uses Oracle GoldenGate?

The most common users of Oracle GoldenGate are from Enterprises and the Information Technology & Services industry.