Oracle GoldenGate Reviews

I used Oracle GoldenGate for some migrations and consultations between different types of businesses.

Oracle GoldenGate has a lot of benefits. You can use Oracle GoldenGate as a DR for your system. You can use the solution if you don't want to have unnecessary recovery using synchronization or have some restrictions, like character suit or limited use.

Oracle GoldenGate can help if you have only to replicate the subset of your data and not the full data. Suppose you are in an organization with many branches and are interested in replicating only the accounting and not the financial data. In that case, Oracle GoldenGate will help you with some considerations, calculations, and transformations associated with it.

In Oracle GoldenGate, we don't have full capabilities or information on ODI products for Oracle, which are specifically used for transformations. You can do your coding or transformation processes and do your job. Sometimes I use a quality tool for Oracle to do some transformation from data cleansing and data insights.

I know every Oracle product has been designed for each feature, and Oracle GoldenGate is a dedicated tool for better transformation and replication. It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate. Although currently, it's a good prototype, Oracle GoldenGate can do more.

I have been using Oracle GoldenGate for almost four years.

Oracle GoldenGate's stability is better if you follow the metrics for compatibility between software versions. If you follow all the metrics, Oracle GoldenGate's stability can be rated an eight to nine out of ten. However, you may face some bugs if you don't follow the metrics.

I rate Oracle GoldenGate an eight or nine out of ten for scalability. Oracle GoldenGate can work for small, medium, and enterprise companies. It's scalable to work on different scales.

We sometimes need to open the tickets with Oracle to get technical support. Depending on the team and the escalation level, sometimes we get a very good response from Oracle, and sometimes we don't.

Oracle GoldenGate's initial setup is very simple because Oracle has a dedicated version for every database, whether Oracle or non-Oracle. For the initial setup between the source and the solution, the ease of setup depends on the configuration and the business requirement. It does not depend only on the technology but on the customer's requirements. If you have a very complex replication, it needs a more complicated setup. It depends on each task.

We can't comment that it's always easy to have Oracle GoldenGate, and we can set it up in a day or two. Sometimes you can set it up within a few hours; other times, it needs very deep understanding and preparation before going to Oracle Golden Gate.

You might need some help from ODI or other tools to prepare your data and get ready. It will be easier if everything is clear and there is an understanding of the mapping between the source and destination, objects, and attributes. However, you cannot have a definite answer for all cases.

In certain cases, customers could install the solution themselves. Oracle has had a GUI interface for Oracle GoldenGate for two or three years called the microservices. Microservices can be easier to set up for single cases. However, if you have some complex cases, you will need some help understanding data, replication, and knowing if some preparation is required at the beginning.

I would recommend Oracle GoldenGate to other users because it’s a good product.

Overall, I rate Oracle GoldenGate an eight out of ten.

We are using it for getting data back.

It works best with Oracle.

The front-end management isn't very good.

Its pricing and licensing can also be better.

I have been using this solution for about a year.

It is very stable.

It is very scalable.

Their technical support is pretty good. I would rate them a four out of five.

It was easy to set up.

I installed it myself.

Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. 

There don't seem to be any additional costs.

I would recommend this product. It's pretty good. 

I would rate it a seven out of ten.

Our primary use is to transfer data or tables in databases from one server to another.

GoldenGate can connect and collect data from multiple sources, such as SQL Server.

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.

We have been using Oracle GoldenGate for the past three or four years.

GoldenGate is a stable product.

Usually, it works with no problems. Sometimes there are issues, but we have been able to solve them.

It is easy to scale once you learn it.

This product has been working well in our environment so we haven't had the need to contact technical support.

The initial setup was straightforward. It took three or four months to complete.

The implementation was done by the Oracle team.

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.

I am part of a consulting firm and we build database solutions for our customers. Oracle GoldenGate is one of the products that we assist our clients with.

It is primarily used to replicate data from the main database to a backup server.

The most valuable feature is data replication capability.

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

One of our clients began using Oracle GoldenGate in 2013 and a second client started with it in 2018.

Oracle GoldenGate is pretty much stable.

I haven't encountered any issues in terms of scalability.  We are working with solutions where there is not much in terms of scope.

Technical support from Oracle is good. We were able to get help and good advice from them.

The initial setup was complex. It took a lot of time to get it stabilized.

The price of this solution is good.

Oracle GoldenGate is a product that I would recommend.

I would rate this solution a nine out of ten.

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.

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.

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.

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.

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.

I have completed the installations myself.

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

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.

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.

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. 

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

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.

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.

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. 

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.

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

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

We are a reseller, and we implement this solution for our clients. They are generally either government or financial institutions. These clients use other Oracle technologies for tasks such as identity management and business intelligence. This solution is used to replicate the data for purposes such as disaster recovery and high availability.

The most valuable feature of this solution is data replication. When we are replicating data between similar databases then it is straightforward.

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.

This solution is stable and we aren't facing any issues.

Scalability of this solution depends on the licensing from Oracle.

We have had trouble with the Oracle technical support. When we need them to reply to us, we need to open a 24/7 ticket. If we open a critical ticket instead, then nobody replies and it takes a lot of time. Consequently, whenever we are facing an issue and we need to open a Service Request (SR), we use the 24/7 support. This leads to three people working in parallel to resolve our problem. Otherwise, we will not get a resolution.

The initial setup of this solution is straightforward. For the installation, you need only follow the steps in the documentation.

There are a lot of tricks when it comes to licensing.

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.

We implement this solution for our customers, and our most recent deployment was for a client in France. The solution involved one central database and ten replicas that were distributed to the local offices. The central database is automatically updated as the replicas are changed, and similarly, when the central database is modified, each of the local copies is updated accordingly.

Using this solution has improved both the speed and efficiency of the data replication process. Prior to this, I used packages with merge functionality for replication. The process was very slow, and sometimes had negative effects on the production database. This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us.

The most valuable feature is the CDC (Changed Data Capture), which captures only the changes that are made to the data. This has the lowest load on the production database, and it runs very quickly in the background.

Reading directly from the log file makes updating the databases very fast.

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.

This is a very stable solution, and I haven't had any problem with the tools.

This solution scales easily. It's dependent on the files and configuration, and you can do anything you want.

This solution is being used on a daily basis. We have approximately one thousand users on the production database, including both developers and end-users. We do have plans to increase our usage, although the interface for monitoring and managing becomes difficult to use when it grows to a certain point.

I have contacted technical support, but could not get any support. I would say that the support is zero.

Prior to this solution, we had a package that used an SQL process. It had come from Oracle Scheduler. We switched because it negatively impacted our production database, making it very slow. If there was downtime and the production database had transactions then it would take days to recover from the lag.

The initial setup of this solution is of medium difficulty. It is not straightforward; however, it is not as complex as it looks.

For a single deployment that has two sites, I would expect the process to take less than two hours, although it depends on the complexity of the replication.

An example of a more complicated configuration is where only a subset of the tables are being replicated, and the flow of data is different in both directions. Setting this up can take a very long time, and incur a large cost because of coding time.

We have three people to manage and maintain this solution. This includes making changes to the database. For the monitoring and altering, one person is sufficient and it will not take one hundred percent of their time.

We handled the implementation of this solution in-house.

We do like the price of this solution.

We did not evaluate other options when we chose this solution, although I am now considering other tools.

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.