Oracle GoldenGate

We just passed our BCP simulation with flying colors

Positive impact as we have [been] able to maintain high performance transactions while offloading reports and still being able to provide the reports in a timely manner to clients

On a project level, by allowing us to begin our data conversion process 12 hours earlier, we are able to save in off-time losses and increase customer satisfaction, as we will be on line a whole half day earlier.

By being able to replicate data to cheaper performing resources, we are able to save money by not having to duplicate the costs of our main resources.

GG knowledge is somewhat specialized, so it does require a human resource(s) to be employed that knows how to maintain it. This is not a full time job, but it is absolutely necessary.

Oracle GoldenGate guarantees our standing-by database in passive data center, is always in "pre-warmed" status, as the data is always in-sync with the master database in our active data center. At any time, the standing-by database can kick in in case the active DC encounters the serious issue. This significantly increases the IT application's high availability and promise to "business as usual".

We were able to cut down many development hours creating integrating points to a production database.

Able to generate production data to QA databases for testing.

OGG can be used for the database migration

OGG can be used for database replication

OGG can be used for data integration

OGG is expensive (negative)

OGG is cost due to hire SME or expert

Using Oracle GoldenGate for modifying data transformation as it replicates, this is very key if you need your data to appear a certain way, especially important in reporting.

GoldenGate also allows us to have the data visualizations that helps management at meetings to see what is happening at a higher level.

We wanted zero downtime for our business and both sites need to be active active.

Positive--no separate licensing from Oracle database products or engineered systems, so no extra cost

Negative--too complex to become fully adopted as the de facto data replication tool

Negative--too difficult to support, so tool-specific specialists are required to handle configuration and support

It's a good investment for your company if you want to migrate fast, but there are a lot of bugs/limitations.

As Oracle GoldenGate integrated well with the Oracle products we were already using, we didn't need to spend additional time and money to purchase or develop an integration solution.

XStream and Active Data Guard licenses come free with Oracle GoldenGate, reducing overhead costs.

Eliminated the need to scale our workstations up in terms of hardware resources. Creating read-replicas to offload read requests gave more opportunities to scale horizontally.

because our stack is mostly Oracle we didn't really explore other products outside of the Oracle umbrella

It make it easier to manage and back up our main database

GoldenGate helps make it faster in terms of solving technical problems related to preparing inter-department reports.

It helps us be more efficient in terms of using manpower to handle our database

ROI has been positive to our business.

High availability of critical applications through data sync across datacenters.

Reporting database in real-time replication.

We were able to provide a completely partitioned highly available active-active environment to allow for our critical application to stay continuously available.

For our critical data warehouse, which is required to generate compliance reports for the government, we were able to offload a heavy reporting workload to a different database using GoldenGate, which helped us generate our compliance reports in time.

This allowed us to offload our reporting workload to an open database on a cluster otherwise used for DR. This enables a huge cost saving on Oracle CPU licensing and improved performance for our ERP environment.

Very positive impact and good ROI in the past years we've been using it.

Product cost is high, however, we can see it is an excellent product.

GoldenGate is really helpful is providing HA solution where we can sync data between data centers and distribute load between them. In case of a site down we can redirect all connections to surviving DC.

Most of the time the delay of Oracle GoldenGate replication is within seconds.

We can do database upgrade without interrupting site availability.

Saved business in case of hardware failures.

Saved efforts to manually create scripts to pull data from the source into reporting systems.

Not sure

It has had a positive to impact as a simple way to move data to our data warehouse.

Positive impact for vendors that use our products as GoldenGate is a reliable name in replication.

Easy to find employees with GoldenGate experience.

Time to go live was [reduced] as scripts and configuration files were reusable across environments.

Day to day administration is easy and convenient. This reduces database/application downtime.

Robust data security

Dynamic rollback

reliable replication in active-active application

data migration without downtime