Senior Database Engineer at a financial services firm with 10,001+ employees
Real User
Top 5Leaderboard
Plenty of features, highly scalable, but implementation could improve
Pros and Cons
  • "Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."
  • "Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration."

What is our primary use case?

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.

What is most valuable?

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

For how long have I used the solution?

I have been using Oracle GoldenGate for approximately three years.

What do I think about the stability of the solution?

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

Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.

What do I think about the scalability of the solution?

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

How are customer service and support?

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

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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. 

What about the implementation team?

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

What's my experience with pricing, setup cost, and licensing?

We have purchased corporate licensing to use Oracle GoldenGate.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Mukesh  Kumar - PeerSpot reviewer
Senior Software Engineer at a tech consulting company with 10,001+ employees
Real User
Top 20
Helps to pull on-prem data but needs to incorporate feature which helps to connect it to standby database
Pros and Cons
  • "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."

What is our primary use case?

We use the tool to pull on-prem data. 

What needs improvement?

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. 

For how long have I used the solution?

I have been working with the solution for six months. 

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

Oracle GoldenGate is easy to scale up. 

How are customer service and support?

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

How would you rate customer service and support?

Positive

How was the initial setup?

Oracle GoldenGate's initial setup is easy. 

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle GoldenGate
April 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,141 professionals have used our research since 2012.
Database Administrator at a manufacturing company with 10,001+ employees
Real User
A truly scalable and pretty stable solution that works, but it needs better documentation, support, and easier troubleshooting
Pros and Cons
  • "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. It should be easier to troubleshoot. Their support can also be improved. They don't read your problem statement and waste a lot of time. GoldenGate for big data is actually a separate license. It is sort of a separate product, but it might fall underneath your GoldenGate category. If we're talking about big data, its interaction with big data sources is poorly documented."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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. 

For how long have I used the solution?

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

What do I think about the stability of the solution?

It is pretty stable. 

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

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.

How was the initial setup?

It has a medium complexity level.

What about the implementation team?

It was done in-house.

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

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. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Data Quality Software Development Manager at Yapı Kredi Bank
Real User
Different types of source systems (IBM DB2, Microsoft SQL Server) are supported for real time replication.
Pros and Cons
  • "Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
  • "It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."

What is most valuable?

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

How has it helped my organization?

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.

What needs improvement?

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

For how long have I used the solution?

More than 5 years.

What was my experience with deployment of the solution?

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

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

Customer Service:

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

Technical Support:

10 over 10.

Which solution did I use previously and why did I switch?

Quest Shareplex, because of licensing costs.

How was the initial setup?

Straightforward, easy. Deployed everything within Oracle Data Integrator.

What about the implementation team?

In-house and vendor, depending on the project.

What was our ROI?

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.

What's my experience with pricing, setup cost, and licensing?

No comment about pricing and licensing.

Which other solutions did I evaluate?

Yes, we switched from SharePlex of Quest Software.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Data Analysis Lead at a insurance company with 10,001+ employees
Real User
Helps to integrate different systems in one unified place
Pros and Cons
  • "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."

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

I have been working with the solution for two years. 

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

The solution is scalable. 

How are customer service and support?

The solution's support is slow. 

How would you rate customer service and support?

Neutral

How was the initial setup?

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. 

What's my experience with pricing, setup cost, and licensing?

The tool's prices are very expensive. 

What other advice do I have?

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

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Parwaz Khan - PeerSpot reviewer
Head of Data Analytics at Bupa Arabia
Real User
Top 5
High performance, excellent support, but priced high
Pros and Cons
  • "The most valuable features of Oracle GoldenGate are the schema application and performance."
  • "Oracle GoldenGate could improve the price."

What is most valuable?

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

What needs improvement?

Oracle GoldenGate could improve the price.

For how long have I used the solution?

I have been using Oracle GoldenGate for approximately four years.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

Oracle GoldenGate is scalable.

We have four people using the solution in my company.

How are customer service and support?

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

How was the initial setup?

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.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Consultant at National Water Company
Real User
A stable solution that can integrate heterogenic systems
Pros and Cons
  • "The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
  • "The solution, in general, should be easier to use, with less need to perform workarounds within the system."

What is our primary use case?

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. 

What is most valuable?

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

What needs improvement?

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.

For how long have I used the solution?

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

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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. 

How are customer service and technical support?

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.

How was the initial setup?

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

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Gaurav Batra - PeerSpot reviewer
Managing Solution Architect at a computer software company with 1-10 employees
Reseller
A scalable and easy-to-deploy product that enables real-time application of data
Pros and Cons
  • "I like that the product transforms data and provides real-time applications."
  • "There are a lot of bugs in the solution."

What is our primary use case?

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

What is most valuable?

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

What needs improvement?

There are a lot of bugs in the solution.

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How was the initial setup?

The initial setup is simple.

What about the implementation team?

I deploy the solution myself for my clients.

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Integration
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.