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. 

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.

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. 

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.

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.

Oracle GoldenGate helps to replicate the changes in one environment on the other. For example, if a team installs new tables, those changes are mirrored on the other side.

Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments.

In some cases, expectations were not met, especially when specific tables were expected to be disabled, and changes were anticipated in the target environment. We had to take backups from the source and refresh the address to address this.

I have been working with the product for one and a half years. 

I rate the product's stability an eight out of ten. 

I haven't faced any issues with the solution's scalability. 

Oracle GoldenGate's cost is high. 

I rate the tool an eight 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.