Oracle GoldenGate Reviews

We use the product to replicate data between bank systems in an enterprise environment, such as Internet banking or core systems.

The platform's most helpful features are its speed and its guarantee of data replication from one database to another.

The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement. 

I have been working with Oracle GoldenGate for about two or three years.

The product is stable. I rate the stability a nine. 

The product is expensive. Due to the high cost, we are considering alternative solutions.

I rate Oracle GoldenGate an eight out of ten. 

The replication of the data table is one of the best features.

Some issues regarding stability need to be resolved. 

I have been using Oracle GoldenGate for a couple of years. 

The solution is stable. I rate the stability an eight out of ten. 

The solution is scalable. Very few people are using the solution at present. 

The technical support team is good but they need to scale up on their response time. 

Neutral

The initial setup is straightforward. The whole deployment can be completed in a day. 

The solution is recommended for businesses that require specific functions. I rate the overall solution a seven out of ten. 

We use GoldenGate for real-time data ingestion and integration.

The solution's existing SaaS platform for data integration gives us an edge because many other features' functionalities are available, such as real-time dashboarding and data analytics.

The GoldenGate license is very costly.

Stability is relative because of the way you design the entire system. DCDR, high availability, all these things come into the picture. Stability depends upon the way the ecosystem or enterprise has been designed.

Oracle GoldenGate is suitable for medium and large enterprises.

The difficulty with the initial setup depends on the type of project you are setting up. Is it a small, midsize, or large project? You have to look at the type of vertical or line of business. If the business is in banking, the solution has to be secure. In the telecom industry, fast transactions and latency come into the picture. These factors come in during enterprise design.

The initial setup is very easy with structured data because Oracle is a master in that area. However, storage becomes an issue when discussing unstructured and semi-structured data. GoldenGate does provide access to all these things, and there isn't much of a challenge from the integration perspective with the solution.

I rate the initial setup a nine out of ten.

We needed to exploit the real-time data analytics since data ingestion and integration were happening through the SaaS platform.

Oracle has a problem with pricing, and if they reduced the cost of their products, it would make a lot of sense. Today, many freely available tools to ingest data cover all three types: structured, unstructured, and semi-structured.

In a business like manufacturing, with data integration for large multinational companies, Oracle GoldenGate gains an edge over other solutions. Similarly, with telecommunications, for example, a multinational company like Vodafone, you would need GoldenGate to extract data. Data lineage helps control those things. Likewise, security is a concern. Smaller and lower-middle companies could not afford GoldenGate, however.

I rate GoldenGate an eight out of ten. However, different people, such as your CSO and CIO, will have different views. Your CFO, for example, might think the solution is too expensive.

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. 

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

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.

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.

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. 

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.

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

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

Oracle GoldenGate can be deployed on-premise and in the cloud.

We have some critical Oracle databases. Most of our marketing business data are in Oracle databases, we wanted to replicate this data to the downstream application. As part of that, we are using Oracle GoldenGate.

Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility.

I have been using Oracle GoldenGate for approximately three years.

We have not faced any issues with Oracle GoldenGate, it is stable.

Oracle GoldenGate is scalable. It is an approximate tool for large databases.

The technical support from Oracle has been responsive, they are good.

We have used many other tools in parallel with Oracle GoldenGate, such as Qlik Attunity for the replication.

Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration.

The implementation of the solution took approximately a few hours and if there are any issues it can take longer. 

We did the implementation in-house. We have a team of 20 that handles the duplication. They handle various tools including Oracle GoldenGate.

We have purchased corporate licensing to use Oracle GoldenGate.

My advice to others is Oracle GoldenGate has a lot of built-in features, it takes time to set up and configure but the performance is very good compared to other tools in the market.

I rate Oracle GoldenGate a seven out of ten.

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

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.

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).

More than 5 years.

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

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.

No.

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

10 over 10.

Quest Shareplex, because of licensing costs.

Straightforward, easy. Deployed everything within Oracle Data Integrator.

In-house and vendor, depending on the project.

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.

No comment about pricing and licensing.

Yes, we switched from SharePlex of Quest Software.

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.

It supports data movement for heterogeneous platforms as well as homogeneous platforms. We are using it for both use cases. Some use cases are for secondary sites, and some use cases are for different applications, such as data warehousing. We are using its latest version.

It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability.

It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality.

Troubleshooting issues is not always the easiest (can't always find info on errors online or at MyOracleSupport).  Oracle's professional support can also be improved (take a long time to resond to ticket, when they do it is obvious they don't read the issue before responding; they frequently ask for info already provided in the ticket.)

GoldenGate for big data is a separately licensed product. Regarding big data, I've found multiple prop file parameters not documented, not in the sample programs, yet were required. 

We have been using it in our organization for seven to ten years.

It is pretty stable. 

It is a truly scalable product. We have a team of two to run it, and they're part of the infrastructure team. There are lots of people who use the backend data. Their roles could be from business reporting to data scientists.

We have plans to increase its usage. We're finding more use cases for it all the time.

Oracle support is very frustrating in terms of how they pass tickets back and forth and don't read your problem statement. They waste a lot of time getting their support kicked into gear.

It has a medium complexity level.

It was done in-house.

We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee.

It works great as a text-based application. There are a lot of hooplas you have to run through for more of a GUI support. It requires a high level of knowledge to get started.

I would definitely recommend starting out with very simple extracts, pumps, and replicates to get the environment working and then jump in with specific tables that you need.

I would rate Oracle GoldenGate a six out of ten. 

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.

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.

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.

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

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.

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.

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.

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.

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.

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.