GoldenGate: the bridge to somewhere
Anonymous | TrustRadius Reviewer
June 13, 2018

GoldenGate: the bridge to somewhere

Score 8 out of 10
Vetted Review
Verified User
Review Source

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.
  • 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.
  • 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).
Yes - I am a member of the Northern Ohio Oracle Applications Users Group.

We were able to attend the OAUG conferences to speak with other user companies that implemented the product. We were able to obtain invaluable advice from people who had already performed the installation and setups. We also use the group as a means of professional development for our employees. Many of them present at conferences and get recognized by their peers.
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

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations