Oracle GoldenGate

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.

We are using this application to replicate data from one data center to other data center. And it's very accurate and it's solved our data issues during the down time the replication helped not loosing of business and with little impact to customer for check out and creating profiles

We are using Oracle GoldenGate for many databases ranging from ERP databases, standalone database, etc.,

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.

I have been using Oracle GoldenGate since 2011, 2 years right after Oracle acquired the company. It was an awesome project back then with version 10, but Oracle has continued adding tonnes of features to it ever since and this is just the best replication solution I have worked with. I have done all kinds of replication using Oracle GoldenGate. Be it homogeneous, heterogeneous, unidirectional, bidirectional, on premise, on cloud (Oracle Public Cloud), integrating with JMS (Java Messaging System) - we have done it all. We have loved the product so much that we have over years replaced all our existing replication infrastructure using Oracle GoldenGate. I love that you can perform changes in almost zero downtime, replicate millions of data in sub seconds and their is large online documentations and forums to help you with troubleshooting any problems. This doesn't requires a lot of expertise to begin with and overtime, you will love working on it. Oracle GoldenGate now also comes with many GUI based tools like OGG Studio, OGG Director, OGG Monitor and OGG Veridata. These come with additional cost, but are great add-ons. We implemented Oracle GoldenGate on at least 400 database environments. We have a large infrastructure with tonnes 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.

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.

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.

We use Oracle databases as the primary data storage facility for our university. We have many ERP products that need to integrate with custom applications designed to support our IT infrastructure. We decided to use Oracle GoldenGate as a means of keeping data in sync between our ERP system and a temporary data-cache. It offers real-time replication of data between different database systems.

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.

We use GoldenGate for migrations purposes as well as ad-hoc purposes for one of our critical business applications.

We are using Oracle GoldenGate to replicate data between data centers.

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.

We use Oracle Goldengate to move data from our Oracle 12c database to Postgres where it is extracted by another utility for ETL.

We are using GoldenGate as an HA solution. We find GoldenGade better than Oracle Data Guard in terms of HA. Our application is up and running on a primary and DR site and we can switch to the DR site within 1 minute. We are having quite a very big GoldenGate footprint of around 10000+ GoldenGate processes setup. GoldenGate is quite beneficial in terms of HA and cost of ownership.

At a previous job, bi-directional Oracle GoldenGate replication was used to support a highly available application model. It was used across the whole IT DBA organization. At my current position Oracle GoldenGate is being used in a uni-directional manner to replicate data from 10 different application databases to an ERP platform that is used for our enterprise reporting needs, this also helps in offloading the reporting from the application databases.