Oracle GoldenGate

It increases the data integration speed.

Negative impact is that due to many DDL changes on the source side, we need a lot of time to maintain GoldenGate to manually resync.

GoldenGate has saved us from penalties by providing 99.999% uptime.

DR drills are very fast due to active architecture using GoldenGate.

We need to pay for additionals licenses for GoldenGate but for Data Guard we don't have to pay for and additional license.

Cost cutting

More reliability

Able to handle another data center without any hiccups

Faster replication.

Handling the configurations is difficult and Monitoring the GoldenGate is harder.

The database upgrade and migration was possible with zero downtime because of having GoldenGate in place. So, it saved a lot for not having any downtime.

Oracle GoldenGate, being an Oracle tool, is slightly on the expensive side compared to similar tools offered by vendors like Dell.

We still chose to replace all our existing replication infrastructure with Oracle GoldenGate for the ease of implementation and sophisticated features very well apt for our complex business requirements.

Our customers have been extremely satisfied with our GoldenGate implementations.

It has enabled us to create non-Oracle environments with data captured via the Oracle database.

We can guarantee zero downtime because of the bi-directional capability of the product.

We can use the product to go from a higher version of the Oracle Data Base to an earlier version (11g to 10g).

In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.

But both issues are solved now.

Installation is straightforward, easy.

Deployed everything within Oracle Data Integrator.

Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.

Management Pack and VeriData are additional packs for your management and data verification needs.

We found this product really useful since it allowed us to keep two different data stores in sync.

It freed us from conducting expansive querying of our live data base, and instead just using the data-cache store instead.

Decreased sync times by 75% helping protect business interests.

Cost is an impact to expense budget.

Future use of syncing to no SQL databases will help speed up processing by 50% or more based on tests and allow us to do a migration. Off the relational DB over time.

Positive is a near zero time cutover for migrations

Lots of failures on the replication, we have to shutdown [our] site as the replication cannot catch up.

It's a single product that can connect to multiple types of databases, so the learning curve will be smaller and can help your organization standardize on your reporting platform.

It serves our business needs of having a "single source of truth".

Real-time replication means more up-to-the-minute reporting. There are certain reports that the users want more than just having last night's data.

The ROI has come from the etl after GoldenGate moves the data to Postgres but it has been useful and positive in moving the data.

Good ROI. GoldenGate licensing is quite competitive.

Increased Availability. Through using Oracle GoldenGate we were able to completely eliminate customer experienced downtime when applying patches and upgrades to our databases. This led to a increase in our availability numbers company wide for database. The key though was architecting our applications to allow them to work in a multi-site fashion that allowed us to leverage Oracle GoldenGate for this.

Being able to move data/processes off of the main application databases to put less strain on those resources. Being able to replicate data from 11 Application DBs to one ERP DB running on Exadata has increased performance on the application databases as they no longer needed to have a report run against them. It also allowed us to create new reports for our customers which has many times over paid for our investment in Oracle GoldenGate.