Oracle GoldenGate

3.7
(23)

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.

Work for Oracle GoldenGate?

Learning about Oracle?

We can help you find the solution that fits you best.

Find the Right Product

Compare Oracle GoldenGate to Similar Solutions

Oracle GoldenGate Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 23 Oracle reviews
LinkedIn Connections
Oracle review by Casey G.
Casey G.
Validated Reviewer
Review Source
content

"Pros & Cons of Oracle"

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.

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.

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.

What business 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.

Sign in to G2 Crowd to see what your connections have to say about Oracle GoldenGate
Oracle review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source
content

"Undoubtedly the best database replication solution in market"

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.

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.

Recommendations to others considering the product

It is especially worth the buck if you have large infrastructure environments and have complex replication needs.

What business 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.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
Oracle review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Review Source
content

"Overly Complicated"

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.

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.

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.

What business 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.

Oracle review by Administrator in Government Administration
Administrator in Government Administration
Validated Reviewer
Review Source
content

"Flexible and real-time replication"

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

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.

What business 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.

Oracle review by tanner c.
tanner c.
Validated Reviewer
Review Source
content

"Does the job well, some configuration issues on our end"

What do you like best?

Seems to handle data replication in near real time, don't have very many issues with it.

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.

Recommendations to others considering the product

Take the time to set the configuration up correctly

What business 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.

Oracle review by Jack  M.
Jack M.
Validated Reviewer
Verified Current User
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Oracle GoldenGate"

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.

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.

What business 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.

Oracle review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"smooth and easy"

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.

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

What business 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.

Oracle review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source
content

"Oracle GoldenGate Review - Great tool"

What do you like best?

Great tool for replication. I often used it for real time integration of data. Like that it supports cloud environment. Also very scalable.

What do you dislike?

Well just feel a little complex after excessive exploring and use over time. But that could be the case of all the softwares so no complaints there.

Recommendations to others considering the product

Go for it. I would recommend that go for the training that is provided by Oracle before using this tool. Will help use the software to its fullest potential which would often be more than what you need.

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

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.

Oracle review by W. Daniel B.
W. Daniel B.
Validated Reviewer
Review Source
content

"Good product but requires experts to run properly"

What do you like best?

Enables many to one replication, one to one replication, etc. Provides proper logical replication and fills the gaps that Active data guard leaves.

What do you dislike?

Without knowledgeable DBAs and DB Devs GoldenGate can quickly become unruly and broken. Care must be taken to ensure all changes to the database carefully consider their impact on GoldenGate tables that are replicated.

Recommendations to others considering the product

Ensure you have DBAs and DB Devs that are well versed in GoldenGate before proceeding.

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

Whereas ActiveDataguard is a viable solution for consistent data replication between like databases, GoldenGate can be used to replicate between dissimilar SQL databases.

Oracle review by Tearra D.
Tearra D.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Review "

What do you like best?

Great way to make the data visualizations for meetings.

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.

What business 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.

Oracle review by Administrator
Administrator
Validated Reviewer
Review Source
content

"Golden Gate "

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.

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.

What business 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.

Oracle review by Administrator
Administrator
Validated Reviewer
Review Source
content

"Amazing data replication tool"

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.

What do you dislike?

Configuration is complex, specially for two way replicas.

Expensive

Support it´s not always helpfull with issues.

Recommendations to others considering the product

ask an expert, it´s a complex product and starting withount knowledge could be fatal.

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

Data replication

Data transformation

Oracle review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Best tool for replicating data for migrations from another DBMS"

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.

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

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

transferring data from large 11g database to 12c database. Zero downtime migration.

Oracle review by Industry Analyst / Tech Writer in Consumer Services
Industry Analyst / Tech Writer in Consumer Services
Validated Reviewer
Review Source
content

"Oracle GoldenGate analyst"

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

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

What business 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

Oracle review by Executive Sponsor
Executive Sponsor
Validated Reviewer
Review Source
content

"Golden Gate Replication"

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.

What do you dislike?

Oracle is not recommending Golden Gate for failover and are promotion Active Data Guard.

What business 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.

Oracle review by Administrator
Administrator
Validated Reviewer
Review Source
content

"oracle goldengate replication review"

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

What do you dislike?

1. lack of GUI administration pool

2. ggsci can't manage goldengate remotely

3. help is hard to use

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

bi-directional replication and active-active application configuration

Oracle review by Administrator
Administrator
Validated Reviewer
Review Source
content

"Oracle Golden Gate"

What do you like best?

very easy to use, very easy installation, very easy troubleshooting and easy to diagnose.

What do you dislike?

i don't like to sync when database is out of sync. We have to comment the tables in relication.

What business 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

Oracle review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Review Source
content

"Golden Gate review"

What do you like best?

Bi directional replication makes DBA life easy

What do you dislike?

GG replication is only for DB's, should be across file and folders

Recommendations to others considering the product

GoldenGate give you a very good insight on how replication works across RDBMS technologies

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

DR solution is achieved using OGG

Oracle review by Consultant
Consultant
Validated Reviewer
Review Source
content

"Great product"

What do you like best?

I would say 80% user friendly and has a capability of less human made errors.

What do you dislike?

Display and search options could be made better

Recommendations to others considering the product

So far I had great experience with Oracle, I would definitely recommend.

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

Account reconciliations and postings

Oracle review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source
content

"Oracle Golden Gate"

What do you like best?

Can replicate from any data source or to any target.

What do you dislike?

Licensing cost is high. More key words to learn. High learning curve.

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

Replicating data

Oracle review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source
content

"Oracle GoldenGate Review"

What do you like best?

simple and intuitive. Great product for AIX to Linux Migrations.

What do you dislike?

Bugs in 11.2 version. Command line interface could be better.

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

AIX to Linux migration. Time Stamp conversion to local to UTC

Oracle review by User
User
Validated Reviewer
Review Source
content

"Data entry and security"

What do you like best?

My place of employment utilizes this and it works for our needs.

What do you dislike?

My employers says this helps with our client's confidentiality of their business.

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

The security of our clients/business.

Oracle review by Administrator in Internet
Administrator in Internet
Validated Reviewer
Review Source
content

"Goldengate"

What do you like best?

Integrated capture and Integrated replay are good

What do you dislike?

Lots of bugs with xml formatting when used for xml publishing

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

Multimaster

Kate from G2 Crowd

Learning about Oracle GoldenGate?

I can help.
* We monitor all Oracle GoldenGate reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.

Compare Oracle GoldenGate to Similar Solutions