Oracle GoldenGate Reviews

I used Oracle GoldenGate for a pilot project involving the migration of an Oracle database to AWS using GoldenGate. It was one of the options considered for CICD migration. I attempted to build a pilot to demonstrate the proof of concept.

Our customers have different use cases for Oracle GoldenGate.

Data migration is the most valuable feature of Oracle GoldenGate.

Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one. For example, if I have multiple Oracle databases on one side and wish to consolidate them into a single database, it would be beneficial if GoldenGate could capture data from multiple sources and consolidate it into one target database.

The one-to-one or multiple-to-multiple data capturing functionality works quite well with some limitations, of course, but it is currently functional. I see that many small, medium, and even larger businesses want to save money on licensing or decrease capital expenditures by migrating their infrastructure to cloud platforms. By using the cloud platform's scalability capabilities, we can easily set up a database that will scale up depending on workload. In this case, it makes sense to merge the databases into one and set up scalability in bands. 

I have been using Oracle GoldenGate for 17 years.

The stability depends on the manufacturers because GoldenGate still has some limitations. Depending on the user's data types, customer data types, or the platform source and target, it may affect the productivity of the entire system and the overall process. In fact, it could impact the stability. I would say that it has continuously improved over time. When Oracle switched from Streams to GoldenGate, the stability significantly improved.

Oracle GoldenGate is highly scalable because it offers various options for deploying data capture agents and placing data receiving agents. The only place that requires significant resources is the Golden Gate host itself, which, to the best of my recollection, is not excessively resource-consuming. Therefore, I believe that a single, dedicated Golden Gate host can efficiently handle data migration or replication services for a wide range of databases. I am unsure about the specific technical requirements for the Golden Gate Server host, but as far as I remember, it is not overly resource-intensive.

I would rate the scalability an eight out of ten.

The complexity of the initial setup is dependent on the platform being used.

The deployment, on average, takes between two to four hours per server if we don't use packaging services like Ansible for infrastructure deployment systems.

Currently, Oracle only offers licenses on an annual basis. However, it would be beneficial if they started to offer a time-based licensing format, allowing us to purchase a license specifically for a small project related to data migration, instead of having to commit to a full year.

In addition to the licensing fee, customers are also required to pay an additional 24 percent for the support.

I would rate Oracle GoldenGate nine out of ten. The only drawback is its inability to merge multiple Oracle databases into one.

For an organization using Oracle products, GoldenGate is the most reliable tool for migration or application use cases involving source or target Oracle databases. However, if they do not have Oracle databases on either end, there might be other options available that could be cheaper or more flexible, as I am not very familiar with GoldenGate agents on other platforms. I do not possess sufficient statistics or information about GoldenGate agents in such scenarios.

While I can confidently say that GoldenGate works effectively with Oracle projects, I am unsure about its performance with other platforms. There are certainly some capabilities, and we can consider relying on them or keeping them in mind. However, I am hesitant to recommend GoldenGate for data replication from non-Oracle platforms to other platforms.

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.

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. 

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.

I am impressed with the tool's possibility of integrating different systems in a unified place. 

The tool's connections are disconnected at times. The tool needs to integrate other databases. 

I have been working with the solution for two years. 

I would rate the product's stability a nine out of ten. 

The solution is scalable. 

The solution's support is slow. 

Neutral

The tool's setup is straightforward. If the database is new, the deployment can take around three to five days to complete. We required one or two people to handle the tool's deployment. 

The tool's prices are very expensive. 

I would rate the product an eight out of ten. You have to understand the working of the solution. 

The most valuable features of Oracle GoldenGate are the schema application and performance.

Oracle GoldenGate could improve the price.

I have been using Oracle GoldenGate for approximately four years.

We did not face any challenges with the stability of Oracle GoldenGate.

Oracle GoldenGate is scalable.

We have four people using the solution in my company.

The technical support from Oracle GoldenGate is excellent. However, we are running out of support because our licenses are expiring.

We are not using Oracle GoldenGate for high-volume transactional systems which made the deployment not difficult. Moving forward we might integrate with high volume transactions systems and we could run into some challenges.

The price of Oracle GoldenGate should be lowered. It is expensive compared to other solutions.

My advice to others is Oracle GoldenGate is one of the best solutions. However, when you choose a CDC solution you need to compare your existing environment and the compatibility with those tools. Within an Oracle-based environment where the core systems are running, Oracle GoldenGate was suitable for us.

I rate Oracle GoldenGate a seven out of ten.

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.

The solution is used for migrating and syncing data between heterogeneous systems.

I like that the product transforms data and provides real-time applications.

There are a lot of bugs in the solution.

I have been using the solution for more than ten years.

I rate the stability an eight out of ten. The product has a lot of bugs.

I rate the tool’s scalability an eight out of ten. Scaling the tool is not that difficult. Any organization can use the solution.

The initial setup is simple.

I deploy the solution myself for my clients.

The tool is moderately priced. The pricing is simple for a big organization. The solution would be costly for a small organization. I rate the pricing a five or six out of ten.

I have not used any other products. GoldenGate is a nice product. I would recommend the solution to people looking for real-time data applications between heterogeneous or homogenous systems. Overall, I rate the solution an eight out of ten.