GoldenGate: the bridge to somewhere
June 13, 2018

GoldenGate: the bridge to somewhere

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle GoldenGate

It is used by our Computer Services Department to create reporting databases as well as for DR. The replication of the transactional data in a non-production environment enables us to perform long running queries without affecting the performance of our production systems. We also use the product to create DR environments in our remote locations.

Pros

  • Transactional integrity between the source and target. This is extremely important as anyone would imagine when talking about a DR target.
  • High-performance capability. There is no impact on the production side of the environment.
  • There is support for one to many topologies such that one source can be used to create multiple targets.

Cons

  • The earlier versions of Golden Gate were complex to use as there was no front end. All that works was the command line.
  • The cost of the product can be a detriment to most companies.
  • The product has been augmented over the years and has so many features that it can be overwhelming.
  • 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).
I don't believe that there is a product that can match the capabilities of Oracle GoldenGate. As I stated earlier, it has so many use cases because of the ability of the product to handle the logical transformation of data from source to target. It can be used for DR but that is not the most useful feature as data guard do this much cheaper. Creation of data warehouses and reporting databases are a major strength of the product.
It is particularly useful in situations where ACTIVE DATA GUARD cannot handle the desired outcome. It can be used to support cross-platform migrations not supported by Active Data Guard which is a far cheaper solution to DR. It is suited for migrations that require zero downtime as there is bi-directional capability built into the product. It is also useful when the source and target are of different databases such as Oracle to SQL Server as the target. It is overkill if all you require is a physical standby that is open read-only.

Oracle GoldenGate Feature Ratings

Comments

More Reviews of Oracle GoldenGate