We just raised a $30M Series A: Read our story
2018-01-28T13:15:00Z

What needs improvement with Oracle GoldenGate?

2

Please share with the community what you think needs improvement with Oracle GoldenGate.

What are its weaknesses? What would you like to see changed in a future version?

ITCS user
Guest
1212 Answers

author avatar
Consultant

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.

2021-10-18T16:55:00Z
author avatar
Top 5LeaderboardReal User

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.

2021-02-18T10:11:48Z
author avatar
Real User

There are some DDLs that have problems with GoldenGate. These issues detract from stability and it is something that should be improved. I would like to see the interface more graphical and easier to use. I like Microsoft products, for example, because they are easy to use. When I work in SQL Server, which is integrated with Oracle GoldenGate, I find it better to work in than Oracle.

2020-11-24T23:23:18Z
author avatar
Top 20Reseller

Right now, the solution is working quite well for us as it is. The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement.

2020-07-12T11:48:51Z
author avatar
Top 10Real User

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.

2020-06-25T10:49:17Z
author avatar
Top 20Real User

It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure.

2020-03-04T08:49:27Z
author avatar
Real User

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.

2019-09-22T06:41:00Z
author avatar
Consultant

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.

2019-08-04T07:38:00Z
author avatar
Real User

We are having a challenge in that we want to replicate different types of data, from one database to another, that have different types of elements. The process of transforming the data between two different databases is inefficient and needs to be improved. Technical support for this solution could be improved. The integration is not straightforward and should be made simpler.

2019-07-28T07:34:00Z
author avatar
Real User

I find the user interface to be difficult for non-technical people. It was suggested to me that I use the command prompt, which is fine for me because I am a technical person. However, when showing others, such as managers, how to use the product to provide details such as the system status, it is a bit difficult. The inclusion of monitoring and management tools would be very nice. The Oracle documentation is very complex, and some of the documents are very long. I prefer to use sites that are on the topic of Oracle, but in fact, are not run by Oracle itself. In our experience, there is zero technical support for this solution.

2019-07-18T11:31:00Z
author avatar
Real User

The User Interface should be improved in newer versions, but without putting any restrictions on the customization capabilities. Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner. The licensing model should be improved to be more cost-effective for the end users.

2019-06-20T08:55:00Z
author avatar
Real User

I would like it to be simplified, easier to manage.

2018-01-28T13:15:00Z
Learn what your peers think about Oracle GoldenGate. Get advice and tips from experienced pros sharing their opinions. Updated: November 2021.
554,529 professionals have used our research since 2012.