Oracle GoldenGate Reviews & Product Details

Oracle GoldenGate Overview

What is Oracle GoldenGate?

Oracle GoldenGate (on-premises & Cloud Service) products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables: -Real-time business intelligence and stream analytics for improved business insight -Query offloading to maximize OLTP performance -Zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability Link - https://www.oracle.com/middleware/data-integration/goldengate/resources.html Datasheet - https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf Datasheet (Stream Analytics) - https://www.oracle.com/us/products/middleware/data-integration/oracle-stream-analytics-ds-4478221.pdf Analyst whitepaper - https://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-ds-2030490.pdf

Oracle GoldenGate Details
Languages Supported
English
Product Description

Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.


Seller Details
Seller
Oracle
Ownership
NYSE:ORCL
Company Website
Phone
+1 (650) 506-7000
Year Founded
1977
HQ Location
Redwood Shores, CA
Total Revenue (USD mm)
$39,506
Twitter
@Oracle
778,474 Twitter followers
LinkedIn® Page
www.linkedin.com
186,456 employees on LinkedIn®
Description

Oracle Corporation develops, manufactures, markets, hosts, and supports database and middleware software, applications software, and hardware systems.

Show More
Answer a few questions to help the Oracle GoldenGate community
Have you used Oracle GoldenGate before?
Yes

Oracle GoldenGate Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 28 Oracle reviews
Popular Mentions
Showing 28 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Region
Already have Oracle GoldenGate?
Write a Review
Senior Database Administrator
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Its robust and powerful and can do transformations on the go. It can be monitored with OEM too so we can create tickets too Review collected by and hosted on G2.com.

What do you dislike?

Its robust and powerful and can do transformations on the go. It can be monitored with OEM too so we can create tickets too Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Creating a data lake and that hels bussiness doing the calculations on the compressed data like the parquet format Review collected by and hosted on G2.com.

Show More
Show Less
Program consultant
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

We like the replication of the database. It works better then dataguard Review collected by and hosted on G2.com.

What do you dislike?

It is too expensive. We don't deploy Golden gate as much as data guard Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It works well, but it is expensive. It also depends on the work load. preferably large Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

It solves our disaster recovery. The recovery works well Review collected by and hosted on G2.com.

Show More
Show Less
AM
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Very Easy to use. Goldengate can be used to minimize downtime where we need to move large amount of database about 100TB between Solaris & Linux Review collected by and hosted on G2.com.

What do you dislike?

There should be easy way to do whole database copy and hide all complexity behind the scene e.g. migrate database from Solaris to Linux Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Replication and Platform Migration. Minimize downtime Review collected by and hosted on G2.com.

Show More
Show Less
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

It is a very handy product thats very useful to stream data out of RDBMS databases Review collected by and hosted on G2.com.

What do you dislike?

Its majorly command line oriented. It will be great to have a UI for managing it Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are trying to integrate data from multiple platforms Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

It has helped us with creating reporting environments. Review collected by and hosted on G2.com.

What do you dislike?

We have had some issues with bugs in the past. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are creating reporting databases off our primary databases. This allows reporting to be kept off our primary databases. Review collected by and hosted on G2.com.

Show More
Show Less
Marketing
Marketing and Advertising
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

How it keeps track of past changes and hoe all data is saved in specific spots. It stores all data you could ever need for products and has the capability to changes all different aspects of products for our site. I like that each department throughout our company can make and save changes so we are all contributing. Review collected by and hosted on G2.com.

What do you dislike?

The functionality is outdated. It's complicated trying to make changes; sometimes changes are not allowed and I have to completely exit the oracle application and go back in to make changes. The design is not appealing and looks outdated as well. Sometimes it can be hard to navigate and know where certain information is held. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is not the easiest functionality wise. I would say it is old school, but it definitely gets the job done correctly. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

When costs, prices, shipping prices, other specific SKU information needs to be changed, we can make those changes in Oracle in bulk or individually. It's nice to see who made changes and when the changes were implemented for our products. Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I have been using Oracle GoldenGate since 2011, right 2 years 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. Review collected by and hosted on G2.com.

What do you dislike?

I am an Oracle GoldenGate fan, so it's hard to say what i dislike about it. But yes, i would have loved if it was easier to find syntax errors in your GoldenGate commands. Sometimes it just tells you ambiguous generic error messages for a syntax error. Although, with experience on working with OGG, you can easily overcome with this slight drawback. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is especially worth the buck if you have large infrastructure environments and have complex replication needs. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

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. Review collected by and hosted on G2.com.

Show More
Show Less
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Seems to handle data replication in near real time, don't have very many issues with it. Review collected by and hosted on G2.com.

What do you dislike?

This is probably a lack of understanding on our part, but there are some configurations that we could have set up better. Currently the whole replication fails if a table is changed, or DDL statements are ran on the source tables. We do that fairly often, and it makes it so that we have to involve the DBA team for any of these cose migrations. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Take the time to set the configuration up correctly Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Replicating data from a source database to a target database. This works well for that purpose. Review collected by and hosted on G2.com.

Show More
Show Less
UM
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It got the job done, so that was at least alright. I was able to find what I needed, but it took longer than I think it needed to. The system was navigable, but not until I had training on it. Before that I was clueless on how to find anything. Review collected by and hosted on G2.com.

What do you dislike?

It was more complicated than it needed to be. Without the training I feel that it isn't intuitive. I think maybe the structure should be reinvented so that it is more intuitive. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Make sure to go through the training they provide. Otherwise you will be confused. Their training is helpful and so is customer support. With training I could manipulate the program the way I needed. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have been able to solve company wide purchasing through this program. Everyone is able to place their individual orders and be billed directly to their purchase centers. Having it done through this program, everyone can place their department's individual orders, it can go to it's respective locations, and be correctly billed. So much easier than past products. Review collected by and hosted on G2.com.

Show More
Show Less
AG
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It allows the replication in REAL TIME from the Oracle database in RAC to the contingency database, through the immediate replication of the data in the REDO LOGS, without the need to wait for them to be written at the level of the ARCHIVE LOGS.

It allows me to granularly replicate specific tables Review collected by and hosted on G2.com.

What do you dislike?

In our experience it is important to check that the database is prepared to proceed with the replication through OGG.

Pay special attention to the types of data that are not supported, because if the tables use them they will not be replicated, besides there must be a good database design model with their respective primary and foreign key relationships, it is not recommended handle the logic of the relationships between the tables only at the level of the application. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Golden Gate helps us to keep a replica of the database consistent, in real time, which is used for reportage in read only mode, in this way we manage to reduce the load of the production database, redirecting all the generation of reports to the contingency site, leaving all the processing capacity available for the provision of services of the productive applications. Review collected by and hosted on G2.com.

Show More
Show Less
UF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

the ease of access of the application on a day to day at work. Whenever I had an issue there was many templates online that helped me when I had a question. High performance and no impact on the production towards the environment. Review collected by and hosted on G2.com.

What do you dislike?

My dislikes really go in to the effect of the cost it bears to companies which is pricey. Though I can look how to use many features online. I found that many features have been added to which it can be very overwhelming. The earlier versions were very complex but I will say this version is much more user friendly Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

It can be used to support cross platform migrations not supported by Active Data Guard which is much cheaper. I also like that it requires zero downtime. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Accountant
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

You can have multiple different data sources coming into this Oracle GoldenGate. You are not limited to only Oracle databases. Review collected by and hosted on G2.com.

What do you dislike?

The time that it takes to implement Oracle GoldenGate. Because you can have multiple databases going through it it can take a long time to set it up. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The problem that Oracle GoldenGate is solving is the fact that you can run multiple different databases through one system. Review collected by and hosted on G2.com.

Show More
Show Less
AC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

We use golden gate to replicate data throughout our datacenter for reporting, upgrade, and failover instances. Along with Veridata it provides a rock solid syncronous replication solution for us. Review collected by and hosted on G2.com.

What do you dislike?

We're really interested in automation of the configuration of new instances and tables using golden gate. the manual setup can be complex. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

WE're able to copy and syncronize only the subset of data needed from each database to support specific business goals -gg is best in class for this purpose. Review collected by and hosted on G2.com.

Show More
Show Less
AD
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

The best part about Golden gate is seamless replication. very easy to set up and configure. Works fast and gets all committed transactions to target database from source database. Saves time and money and reduces migration window to minimal downtime. Review collected by and hosted on G2.com.

What do you dislike?

expensive license and happy that company pays for it. Also it is not as fast as dataguard, conflict resolution is complex Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

transferring data from large 11g database to 12c database. Zero downtime migration. Review collected by and hosted on G2.com.

Show More
Show Less
ASL Teacher
Telecommunications
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Great way to make the data visualizations for meetings. Review collected by and hosted on G2.com.

What do you dislike?

Still learning so I feel like it’s is complex to use the program. Wish there’s a steps where I can follow. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

To have the data visualizations that helps the staff at meetings to see what is happening. Review collected by and hosted on G2.com.

Show More
Show Less
EA
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

It works. We did a proof of concept with Golden Gate for our EBS failover and found the replication satisfying. Review collected by and hosted on G2.com.

What do you dislike?

Oracle is not recommending Golden Gate for failover and are promotion Active Data Guard. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are trying to solve a replication method for our EBS and Non-EBS databases with it. We found it to be replicating fine. Review collected by and hosted on G2.com.

Show More
Show Less
IC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Ease of access when trying to locate data that you need to replicate, or copy to another folder or project. My boss loves this program Review collected by and hosted on G2.com.

What do you dislike?

Would like more features, perhaps the ability to copy a project and work on a separate aspect of that same project and save it to a different folder Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Simple to use, easy access to previously uploaded information, ability to replicate data into another folder simply, for alternative use Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

1. easy to install and configure

2. easy to user shell scripts to monitor and manage goldegate

3. flexible

4. lots of features for performance tuning Review collected by and hosted on G2.com.

What do you dislike?

1. lack of GUI administration pool

2. ggsci can't manage goldengate remotely

3. help is hard to use Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

bi-directional replication and active-active application configuration Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

very easy to use, very easy installation, very easy troubleshooting and easy to diagnose. Review collected by and hosted on G2.com.

What do you dislike?

i don't like to sync when database is out of sync. We have to comment the tables in relication. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we want zero downtime for our business and both sites need to be active active Review collected by and hosted on G2.com.

Show More
Show Less
AF
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Bi directional replication makes DBA life easy Review collected by and hosted on G2.com.

What do you dislike?

GG replication is only for DB's, should be across file and folders Review collected by and hosted on G2.com.

Recommendations to others considering the product:

GoldenGate give you a very good insight on how replication works across RDBMS technologies Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

DR solution is achieved using OGG Review collected by and hosted on G2.com.

Show More
Show Less
AP
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Goldengate is a powerful data replication tool, it integrates with almost any database.

Goldengate replication is almost realtime for oracle database, being able to capture data capturing chages from the redo logs.

Goldengate can hadle two way replicatiom even many to many replication with colision handling. Review collected by and hosted on G2.com.

What do you dislike?

Configuration is complex, specially for two way replicas.

Expensive

Support it´s not always helpfull with issues. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

ask an expert, it´s a complex product and starting withount knowledge could be fatal. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data replication

Data transformation Review collected by and hosted on G2.com.

Show More
Show Less
AH
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

simple and intuitive. Great product for AIX to Linux Migrations. Review collected by and hosted on G2.com.

What do you dislike?

Bugs in 11.2 version. Command line interface could be better. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

AIX to Linux migration. Time Stamp conversion to local to UTC Review collected by and hosted on G2.com.

Show More
Show Less
CC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I would say 80% user friendly and has a capability of less human made errors. Review collected by and hosted on G2.com.

What do you dislike?

Display and search options could be made better Review collected by and hosted on G2.com.

Recommendations to others considering the product:

So far I had great experience with Oracle, I would definitely recommend. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Account reconciliations and postings Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: G2 Gives Campaign
What do you like best?

Integrated capture and Integrated replay are good Review collected by and hosted on G2.com.

What do you dislike?

Lots of bugs with xml formatting when used for xml publishing Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Multimaster Review collected by and hosted on G2.com.

Show More
Show Less
UA
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

My place of employment utilizes this and it works for our needs. Review collected by and hosted on G2.com.

What do you dislike?

My employers says this helps with our client's confidentiality of their business. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The security of our clients/business. Review collected by and hosted on G2.com.

Show More
Show Less