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?
It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure.
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.
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.
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.
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.
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.
I would like it to be simplified, easier to manage.