We just raised a $30M Series A: Read our story

Oracle GoldenGate OverviewUNIXBusinessApplication

Oracle GoldenGate is the #13 ranked solution in our list of top Data Integration Tools. It is most often compared to AWS Database Migration Service: Oracle GoldenGate vs AWS Database Migration Service

What is Oracle GoldenGate?
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.

Oracle GoldenGate is also known as GoldenGate.

Oracle GoldenGate Buyer's Guide

Download the Oracle GoldenGate Buyer's Guide including reviews and more. Updated: October 2021

Oracle GoldenGate Customers
Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
Oracle GoldenGate Video

Archived Oracle GoldenGate Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Amro Mourad
Senior Oracle Database Admin at mrcc
Real User
Powerful solution that centralizes our data and has a user-friendly interface

Pros and Cons

  • "This is a powerful solution provided by one of the most respected companies in the computer industry."
  • "Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."

What is our primary use case?

The areas we use for this product for is centralizing the collection of hospital data. In Saudi Arabia there are five special hospitals and each branch there is a local facility for data entry. Users enter data in the local database in their branches and the data is collected in a centralized database that is also in Saudi Arabia. These tools use criteria to identify cases that are similar in different hospital branches to help in diagnosis and treatment.

I am working on this project to serve as the administrator for the database. Before this, I joined a lot of projects, sometimes part-time, in Cairo and I gained 18 years of experience working on databases in the maritime ports in Arab countries and in hospitals in Arab countries, in Cairo, in Egypt, in Iraq, in parts of Spain and around the Arabian Sea. My primary responsibility is to make centralized data available.

What is most valuable?

I signed with Oracle to use GoldenGate for this project five months ago. I needed two or three months just to explore GoldenGate to get to know it and the features. There are many awesome features in GoldenGate and from what I see in the case studies, I need some more months of discovery to know what I think are the most valuable features. If you call me a month from now, I will be able to answer the question as to which of the excellent features are the most valuable. Right now it would be that I have confidence that GoldenGate can handle this extensive project.

What needs improvement?

I use an on-premises installation of GoldenGate — a standard GoldenGate installation — to do our test deployment for our projects. Part of the Oracle solution that needs some improvement is the ability to test features extensively before purchase and deployment. I am from Egypt and the economy is not so good. To create proper test environments for complex enterprise deployments is very expensive. Right now there is no place in Egypt that has enough servers to provide a proper test environment for a large deployment like the one we have planned. I do my best to do the test here with what I have.

It is a poor model to test all the GoldenGate features in an improper environment because a valid test of the features of GoldenGate may require a huge investment in accessories like memory and processors. I still need to do the testing. I need to write the code to test out the deployment without a proper environment and without using some features that may be valuable in achieving our goals. I am going to join a project to perform testing with Oracle Exadata in hopes to have free equipment to test this with. In this way, I hope to have a good enough environment to test the product. The project will be huge will be much larger in the future.

It could be that I will find I need to test out the cloud as a potential solution. I think I need one month or two months to decide what is the solution. But assistance from Oracle in temporary testing facilities would be useful and create the opportunity for investment.

For how long have I used the solution?

We have been using the product for about five months.

How are customer service and technical support?

I have a lot of experience with Oracle technical support. The technical support in Egypt is not responsive. When I have encountered issues they waste time in gathering unnecessary information. They send me a program, to export some files so they can look into the problem. This is a big waste of time and an unnecessary delay.

One or two days they are saying they are working on this case. While they are doing this I do my best to solve the problem on my own and search the Oracle Mechanic and Google. I raise the severity to the top, and nothing happens faster. The user suffers the consequence of inefficient support. I spent money on support and on my own I find out this issue is already a known issue and I apply the solution myself before they get back to me. They have the price I paid for support, and I provide my own solutions.

How was the initial setup?

I think that the installation of this product is very straightforward. I am sure I will encounter some problems and other issues because I installed a sample configuration of GoldenGate. This is a sample project where I have installed a huge database. It gives me the opportunity to encounter some problems and issues. I hope that I do not see any problems, but I am pretty sure I will experience some things that will go wrong.

The installation of Oracle's GoldenGate is fairly different from other similar applications. It is straightforward but at the same time more difficult. I think that is partly because other solutions will have about one-quarter of the features when compared to GoldenGate.

What about the implementation team?

I have completed the installations myself.

What's my experience with pricing, setup cost, and licensing?

The pricing is done on a yearly basis. They have additional packages for technical support.

Which other solutions did I evaluate?

I have had the opportunity to use many products working for 18 years with databases. The list would be long if I tried to name the other products that I worked with. For this project, I suggested directly going to use Oracle products to create a solution because my experience says that it is the best way to do it. With some solutions, it would only be possible to join two modems at the maximum. We needed something more robust and to me, it was obvious that out of everything Oracle was the best.

What other advice do I have?

My opinion of GoldenGate is that it is an improvement over earlier Oracle products. I think that the interface for GoldenGate is very user-friendly. I recommend that people support the use of Oracle GoldenGate and have made this opinion known to colleagues in Egypt who are responsible for team projects.

On a scale from one to ten — one being the worst and ten being the best — I would grade  Oracle GoldenGate as a nine right now. After one or two more months working with the product, maybe the nine would be ten. It could be ten right now because I haven't faced any problems. This tool and Oracle's reputation speak for themselves. I don't need to complicate the issues by involving and a big problem I had in the past. But if I need a real reason why it should not be a ten and a nine is justified, I need Oracle to improve its support in Egypt. This is a genuine issue that is ongoing.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Osama Mohei
Consultant at National Water Company
Consultant
A stable solution that can integrate heterogenic systems

Pros and Cons

  • "The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
  • "The solution, in general, should be easier to use, with less need to perform workarounds within the system."

What is our primary use case?

Right now we use GoldenGate adapt tools to integrate the Oracle database with Microsoft DataPoint. We also use GoldenGate for CDB and as a sophisticated feature for auditing on records and to help with records capture by GoldenGate. 

What is most valuable?

GoldenGate is a perfect product. It's very stable and can integrate heterogenic systems. I believe GoldenGate is one of the best Oracle products.

What needs improvement?

Monitoring needs improvement. Right now we lose a lot of of time and effort. To have a real monitoring system is the most important thing. If you replicate between systems 24/7, you need a strong monitoring tool. It's not taken from a lot of effort and a lot of support and involvement with Nexus adapters to plug into our Oracle enterprise manager. 

Scalability also needs to be addressed. There's not a straightforward way to handle it.

The solution, in general, should be easier to use, with less need to perform workarounds within the system.

For how long have I used the solution?

I've been using the solution for more than five years.

What do I think about the stability of the solution?

It's a very stable product because of its processing ability. If we have any issues, Oracle resolves them quickly. I appreciate Oracle support. It ensures GoldenGate offers a stable service.

What do I think about the scalability of the solution?

Scalability is a challenge. I believe this area also needs more effort. If I need to set up GoldenGate on high availability deployment, we have to do a lot of workarounds. High levels of scalability are a challenge. It's not straightforward. 

How are customer service and technical support?

Oracle technical support in GoldenGate is not the same as Oracle support for their Azure database. Usually, we try to handle it ourselves because if we have to call, it might take three or four days and still not be handled correctly.

How was the initial setup?

The initial setup is straightforward. It doesn't take too much time or effort to implement the solution.

What other advice do I have?

I would rate this solution around eight or nine out of ten. The solution is extremely stable.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,267 professionals have used our research since 2012.
MZ
Solutions Architect Manager at a tech services company with 51-200 employees
Real User
Good data replication capabilities, but integration and technical support need to be improved

Pros and Cons

  • "When we are replicating data between similar databases then it is straightforward."
  • "The process of transforming the data between two different databases is inefficient and needs to be improved."

What is our primary use case?

We are a reseller, and we implement this solution for our clients. They are generally either government or financial institutions. These clients use other Oracle technologies for tasks such as identity management and business intelligence. This solution is used to replicate the data for purposes such as disaster recovery and high availability.

What is most valuable?

The most valuable feature of this solution is data replication. When we are replicating data between similar databases then it is straightforward.

What needs improvement?

We are having a challenge in that we want to replicate different types of data, from one database to another, that have different types of elements. The process of transforming the data between two different databases is inefficient and needs to be improved.

Technical support for this solution could be improved.

The integration is not straightforward and should be made simpler.

For how long have I used the solution?

We have been using this solution for two years.

What do I think about the stability of the solution?

This solution is stable and we aren't facing any issues.

What do I think about the scalability of the solution?

Scalability of this solution depends on the licensing from Oracle.

How are customer service and technical support?

We have had trouble with the Oracle technical support. When we need them to reply to us, we need to open a 24/7 ticket. If we open a critical ticket instead, then nobody replies and it takes a lot of time. Consequently, whenever we are facing an issue and we need to open a Service Request (SR), we use the 24/7 support. This leads to three people working in parallel to resolve our problem. Otherwise, we will not get a resolution.

How was the initial setup?

The initial setup of this solution is straightforward. For the installation, you need only follow the steps in the documentation.

What's my experience with pricing, setup cost, and licensing?

There are a lot of tricks when it comes to licensing.

What other advice do I have?

This is a good solution for data replication, but there are some areas that need to be improved.

I would rate this solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
Nafise Mohammadbeigi
Data Analyst & BI Specialist at ABS LBS
Real User
Fast and efficient replication between central and local repositories

Pros and Cons

  • "This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
  • "I find the user interface to be difficult for non-technical people."

What is our primary use case?

We implement this solution for our customers, and our most recent deployment was for a client in France. The solution involved one central database and ten replicas that were distributed to the local offices. The central database is automatically updated as the replicas are changed, and similarly, when the central database is modified, each of the local copies is updated accordingly.

How has it helped my organization?

Using this solution has improved both the speed and efficiency of the data replication process. Prior to this, I used packages with merge functionality for replication. The process was very slow, and sometimes had negative effects on the production database. This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.

What is most valuable?

The most valuable feature is the CDC (Changed Data Capture), which captures only the changes that are made to the data. This has the lowest load on the production database, and it runs very quickly in the background.

Reading directly from the log file makes updating the databases very fast.

What needs improvement?

I find the user interface to be difficult for non-technical people. It was suggested to me that I use the command prompt, which is fine for me because I am a technical person. However, when showing others, such as managers, how to use the product to provide details such as the system status, it is a bit difficult.

The inclusion of monitoring and management tools would be very nice.

The Oracle documentation is very complex, and some of the documents are very long. I prefer to use sites that are on the topic of Oracle, but in fact, are not run by Oracle itself.

In our experience, there is zero technical support for this solution.

For how long have I used the solution?

Between four and five years.

What do I think about the stability of the solution?

This is a very stable solution, and I haven't had any problem with the tools.

What do I think about the scalability of the solution?

This solution scales easily. It's dependent on the files and configuration, and you can do anything you want.

This solution is being used on a daily basis. We have approximately one thousand users on the production database, including both developers and end-users. We do have plans to increase our usage, although the interface for monitoring and managing becomes difficult to use when it grows to a certain point.

How are customer service and technical support?

I have contacted technical support, but could not get any support. I would say that the support is zero.

Which solution did I use previously and why did I switch?

Prior to this solution, we had a package that used an SQL process. It had come from Oracle Scheduler. We switched because it negatively impacted our production database, making it very slow. If there was downtime and the production database had transactions then it would take days to recover from the lag.

How was the initial setup?

The initial setup of this solution is of medium difficulty. It is not straightforward; however, it is not as complex as it looks.

For a single deployment that has two sites, I would expect the process to take less than two hours, although it depends on the complexity of the replication.

An example of a more complicated configuration is where only a subset of the tables are being replicated, and the flow of data is different in both directions. Setting this up can take a very long time, and incur a large cost because of coding time.

We have three people to manage and maintain this solution. This includes making changes to the database. For the monitoring and altering, one person is sufficient and it will not take one hundred percent of their time.

What about the implementation team?

We handled the implementation of this solution in-house.

What's my experience with pricing, setup cost, and licensing?

We do like the price of this solution.

Which other solutions did I evaluate?

We did not evaluate other options when we chose this solution, although I am now considering other tools.

What other advice do I have?

This solution is priced well, is fast, and doesn't have any impact on our production database.

I would rate this solution and eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
AE
Head of Data Management Team at Saudi Telecom Company
Real User
Easy to maintain, flexible, and scales with our environment

Pros and Cons

  • "This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
  • "Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."

What is our primary use case?

Our primary use for this solution is the replication of data between heterogeneous environments to implement a data hub. We use this for reporting purposes or to publish data to the various systems (acquire and publish technique) using multiple technologies and multiple platforms. They are typically Oracle DBs on Oracle platforms, with some different types of databases, like Teradata, and also sourcing data into Hadoop Big Data.

How has it helped my organization?

This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation. There is minimal effort required for maintenance, which would be performed by non-dedicated DBA.

What is most valuable?

The most valuable feature of this solution is its compatibility with Oracle DB and Oracle products, generally, as our environment is really dependant on them.

The flexibility for customization as well as the scalability of the tool is very important, as we expand our environment we can expand and scale up the tool on the go.

What needs improvement?

The User Interface should be improved in newer versions, but without putting any restrictions on the customization capabilities. Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner.

The licensing model should be improved to be more cost-effective for the end users.

For how long have I used the solution?

Seven years.

How was the initial setup?

This solution is straightforward to implement with a hassle-free setup.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user809553
DBA
Real User
Transforms data in real-time from one database to many or from many to one

Pros and Cons

  • "You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."
  • "It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."

What is our primary use case?

The primary usage of the product is to transform data from one database to another, for an application.

How has it helped my organization?

If you have one environment that is for some application and it has a lot of data, and you need this information not only for the application but also for a warehouse - to do some analytics later - you just transform all that data to the warehouse and then you can work with it.

What is most valuable?

You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time. In my experience, it is able to transform a large amount of data within a few seconds.

What needs improvement?

I would like it to be simplified, easier to manage.

What do I think about the stability of the solution?

This is the tricky part. It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear.

Maybe they can simplify it. You learn the tool, you learn how to work with it. Now we have a very stable environment but it took like a few months until it became stable.

What do I think about the scalability of the solution?

You have scalability. If you have a database and you have all sorts of objects inside and you want to transform them, you can add more objects.

What other advice do I have?

I would recommend Oracle GoldenGate, of course.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Neil Chandler
Database Architect and Oracle ACE Director at Chandler Systems
Real User
Enables migration from system to system with no downtime at incredible speed

Pros and Cons

  • "It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."
  • "It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful."
  • "It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes."

    What is our primary use case?

    The primary use case, generally speaking, is either data migration or data loading from an OLTP system to a data warehouse. It's probably Oracle's primary product for migration to the cloud, to later migrate from on-premises into cloud with zero downtime.

    How has it helped my organization?

    It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers. Whether that's taking us from on-premise to the cloud or whether that's just going from server to server, either on-premise or within the cloud itself, it's an excellent solution.

    What is most valuable?

    It's the simplicity. It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful.

    What do I think about the stability of the solution?

    It's extremely stable. It's one of the most stable products that I've ever used.

    What do I think about the scalability of the solution?

    It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes.

    Which solution did I use previously and why did I switch?

    This is a new solution for us. We did a proof of concept for all of the systems out there and discovered that, from a performance perspective, Golden Gate certainly met all of our requirements, which is not necessarily the case with some of the rivals out there.

    Oracle has implemented a slightly different technology. Instead of scraping the redo logs, the way the traditional replication of this type of system works, it's actually using a new technology, with its integrated Extracts and Replicats, to effectively use Oracle's streams to double the performance. It can literally run twice as fast as anybody else. We needed that to keep up with our transaction volumes.

    For me, the most important criteria when selecting a vendor is that it does the job.

    How was the initial setup?

    I've done the initial setup of Golden Gate for many clients. It's extremely straightforward. It's probably the simplest replication tool I've ever used.

    What's my experience with pricing, setup cost, and licensing?

    The one feature that I think Oracle could perhaps consider is, at the moment, the Veridata option is an extra cost. Golden Gate is an expensive product. You pay a lot for the best. But not including the Veridata license to prove that everything is working correctly... The big improvement for me would be to have that license built in. That would take it to the next level. That would make it a much better product.

    You may want to look at buying term licenses if you've just got a single migration to do. In that situation, you might want a term license for perhaps a year to save a lot of money, rather than buying a perpetual license.

    Which other solutions did I evaluate?

    Other vendors that we were looking at were Dbvisit Replicate and Continuant, although the latter didn't have a product ready at that time (they do now). And there was also VMware Shareplex.

    Those are the main rivals in the marketplace and, whilst they are substantially cheaper than Golden Gate, around a fifth of the price, they couldn't quite keep up with our transaction volumes.

    What other advice do I have?

    You've got to balance the cost with your requirements. You may find that using something like Dbvisit Replicate is good enough for what you are doing, and it is substantially cheaper. 

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    Gurcan Orhan
    Data Quality Software Development Manager at Yapı Kredi Bank
    Consultant
    Top 20
    Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.

    Pros and Cons

    • "Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
    • "It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."

    What is most valuable?

    Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).

    How has it helped my organization?

    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 can able to replicate Big Data solution from any supported source system to Hadoop clusters.

    What needs improvement?

    Oracle GoldenGate Studio could be more user-friendly.

    It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others).

    For how long have I used the solution?

    More than 5 years.

    What was my experience with deployment of the solution?

    No, if found Oracle Support and/or Oracle Community helped me a lot.

    What do I think about the stability of the solution?

    In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncate and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables

    But both issues are solved now.

    What do I think about the scalability of the solution?

    No.

    How are customer service and technical support?

    Customer Service:

    Created some service requests about GoldenGate years before, but all are solved.

    Technical Support:

    10 over 10.

    Which solution did I use previously and why did I switch?

    Quest Shareplex, because of licensing costs.

    How was the initial setup?

    Straightforward, easy. Deployed everything within Oracle Data Integrator.

    What about the implementation team?

    In-house and vendor, depending on the project.

    What was our ROI?

    Developing 1000 of ODI interfaces for loading into Operational Data Store will took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.

    What's my experience with pricing, setup cost, and licensing?

    No comment about pricing and licensing.

    Which other solutions did I evaluate?

    Yes, we switched from SharePlex of Quest Software.

    What other advice do I have?

    Oracle GoldenGate is a stable, powerful and robust solution for your data replication needs. It supports not only Oracle, but also many source and target systems to replicate.

    It now has the ability to work together with Oracle Enterprise Manager, as well as it has its own GUI (Oracle GoldenGate Studio).

    Management Pack and VeriData are additional packs for your management and data verification needs.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    it_user522123
    Technical Specialist at a healthcare company with 1,001-5,000 employees
    Vendor
    It replicates in real time between heterogeneous databases such as SQL Server, DB2, Oracle, Sybase.

    Valuable Features

    GoldenGate replicates in real time between heterogeneous databases such as SQL Server, DB2, Oracle, Sybase and others. In the next few years, we plan to use Oracle GoldenGate to real-time replicate to big data and the cloud.

    Room for Improvement

    Like everything else, it's getting complicated. I've been using it 15 years in the United States, which is probably at least the top one or two healthcare organizations in America, and it does quite an outstanding job. However, since GoldenGate was purchased by Oracle, it's become more challenging to work with. Obviously, Oracle is profitable but it's becoming quite tougher to work with.

    For healthcare databases, there are three leaders for what they call EMRs, electronic medical records: Epic, the market leader in the United States; and then Cerner and GE/IDX. Oracle GoldenGate real-time replicates between databases, but not Epic's database, which is called Caché. Oracle does not do that. If you can come up with a product that replicates in real time from Caché to any other database such as Oracle, DB2, or SQL Server, you'll never have to work again. If you want to make a mint, that’s one thing it could do; it's wide open for somebody to tap into.

    Use of Solution

    I have been using it for probably 15 years.

    Stability Issues

    Stability is outstanding, far superior to IBM and other competitors. Real time replication, that's the key.

    Scalability Issues

    It is quite scalable. They're investing into migrating to the cloud, big data, bi-directional – to and from – real-time replication, streaming, and others.

    Customer Service and Technical Support

    The support from Oracle could be improved; it is sometimes a challenge. Candidly, and quite anonymously, we sometimes know the product better than the Oracle technical support does. Unfortunately, there are some communication challenges as well; understanding American English.

    Other Advice

    I recommend buying the product. It performs outstanding. If you want to offload from your online transaction processing, your application, to an enterprise data warehouse, data lake, etc., this is far beyond a superior tool to the competitors. It's worth the price.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    ITCS user
    Solutions Developer at a music company with 51-200 employees
    Vendor
    We're able to use it for real-time ETL and implementation of zero-downtime migrations, but it needs a wizard for table replication.

    Valuable Features

    • Replication by SCN
    • Ability to perform basic data transformation/call user-defined functions
    • Exception handling
    • CDC capabilities when used with ODI

    Improvements to My Organization

    • Ability to implement zero-downtime migrations
    • Ability to scale horizontally
    • Ability to use ODI and Goldengate for real-time ETL

    Room for Improvement

    Current features:

    None

    New features:

    Offer basic process monitoring out-the-box

    Offer a (CLI) wizard for quickly creating and configuring (extract, pump, replicat) table replication

    Use of Solution

    3 years

    Deployment Issues

    Base versions where a bit buggy particularly during recovery after there were machine/host crashes or unexpected shutdowns. Latest patches/versions resolved these issues.

    Stability Issues

    Only in Windows were there a few GoldenGate crashes, but we suspect these were due to insufficient memory.

    Scalability Issues

    No, although we haven't applied parallelism to any of our processes yet.

    Customer Service and Technical Support

    Customer Service:

    Very good. I have often spoken directly with support personal and P1 issues are handled swiftly.

    Technical Support:

    Excellent for above P3.

    Initial Setup

    Straightforward

    Implementation Team

    Initially through a vendor, Michael Rainey from RittmanMead, and we were able to support the product on our own after that. Michael's level of expertise is very high.

    ROI

    Hard to calculate, but GoldenGate offers an excellent ROI if you use the product cleverly.

    Pricing, Setup Cost and Licensing

    NA

    Other Solutions Considered

    No

    Other Advice

    Reduce the price to compete with products like DBVisit because once customers see the power behind this product, they will be locked in forever.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    ITCS user
    Database Administrator at a tech services company with 51-200 employees
    Consultant
    Oracle GoldenGate vs. Oracle Active Dataguard
    As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication being the primary purpose of all the mentioned technologies, each have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA's must learn and understand the functionality of both and know which technique can be used and in what scenario. Let's discuss the differences between Oracle Active Dataguard and Oracle…

    As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication being the primary purpose of all the mentioned technologies, each have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA's must learn and understand the functionality of both and know which technique can be used and in what scenario.

    Let's discuss the differences between Oracle Active Dataguard and Oracle GoldenGate.

    Oracle Active Dataguard is simple and the most economical solution for replication. The concept of active dataguard is a super set of traditional dataguard. It offers real time data protection and availability. Here in active replication you can place your secondary database in read-only mode, where the secondary database is available to users for limited usage like reporting and query offloading. Active Dataguard promises zero data loss across large distances without hampering performance. Other benefits to count on you can consider the capability of Active Dataguard to automatically repair the physical corruption without incurring any performance impact and availability of the dedicated servers. Using special purpose network devices Active Dataguard ensure minimal bandwidth utilization. With Active Dataguard DBAs can reduce the planned downtime to much extent while migrating or upgrading databases.

    Oracle GoldenGate is the most advanced logical replication product from Oracle. This is especially well known for its cross-platform operating capabilities. GoldenGate provides a wide range of options addressing a number of customer replication needs. The basic principal is that it works up on is to capture online changes, distribute and deliver transactions across various secondary systems. The secondary database in this configuration which is available is read-write mode during replication and synchronizations, incurring additional overhead to maintain both database in same state. The beauty of GoldenGate lies in its capability to replicate the changes in heterogeneous IT environment taking into consideration all the components of IT along with various Database Management Systems. We can rely on the technology even in case of network outage between primary and secondary server located geographically at long distances. The recent release of product promises improved performance, reliability, consistency, conflict detections, data integrity etc.

    It is really important to understand the feasibility of a solution taking into consideration the financial aspect of the organization while selecting an appropriate solution. Below are some comparison points that can let us decide which technology can be used to meet our requirements:

    1. Use of Secondary Server: If there is any need to update the secondary server, you can do so with GoldenGate. Database is available in read-write mode and users can perform operation on the database. Whereas the database in case of Active Dataguard is open in read-only mode.

    2. Supplemental Logging: With Active Dataguard you are not required to put on the supplemental logging for tables not having primary keys or unique indexes. Some configurations and settings with minimal performance overhead active dataguard handles most workload. GoldenGate compulsory requires supplemental logging tables with without primary key and unique indexes.

    3. Maintenance & Migrations: Oracle Golden Gate provides the zero-downtime using 2-way or bi-directional replication. Whereas there are some scenarios where reduced downtime for various planned activities is not possible with Active Dataguard.

    4. Cross-Edition migrations & replication: GoldenGate ensures the cross-platform replication and migration with zero-downtime. Active Dataguard requires the configuration to have same editions of database on the same operating platform on both primary and secondary environment. That means any cross-platform migration or replication is not provided by Active Dataguard.

    5. Version backward Compatibility: GoldenGate is flexible enough to support the previous releases for replicating data from a newer version or release. This means that the data of Oracle 11g can be replicated on a Oracle 10g database.

    Depending upon the requirements we can chose the replication technology. Even though we see the two different technologies separately there are some high availability architecture where both can be used.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    it_user90060
    Team Lead at a retailer with 10,001+ employees
    Vendor
    Support for Oracle, MySQL, DB2, Sybase, Teradata, SQL server and others
    In 2009, Oracle acquired Golden Gate to strengthen its data replication technology as part of future strategies within data warehouse and real time transaction database. Before this acquisition, Oracle had its own replication technology which mainly constitutes basic replication, advance replication and stream replication. Oracle's basic replication process had two different methods: log based and trigger based. In log based replication, snapshot schema and DB links had to set up between source and target database. Data was transported from online redo log to target database over network. In advance replication Oracle included multiple master replications from multiple environments and trigger based replication method. In later versions of Oracle 9i, stream…

    In 2009, Oracle acquired Golden Gate to strengthen its data replication technology as part of future strategies within data warehouse and real time transaction database. Before this acquisition, Oracle had its own replication technology which mainly constitutes basic replication, advance replication and stream replication.

    Oracle's basic replication process had two different methods: log based and trigger based. In log based replication, snapshot schema and DB links had to set up between source and target database. Data was transported from online redo log to target database over network.

    In advance replication Oracle included multiple master replications from multiple environments and trigger based replication method.

    In later versions of Oracle 9i, stream replication was introduced with improvements in its earlier replication technologies. It uses log based replication where committed transaction’s online redo log of source system is mined to target system over network. Also a new background process to manage communication and operations of replication activities has been introduced

    However these replication technologies couldn't stand long as it involved complicacy and complex software development to harness the power of Oracle to Non Oracle database environment to allow the transaction to be moved between environment.

    In 1990, a small software company Golden Gate came with different approach on data replication between cross platform. Instead of using different formats, Golden Gate implemented a uniform format and used a command prompt GGSCI (Golden Gate Software Command Interface) to perform data replication operation. Oracle Goldengate 11g supports both DDL and DML operation. Legacy Oracle 8i version or prior requires an upgrade to 9i or later to implement the Goldengate.

    Goldengate supports all popular databases such as Oracle, MySQL, DB2, Sybase, Teradata, SQL server etc.

    Goldengate contains three installable components which can be downloaded separately from Oracle's website and can be installed on both, source and target system depending on requirement. Below is the list of installable components for Goldengate:
    • Oracle Goldengate which includes GGSCI, DEFGEN, LOGDUMP and REVERSE.
    • Oracle Goldengate Director which includes Director Service application, Monitor Agent, Director Client and Administrator client.
    • Oracle Goldengate Veridata which includes Agent, CLI, Web interface.

    Architecture

    Manager Process
    • Start and manage Goldengate processes such as collector.
    • Manage port numbers.
    • Trail Management.
    • Createerror, event and reports.
    • Process command GGSCI.

    Extract Process – Extract DML and DDL data from source database.

    Data Pump Process: Option process but recommended. Read records from source trails, process them and passes over to target system.
    Collector Process: This background process runs on Target system. It writes records on remote trail.
    Replicate Process: ReadsRemote trail, process them and applies changes to target Database.
    Trail: It is a Goldengate intermittent file written in proprietary format by either extract process (source system) or collector background process (target system).
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    it_user1221
    Database Expert at a healthcare company with 501-1,000 employees
    Vendor
    Great Replication tool which gives easy of setup and a small software footprint

    Valuable Features:

    This product is meant to replace Oracle's Data Guard replication. The setup is simple and it can handle bi directional replication very easily. Training cost is minimal and most DBAs self learn this product. replication between various types of databases is supported and software foot print is very small . Change trails are not very big and easy to manage and store.

    Room for Improvement:

    DDL (data definition language) replication is still to mature and can be an issue. Supplemental logging causes extra redo log generation in the log storage. Licensing cost is higher as compared to other replication products. Configuration of Golden Gate in HA (High Availability) mode needs setup of extra VIPs which can be challenging in a RAC environment.

    Other Advice:

    Integration of Golden Gate with monitoring tools like OEM (Oracle Enterprise Manager) is still not available and most DBAs monitor this with custom scripts. We chose this product mostly on it's bidirectional replication feature and easy setup. Some applications are using this as a messaging mechanism between multiple databases.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    it_user837
    Senior Manager of IT at a tech company with 51-200 employees
    Real User
    Data replication is seamless but time to value can be long

    Valuable Features:

    Data replication is seamless, once it is setup on a database. No triggers to setup.

    Room for Improvement:

    Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value.

    Valuable Features:

    Data replication is seamless, once it is setup on a database. No triggers to setup.

    Room for Improvement:

    Amount of min. supplemental logging or storage needed is unknown and has to be figured out, so increases time to value.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.