Try our new research platform with insights from 80,000+ expert users
Database Manager at State of New York
Real User
Top 20
Great CDC feature
Pros and Cons
  • "CDC is the most valuable feature."
  • "Lacks the ability to become a full-scale ETL tool."

What is our primary use case?

Our primary use case is mostly for new environments and migrations, and sometimes updates. I'm a database manager. 

What is most valuable?

CDC is the most valuable feature. 

What needs improvement?

My only issue with this solution is that it doesn't become a full-scale ETL tool. 

For how long have I used the solution?

I've been using this solution for over a year. 

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

What do I think about the stability of the solution?

It's a very stable product. 

What do I think about the scalability of the solution?

The scalability of this solution is good. 

How are customer service and support?

We didn't make use of the customer service.

How was the initial setup?

We installed the product on Microservices. 

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

GoldenGate is an expensive solution but all the solutions in this area are expensive. 

What other advice do I have?

I rate this solution 10 out of 10. 

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
Arsim Kosumi - PeerSpot reviewer
Database System Specialist at TEB SHA
Real User
Top 10
Reliable, never crashes, and is quite powerful
Pros and Cons
  • "It is quite scalable."
  • "The solution costs a lot."

What is our primary use case?

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

What is most valuable?

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. 

What needs improvement?

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.

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?

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

What do I think about the scalability of the solution?

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.

How are customer service and support?

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

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

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

How was the initial setup?

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. 

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

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. 

What other advice do I have?

We're an Oracle customer. 

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

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
Buyer's Guide
Oracle GoldenGate
October 2024
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,649 professionals have used our research since 2012.
Solution architect at a energy/utilities company with 10,001+ employees
Real User
A stable solution that can be used for homogeneous and heterogeneous data migration
Pros and Cons
  • "Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
  • "The solution's licensing price is very expensive and could be made more competitive."

What is our primary use case?

We use Oracle GoldenGate for homogeneous and heterogeneous data migration.

What is most valuable?

The solution supports large-volume databases. Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful. The solution is helpful as the databases need to be available as DC and DR.

What needs improvement?

The solution's licensing price is very expensive and could be made more competitive. If I want to convert an Oracle database to a Postgres database, the schema conversion and the database transformation do not happen since it is purely a replication tool. It would be helpful if the solution could include features wherein databases can be converted from open source to Oracle and Oracle to open source.

For how long have I used the solution?

I have been using Oracle GoldenGate for three years.

What do I think about the stability of the solution?

Oracle GoldenGate is a stable solution.

What do I think about the scalability of the solution?

Oracle GoldenGate is a scalable solution that manages a large volume of data. Oracle GoldenGate is extensively used in our organization.

What about the implementation team?

We implemented the solution through an in-house team. We have a large DBA team comprising 10 to 15 people with various database skills who deploy the solution for us.

What was our ROI?

With Oracle GoldenGate, our technical use cases of DR (disaster recovery) have been met.

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

We pay a yearly licensing fee for Oracle GoldenGate, which is very expensive.

What other advice do I have?

I am using the latest version of Oracle GoldenGate. Oracle GoldenGate is a suitable solution for people seeking a scalable, robust data transformation platform.

Overall, I rate Oracle GoldenGate a nine 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
Senior Oracle Database Admin at mrcc
Real User
Powerful solution that centralizes our data and has a user-friendly interface
Pros and Cons
  • "This is a powerful solution provided by one of the most respected companies in the computer industry."
  • "Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."

What is our primary use case?

The areas we use for this product for is centralizing the collection of hospital data. In Saudi Arabia there are five special hospitals and each branch there is a local facility for data entry. Users enter data in the local database in their branches and the data is collected in a centralized database that is also in Saudi Arabia. These tools use criteria to identify cases that are similar in different hospital branches to help in diagnosis and treatment.

I am working on this project to serve as the administrator for the database. Before this, I joined a lot of projects, sometimes part-time, in Cairo and I gained 18 years of experience working on databases in the maritime ports in Arab countries and in hospitals in Arab countries, in Cairo, in Egypt, in Iraq, in parts of Spain and around the Arabian Sea. My primary responsibility is to make centralized data available.

What is most valuable?

I signed with Oracle to use GoldenGate for this project five months ago. I needed two or three months just to explore GoldenGate to get to know it and the features. There are many awesome features in GoldenGate and from what I see in the case studies, I need some more months of discovery to know what I think are the most valuable features. If you call me a month from now, I will be able to answer the question as to which of the excellent features are the most valuable. Right now it would be that I have confidence that GoldenGate can handle this extensive project.

What needs improvement?

I use an on-premises installation of GoldenGate — a standard GoldenGate installation — to do our test deployment for our projects. Part of the Oracle solution that needs some improvement is the ability to test features extensively before purchase and deployment. I am from Egypt and the economy is not so good. To create proper test environments for complex enterprise deployments is very expensive. Right now there is no place in Egypt that has enough servers to provide a proper test environment for a large deployment like the one we have planned. I do my best to do the test here with what I have.

It is a poor model to test all the GoldenGate features in an improper environment because a valid test of the features of GoldenGate may require a huge investment in accessories like memory and processors. I still need to do the testing. I need to write the code to test out the deployment without a proper environment and without using some features that may be valuable in achieving our goals. I am going to join a project to perform testing with Oracle Exadata in hopes to have free equipment to test this with. In this way, I hope to have a good enough environment to test the product. The project will be huge will be much larger in the future.

It could be that I will find I need to test out the cloud as a potential solution. I think I need one month or two months to decide what is the solution. But assistance from Oracle in temporary testing facilities would be useful and create the opportunity for investment.

For how long have I used the solution?

We have been using the product for about five months.

How are customer service and technical support?

I have a lot of experience with Oracle technical support. The technical support in Egypt is not responsive. When I have encountered issues they waste time in gathering unnecessary information. They send me a program, to export some files so they can look into the problem. This is a big waste of time and an unnecessary delay.

One or two days they are saying they are working on this case. While they are doing this I do my best to solve the problem on my own and search the Oracle Mechanic and Google. I raise the severity to the top, and nothing happens faster. The user suffers the consequence of inefficient support. I spent money on support and on my own I find out this issue is already a known issue and I apply the solution myself before they get back to me. They have the price I paid for support, and I provide my own solutions.

How was the initial setup?

I think that the installation of this product is very straightforward. I am sure I will encounter some problems and other issues because I installed a sample configuration of GoldenGate. This is a sample project where I have installed a huge database. It gives me the opportunity to encounter some problems and issues. I hope that I do not see any problems, but I am pretty sure I will experience some things that will go wrong.

The installation of Oracle's GoldenGate is fairly different from other similar applications. It is straightforward but at the same time more difficult. I think that is partly because other solutions will have about one-quarter of the features when compared to GoldenGate.

What about the implementation team?

I have completed the installations myself.

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

The pricing is done on a yearly basis. They have additional packages for technical support.

Which other solutions did I evaluate?

I have had the opportunity to use many products working for 18 years with databases. The list would be long if I tried to name the other products that I worked with. For this project, I suggested directly going to use Oracle products to create a solution because my experience says that it is the best way to do it. With some solutions, it would only be possible to join two modems at the maximum. We needed something more robust and to me, it was obvious that out of everything Oracle was the best.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Rishav Tiwary - PeerSpot reviewer
Rishav TiwaryManagement Trainee at DBSync
Real User

What is the pricing of oracle golden gate


ShanmugaSundaram - PeerSpot reviewer
Vice President - Database management at a financial services firm with 10,001+ employees
Real User
A great replication tool that needs to improve its stability
Pros and Cons
  • "The replication of the data table is one of the best features."
  • "Some issues regarding stability need to be resolved."

What is most valuable?

The replication of the data table is one of the best features.

What needs improvement?

Some issues regarding stability need to be resolved. 

For how long have I used the solution?

I have been using Oracle GoldenGate for a couple of years. 

What do I think about the stability of the solution?

The solution is stable. I rate the stability an eight out of ten. 

What do I think about the scalability of the solution?

The solution is scalable. Very few people are using the solution at present. 

How are customer service and support?

The technical support team is good but they need to scale up on their response time. 

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is straightforward. The whole deployment can be completed in a day. 

What other advice do I have?

The solution is recommended for businesses that require specific functions. I rate the overall solution 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 5
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
Arun Kumarasamy - PeerSpot reviewer
Exadata ,Senior Oracle DBA and Goldengate Consultant at a tech vendor with 10,001+ employees
Real User
Top 5
A very stable product that has easy configurations and is useful for data transformation
Pros and Cons
  • "The solution is useful for data transformation."
  • "Monitoring must be a bit more enhanced."

What is our primary use case?

If our data is in Oracle Database and we want to extract and transform the data to Azure or AWS, we use Oracle GoldenGate.

What is most valuable?

The solution is useful for data transformation.

What needs improvement?

Monitoring must be a bit more enhanced.

For how long have I used the solution?

I have been using the tool for the last seven years.

What do I think about the stability of the solution?

The tool is very stable.

What do I think about the scalability of the solution?

We have 200 to 250 users. All the maintenance activities are done online. It can be managed.

How are customer service and support?

We are happy with the support team.

How was the initial setup?

We use the solution on Oracle’s cloud. The configuration is very easy. Anyone can do it with a click of a button. The setup does not take more than 15 to 20 minutes.

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

It's a middleware. The price depends on the customers and the number of licenses they buy.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company has a business relationship with this vendor other than being a customer: customer/partner
PeerSpot user
PeerSpot user
IT Operations Manager at a tech services company with 10,001+ employees
Real User
Top 5Leaderboard
Enables to replicate data across different data centers and different technologies, but it is expensive and not easy to use
Pros and Cons
  • "We can replicate data across different data centers and different technologies."
  • "The product is not easy to use."

What is our primary use case?

We use the solution to replicate operational databases. We replicate the information from critical databases to non-critical databases. We use it for reports and transformations and to present it to other services.

What is most valuable?

We ensure that the data is replicated from one type of database to another immediately. It helps us with reporting, providing information to end users, and data management. We can replicate data across different data centers and different technologies. We like this function.

What needs improvement?

The documentation could be improved. The product is not easy to use. The knowledge required for the product is high. There are open-source products in the market that are easier to use than Oracle GoldenGate. We faced challenges to expand the solution and get more technologies. It is very difficult. We struggle with the licensing cost and the need for a knowledgeable resource. We need an open-source solution that is easier to adapt and work with.

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 tool’s stability a nine out of ten.

What do I think about the scalability of the solution?

I rate the tool’s scalability a nine out of ten.

How are customer service and support?

The support must be improved. When a vendor wants to reduce the cost of a support team, they have a first level of support with less knowledge. The escalation process is really slow. It takes ages to escalate issues to higher layers of support. The case has remained at the first level for a long time. It is typical of Oracle. We have complained directly to Oracle several times regarding the support.

How would you rate customer service and support?

Negative

How was the initial setup?

The product is easy to deploy since it is on the cloud. However, it is not easy to manage. The deployment time has been reduced, but the configuration and tuning are costly.

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

The tool is a bit expensive. It is not that elastic.

What other advice do I have?

It is a legacy process, and we need people with a lot of knowledge to do it. We can scale all the technology we need because we do not have the license. We update and perform security management for the tool. We have a group of five to ten engineers in our technical team. We cannot expand the tool easily. It is expensive. Overall, I rate the product a seven out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
Download our free Oracle GoldenGate Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 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.