2018-01-28T13:15:00Z

What advice do you have for others considering Oracle GoldenGate?

Julia Miller - PeerSpot reviewer
  • 1
  • 15
PeerSpot user
31

31 Answers

IfeoluwaOshinowo - PeerSpot reviewer
Real User
Top 20
2024-02-06T16:17:00Z
Feb 6, 2024

Oracle GoldenGate instantly replicates data changes from primary databases to secondary ones, ensuring real-time updates across systems. Its monitoring features detect issues promptly, minimizing downtime. Overall, GoldenGate provides reliable real-time data integration, enhancing business processes efficiently. In one organization, we employed Oracle GoldenGate for data replication. We opted for a three-way setup to integrate data between source and target databases without directly impacting either side. Placing an intermediary server between the source and target, we configured GoldenGate parameters. This allowed data to flow from the source to the intermediary server and then to the target, meeting our specific requirements. Depending on cost considerations, we sometimes chose a simpler two-way replication directly from source to target. The conflict detection and resolution feature of Oracle GoldenGate ensures that data replication tasks are executed seamlessly without any conflicts. This results in a flawless data replication process for customers, leading to a positive experience without any complaints or issues related to data consistency or integrity. I would recommend considering Oracle GoldenGate for real-time data replication, especially if cost is a factor compared to DataGuard. Additionally, GoldenGate is easier to manage with the right technical expertise. Training the team on managing it can streamline operations and provide business advantages. Overall, I would rate Oracle GoldenGate as a ten out of ten.

Search for a product comparison
Arun Kumarasamy - PeerSpot reviewer
Real User
Top 5
2024-01-25T07:52:02Z
Jan 25, 2024

If someone wants to move data from Oracle to AWS or Azure, Oracle GoldenGate is the best product for them. Overall, I rate the solution a nine out of ten.

GS
Real User
Top 20
2024-01-12T20:36:15Z
Jan 12, 2024

I would certainly recommend it. Overall, I would rate it nine out of ten.

KB
Real User
Top 5Leaderboard
2024-01-12T13:01:01Z
Jan 12, 2024

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.

Andre-Rocha - PeerSpot reviewer
Real User
Top 5
2023-12-19T12:34:22Z
Dec 19, 2023

Oracle GoldenGate is a good product. There are some problems with the product, but you need to test some situations and include all the details in your tests before putting it in production to prevent the product or services from being stopped without any reason. Users should also ensure that the monitoring part is increased with some scripts. I rate the overall product an eight out of ten.

Prashant Sukhe - PeerSpot reviewer
Real User
Top 5
2023-11-13T17:11:51Z
Nov 13, 2023

Exploring other more compatible databases could be an alternative. If a versatile solution is sought with many sources, including various databases and servers, there may be better choices than starting with Oracle GoldenGate. However, opinions on this matter may vary, and I might be mistaken in certain cases.

Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Anand_Kumar - PeerSpot reviewer
Real User
Top 5
2023-08-17T04:37:15Z
Aug 17, 2023

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.

Mukesh  Kumar - PeerSpot reviewer
Real User
Top 20
2023-07-26T04:51:17Z
Jul 26, 2023

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

AZ
Real User
Top 20
2023-06-23T03:39:00Z
Jun 23, 2023

The solution is reliable. I rate it a nine out of ten.

PY
Real User
Top 20
2023-06-06T06:39:45Z
Jun 6, 2023

I would rate the solution a seven out of ten.

ShahidNadeem - PeerSpot reviewer
Real User
Top 10
2023-05-12T10:40:50Z
May 12, 2023

My advice would be to explore other possible solutions before locking into this one. GoldenGate does what it says it's going to do so I rate it eight out of 10.

Albert Lacerda - PeerSpot reviewer
Real User
Top 5
2023-04-18T14:25:48Z
Apr 18, 2023

I'll give you different information: Oracle's product is certainly powerful and will solve your integration problems, if money is not an issue, go for it. But you have an open source alternative that works: Debezium with Apache Kafka, it's complex, and it takes a lot of work to configure but it works without impact on the database performance (it reads the logs) and it doesn't cost anything, just time and learning, but you will have the knowledge of the solution.

AO
Real User
Top 20
2023-03-09T22:00:41Z
Mar 9, 2023

I rate this solution 10 out of 10.

Arsim Kosumi - PeerSpot reviewer
Real User
Top 10
2023-01-13T16:43:49Z
Jan 13, 2023

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

Vipin Mani - PeerSpot reviewer
Real User
Top 10
2022-11-23T09:41:52Z
Nov 23, 2022

My company is using Oracle GoldenGate. In the company, Oracle GoldenGate is used in two environments. One is for data replication, and the other is for reporting purposes. In general, a total of fifty people use the solution. My rating for Oracle GoldenGate is a six out of ten, mainly because of the price factor. I strongly recommend Oracle GoldenGate to anyone who has servers and needs to do reporting. It's a solution that has no issues for the purposes I mentioned. I'm a user of Oracle GoldenGate, not a partner.

Parwaz Khan - PeerSpot reviewer
Real User
Top 5
2022-09-20T13:33:25Z
Sep 20, 2022

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.

OD
Real User
Top 20
2022-08-18T10:57:16Z
Aug 18, 2022

I concentrate on Oracle products, and I'm currently working with Oracle GoldenGate. My company provides Oracle GoldenGate for customers, so my team has been working with a lot of versions of the solution, starting from version 12 up to version 19. My company works on consulting projects, and can also sell licenses, but if the customer has a license and requires some solutions, the team can provide complete services, starting from designing architecture, upgrading, ensuring there's minimal downtime, etc. At the moment, my company has seven clients using Oracle GoldenGate. My advice to others who want to start using Oracle GoldenGate is that it may not be as easy at the beginning, but it's a good product. My current rating for Oracle GoldenGate is nine out of ten, but if I'm able to evaluate other solutions, that rating could change to a lower or higher rating.

LP
Real User
Top 5Leaderboard
2022-05-18T19:19:42Z
May 18, 2022

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.

Jon Davies - PeerSpot reviewer
Vendor
Top 10
2022-04-27T08:20:47Z
Apr 27, 2022

I would recommend this product. It's pretty good. I would rate it a seven out of ten.

SJ
Consultant
2021-10-18T16:55:00Z
Oct 18, 2021

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.

SP
Real User
2021-02-18T10:11:48Z
Feb 18, 2021

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.

MA
Real User
2020-11-24T23:23:18Z
Nov 24, 2020

My advice for anybody who is considering this product that its suitability depends on the environment. If Oracle is being used then it is a good solution but otherwise, another product would be a better choice. I would suggest using a solution by the same vendor as the database that is being used. I would rate this solution an eight out of ten.

PS
Reseller
2020-07-12T11:48:51Z
Jul 12, 2020

We're a reseller. We help our clients implement the solution. I'm not sure which version of the solution I'm using or if it's the most current. GoldenGate, right now, is a really fantastic solution. The price is high, but it's worth the cost, in my opinion. It works with heterogeneous environments like Oracle, or IBM digital. We host it in servers and we host it in databases. A lot of the times we also host it in MySQL or on the MySQL database. The solution uses a very low latency bandwidth because GoldenGate actually transfers the data. It will not take up a lot of resources like CPU or memory. I'd rate the solution nine out of ten.

CF
Real User
2020-06-25T10:49:17Z
Jun 25, 2020

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.

AM
Real User
2020-03-04T08:49:27Z
Mar 4, 2020

Oracle GoldenGate is a product that I would recommend. I would rate this solution a nine out of ten.

AM
Real User
2019-09-22T06:41:00Z
Sep 22, 2019

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.

OM
Real User
2019-08-04T07:38:00Z
Aug 4, 2019

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

it_user807540 - PeerSpot reviewer
Real User
2019-07-28T07:34:00Z
Jul 28, 2019

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.

NM
Real User
2019-07-18T11:31:00Z
Jul 18, 2019

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.

Real User
2018-01-28T13:15:00Z
Jan 28, 2018

I would recommend Oracle GoldenGate, of course.

NC
Real User
2018-01-28T13:15:00Z
Jan 28, 2018

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.

Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds. Oracle GoldenGate Features Oracle GoldenGate has many valuable key features, including: Simple to use web interface Fast and easy installation or provisioning Command line access via AdminClient that can run anywhere RESTful APIs for...
Download Oracle GoldenGate ReportRead more