Oracle GoldenGate Reviews

We primarily use the solution for the exchange of data between two databases. It's used for replication and some processes.

This is a powerful tool.

It is stable and offers good reliability. The server never crashes. 

It is quite scalable. 

The initial setup is very easy. 

It's pretty close to perfect. There are no areas we see that are in need of improvement. 

It is not very easy to use, however, for what it does, it's not too difficult to manage in general. 

The solution costs a lot.

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

The solution is stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. 

It is quite scalable. It easily expands. 

It's not a product for the people, for the client base and therefore, there aren't a large number of users, per se. It's a tool for exchanging data. Nobody can access it apart from infrastructure people.

I've never had a need for support. It works quite well and I have not needed help troubleshooting. 

I was not at the company when the organization chose this solution. I'm not sure what was used previously. 

The solution is very straightforward to set up. It's not overly complex. I'd rate the implementation process nine out of ten in terms of ease of setup.

The time it takes to deploy depends on the platform. For example, a Linux or Oracle database may take a few minutes up to one hour. 

It's an expensive product. It's not cheap. 

The solution charges are based on the type of CPUs. If you are using IPM or HPE, or Linux, pricing may be different. The cost also varies according to the agreement itself. Companies can try to negotiate costs. 

We're an Oracle customer. 

I'd rate the product eight out of ten. We're mostly happy with its capabilities. 

Our primary use case is for consultancy, more specifically for moving customers' data from on-prem into the cloud. We do this in conjunction with our product. We do not have to pay extra for the Oracle Enterprise Manager because our software can manage the GoldenGate software.

What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace.

The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it. When there's a problem, you have to delve quite deeply down to this sort of data layer where the problem is.

I have been using Oracle GoldenGate for about two years now. 

The performance of the product is second to none. There are not many products out there that can compete at the level they can. The only problem is that GoldenGate is very expensive. So, if people only want to use it for migrating into the cloud, for example, they could be laden with a lot of heavyweight software they never use.

GoldenGate is very scalable. 

We have not used GoldenGate's technical support too much. We have only asked them a couple of questions. Our experience was good. I have not had anything negative come back. 

Before switching to GoldenGate, we had some experience with the AWS Database Migration Service. 

GoldenGate is quite difficult to set up. The process can take you a few days.

When it comes to maintenance and things like patch updates, it's relatively straightforward as long as you're paying the support fees. You get that as part of the license.

We implemented it internally. We currently have six consultants working with this product. 

I think that the price for one CPU with a computer is about $17,000. A small solution probably needs at least four CPUs and up to eight. That will add up to $68,000 to $132,000. You can't go that much lower than that.

If you are not using our product, you have to use Oracle Enterprise Manager and I think that's about $3,000 per CPU as well. Overall, you could be looking at up to $24,000 on top of the GoldenGate license. 

It's quite on the expensive side, but if you want that kind of monitoring, that's what you have to use. 

Amazon's tools usually have low data footprints and simplistic type migrations. There is a limit to what they can do and how long they take to do it, particularly in Oracle. With GoldenGate, everything is a lot faster and can be done in real time with low downtime, which is the key thing.

Make sure it's the right tool for the job you need to do. In-cloud migrations, particularly database migrations, account for about 12% of an overall cloud migration project. Within that 12%, probably 90% of those non-production and low data footprint databases could be handled by tools like AWS Database Migration Service. However, when you can't take the system down for very long, or you've got lots of databases, it can take a long time to migrate them unless you use a tool like GoldenGate. However, using GoldenGate requires extensive skills for management and configuration. 

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.

We use the product internally to cover one of our data synchronization needs. The use case is likely to be unique in the world.

The solution involves 3000 pharmacies distributed geographically on several islands and continents. Each pharmacy has an ERP for managing pharmacy operations (sales, purchases, logistics, etc.). And we are synchronizing all the data and transactions that are generated in the ERP, with a central database (Exadata).

Our use case is complex and with Oracle GoldenGate we are improving the efficiency of the data replication and mostly the maintenance and operations support. We are in the process of migrating the current solution (based on queuing and web services) to Oracle Goldengate. Our current data synchronization process is old and not efficient enough to deal with 3000 data sources.

With Oracle Goldengate, we have more control over the CDC phase, and we can improve our management process which is critical for us.

The OGG CDC is flexible and robust but complex to manage. The OGG version with microservices is very important to us because we need to monitor and manage all the database sources. The current OGG monitor is limited to our operations and we built one for our needs using the OGG microservices.

While we like the CDC feature, it has some limitations in terms of what we can do and how to configure what we need to do. We are trying to fix those issues by implementing some workarounds.

Memory consumption is also an issue in OGG architecture. Each OGG data replicator consumes more and less 200 MB of RAM. We have 10 OGG hubs, each one with almost 300 data replicators to the central database. We need 64 GB for each Hub. a total of 640 GB just for data replication.

We've been working with the product for five years.

The solution, especially the last version, is very stable. Even with 3000 data sources, and a complex framework we're finding the solution to be very reliable.

The solution is very scalable when adopting a three-tier solution with hubs in the middle. Each OGG hub handles 300 interconnections. We have 10 hubs and, if we need to increase or expand, we put more servers in the system. It is very simple and expensive too.

In Portugal, we have a direct connection with Oracle (Portugal) due to the fact that our use case is so unique. We are also in direct contact with the Oracle Goldengate project manager through Oracle Portugal.

Everyone has been very good so far. Although the team in Portugal does not have the knowledge base necessary for our purposes, teams in India or the USA generally provide the required assistance.

At the scale where we are now, we have worked with Attunity. It is a similar CDC software data extraction. It's more straightforward and simple to configure, however, when you scale with the 3000 data sources, the system starts being unmanageable. And the total cost of ownership is higher than OGG.

OGG technology is not simple. The first setup took almost six months because we had a hard time finding OGG specialists on the market.

There are three support teams in the project. We have a support team for infrastructure management, a team of DBAs to manage the Exadata, and an operations team to manage the 3000 databases (sources). And we also have Oracle's support for bugs and problems that we encounter along the way.

We had external help from Oracle. And we hired specialists from Brazil who came to Portugal to help us.

In terms of price, as a client, I want always the cheaper price. But, in this case, we have a good deal with Oracle in terms of GoldenGate licenses. It's a lot of money but the business case is working for us. We need the information, and fast access to it, so we require an effective system. We already have one solution in place working, but it's a legacy system bases on web services and the operations costs are very expensice. We need to migrate asap to this new solution.

Yes, the current system we are using is based on Internet protocols. We are using web services and data streaming. But when you need to manage and operate 3000 data sources, every time you need to make a change it's a nightmare. The operations costs and time consumption in software development and depoly is too high to maintain.

We're currently in the middle of a huge project using Oracle GoldenGate. We have a unique business case in the world - synchronizing 3000 OLTP databases to an Exadata. Normally Oracle GoldenGate use cases are for 10 or 50 maximum data sources.

We are using OGG version 19 in the OGG Hubs (Replicators). In the source, we are using OGG version 13 microservices (Extractors).

We have a hybrid OGG architecture: the data source is on-premise and the hubs and the Exadata are in the OCI (Oracle Cloud Infrastructure). We have on-premise extractors and replicators in the cloud. the connection is made through FastConnect. 

I'd rate the solution seven out of ten. There are several features that have some real limitations for us. The product itself is not simple to manage and we take almost 6 months to learn the basics. There's also harsh memory consumption. Each connection is consuming almost 200 megabytes of memory, and, with the 3000 databases, that's a lot of resources to manage. 

Customers use Oracle GoldenGate because they need near real-time analytics to sync their source system to the ODS database.

With Oracle GoldenGate, you will have ODS databases, and you can create a foundation layer on top of it. You can also directly create ODS reports or operational reports. Every customer has 10 to 20 systems. When you put all of them into the same ODS structure, you can also enable integrated reports.

With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database. You can easily monitor and maintain the system, and it doesn't need a primary key for sync; it reads from log shipping and the table. Oracle GoldenGate is a good product for syncing the database.

Oracle GoldenGate is a good product that works best with Oracle. Oracle GoldenGate's monitoring is good. You can easily see the detailed logs, timestamp points, and status of each table.

Oracle GoldenGate hangs for large tables. You cannot put everything in Golden Gate because it's licensed to hold systems. If you connect to another system with 20 CPUs, Golden Gate would need 20 more CPUs. You cannot put everything in Golden Gate for the license and large models. For that reason, we use Golden Gate and DB Link together. In some cases, we prefer to use DB Link; in others, Oracle GoldenGate.

We had to open a ticket three years ago because Oracle GoldenGate couldn't read the IBM system. However, the solution can read the IBM system now, and it depends on the source systems.

I am satisfied with the solution’s technical support.

The solution’s initial setup is easy.

There's an Oracle GoldenGate server on the net search. There'll be a firewall configuration to reach the data. Also, an agent is installed on the source system to get the sync data. The solution can be deployed in three months. Since Oracle GoldenGate is a technical and DBA product, only a few people are needed to deploy it.

Oracle GoldenGate's license can be expensive compared to other solutions like Qlik Replicate or SAP Replicate.

Oracle GoldenGate is installed and maintained easily. If you have a maintenance issue, Oracle's support team will handle it. Maintaining the solution is easy.

Users need to check if GoldenGate supports the source system, and they should do a POC for it. The technical guys should see the different types of mechanisms, like directly from data, log shipping, journal, etc. They should also see the latency. I know users will like the product if they do a POC phase.

Overall, I rate Oracle GoldenGate an eight out of ten.

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.

We use the tool to pull on-prem data. 

IBM CDC has one central control while Oracle GoldenGate has two controls. In IBM CDC we can do all things in frontend. The solution needs to incorporate a feature where we can connect it to a standby database. 

I have been working with the solution for six months. 

The product is stable and I would rate it a nine out of ten. 

Oracle GoldenGate is easy to scale up. 

Oracle GoldenGate's support is very good and depends on the ticket's severity and priority. 

Positive

Oracle GoldenGate's initial setup is easy. 

Oracle GoldenGate is an enterprise solution and I would rate it a nine out of ten. 

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.