Oracle GoldenGate Reviews and Ratings

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.

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.

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>

Likelihood to Recommend

<p>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. </p><p>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.</p><p>[Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.</p>

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.

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.

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.

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.

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.

Likelihood to Recommend

<ul><li>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)</li><li>when you want to replicate the entire database between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)</li><li>when you want to replicate the specific tables between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)</li><li>when you want to replicate the data set between Homogeneous (Oracle to Oracle) and Heterogeneous databases ex. Oracle to SQL Server (not similar databases)</li><li>when you want to create Read-Only databases </li><li>when you want to create two master database - using bidirectional databases</li></ul>

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.

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.

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.

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.

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.

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.

Use Cases and Deployment Scope

We use GoldenGate to sync up data from our customer and care system to Oracle Analytics Database

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.

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.

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.