Oracle GoldenGate Reviews

We use Oracle GoldenGate for homogeneous and heterogeneous data migration.

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.

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.

I have been using Oracle GoldenGate for three years.

Oracle GoldenGate is a stable solution.

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

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.

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

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

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.

I used Oracle GoldenGate once to integrate two tables in the last twelve months. I also used the solution to integrate two tables from IBM Big Data Analytics to the Oracle Database Services on the cloud.

The major problem in Oracle GoldenGate is the monitoring part. If you need to use the monitoring feature of Oracle GoldenGate, you need to pay a lot, meaning it is very expensive to use the plug-ins from Oracle, so sometimes a user needs to avoid using it. A user directly needs to use the scripts to monitor the integration, which works perfectly. Sometimes, a user finds it more difficult to discover the problem, though solving the problem is easy. It is difficult to discover what was the problem with the integration using Oracle GoldenGate since the logs were not very clear. With Oracle GoldenGate, the documentation was not very clear, even for the parts related to the table or DDL. In general, Oracle GoldenGate can't deliver good feedback from the logs.

I have experience with Oracle GoldenGate. My company has a partnership with Oracle.

It is not a very stable tool, and you need to monitor it perfectly. Sometimes, I have faced some situations with the solution, owing to which I rate the solution's stability a six out of ten. It is not a very stable tool as sometimes it stops without any reason.

Scalability-wise, I rate the solution an eight out of ten since you need to install Oracle GoldenGate on ACFS. When used with the product's documentation, the integration capabilities ensure that the product's scalability features are used.

I had to contact the technical support team of Oracle GoldenGate whenever I faced issues with the product. There were no problems with Oracle's technical support team.

I rate the technical support an eight out of ten.

Positive

Previously, I used to use Oracle Data Integrator and a solution from IBM, but I don't remember its name.

The product's initial setup phase was very simple.

The solution can be deployed in a day, and it can be installed on the cloud or on an on-premises model, as it is a simple process. It takes a day to integrate some of the tables. Sometimes, deploying the tool on an on-premises model takes a day or two because you need to install the software and the patch.

It is an expensive product.

Oracle GoldenGate is a good product. There are some problems with the product, but you need to test some situations and include all the details in your tests before putting it in production to prevent the product or services from being stopped without any reason. Users should also ensure that the monitoring part is increased with some scripts.

I rate the overall product an eight out of ten.

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

Some issues regarding stability need to be resolved. 

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

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

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

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

Neutral

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

The solution is recommended for businesses that require specific functions. I rate the overall solution a seven out of ten. 

We use GoldenGate for migrations, upgrades and when going from Oracle Spark to Linux, for example, so cross-platform. There are many use cases. We are customers of Oracle and I'm a DBA.

For small databases that are less than a terabyte, GoldenGate handles the migration well. You don't need much input so long as the processes don't upend. As soon as there's a problem, then, obviously, you need to diagnose it. It all depends on the scenario, on the size of the databases, whether you're doing schema replication, or table replication. We normally do the whole database, taking everything across. Finally, because this is an Oracle product, there is support available 24/7.

The product lacks some features and it's expensive. I'd like to see a repair table function and a simplified installation process and configuration.

We've been using this solution for 20 years. 

The solution is stable, we haven't had any issues. 

The solution is scalable. 

If there's a technical problem, we raise a case with Oracle and they come back with a fix or patch. They provide good support although the response can take some time. 

Neutral

We moved to GoldenGate because there is less downtime for the end user. Everything is replicated in the new environment. It also provides consistency. 

The initial setup is a bit complicated compared to a solution such as SharePlex where you just run the installer and update one config file. GoldenGate requires a lot of configuration and there are some limitations. The initial setup took close to a week and was carried out in-house with our team. 

We have seen a return on our investment including reduced down time. 

Licensing costs are expensive. 

My advice would be to explore other possible solutions before locking into this one. GoldenGate does what it says it's going to do so I rate it eight out of 10.

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.

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.

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.

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

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

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

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.

Negative

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.

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

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.

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

The solution is useful for data transformation.

Monitoring must be a bit more enhanced.

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

The tool is very stable.

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

We are happy with the support team.

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.

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

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.

We use GoldenGate for real-time data ingestion and integration.

The solution's existing SaaS platform for data integration gives us an edge because many other features' functionalities are available, such as real-time dashboarding and data analytics.

The GoldenGate license is very costly.

Stability is relative because of the way you design the entire system. DCDR, high availability, all these things come into the picture. Stability depends upon the way the ecosystem or enterprise has been designed.

Oracle GoldenGate is suitable for medium and large enterprises.

The difficulty with the initial setup depends on the type of project you are setting up. Is it a small, midsize, or large project? You have to look at the type of vertical or line of business. If the business is in banking, the solution has to be secure. In the telecom industry, fast transactions and latency come into the picture. These factors come in during enterprise design.

The initial setup is very easy with structured data because Oracle is a master in that area. However, storage becomes an issue when discussing unstructured and semi-structured data. GoldenGate does provide access to all these things, and there isn't much of a challenge from the integration perspective with the solution.

I rate the initial setup a nine out of ten.

We needed to exploit the real-time data analytics since data ingestion and integration were happening through the SaaS platform.

Oracle has a problem with pricing, and if they reduced the cost of their products, it would make a lot of sense. Today, many freely available tools to ingest data cover all three types: structured, unstructured, and semi-structured.

In a business like manufacturing, with data integration for large multinational companies, Oracle GoldenGate gains an edge over other solutions. Similarly, with telecommunications, for example, a multinational company like Vodafone, you would need GoldenGate to extract data. Data lineage helps control those things. Likewise, security is a concern. Smaller and lower-middle companies could not afford GoldenGate, however.

I rate GoldenGate an eight out of ten. However, different people, such as your CSO and CIO, will have different views. Your CFO, for example, might think the solution is too expensive.

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

CDC is the most valuable feature. 

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

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

It's a very stable product. 

The scalability of this solution is good. 

We didn't make use of the customer service.

We installed the product on Microservices. 

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

I rate this solution 10 out of 10. 

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

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. 

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.

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

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

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.

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

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

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. 

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. 

We're an Oracle customer. 

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

We're using Oracle GoldenGate primarily to check data consistency, replication, and reporting.

Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support.

The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging. For example, my team's problem with using Oracle GoldenGate is that occasionally, you'll notice missing rows on the table, and it's hard to find that data.

In the future, an additional feature I want to see in Oracle GoldenGate is the microservices feature.

I've been using Oracle GoldenGate for the last three years, and I'm still using it.

In terms of stability, Oracle GoldenGate is fine. It's a seven out of ten for me, stability-wise.

Oracle GoldenGate is scalable, and there's no issue with it scalability-wise.

I have experience contacting the technical support team for Oracle GoldenGate, and there was no issue with it. It's pretty good, so support-wise, it's a four out of five for me.

My company also has in-house support for the solution.

My company uses Oracle GoldenGate because it is bundled with other Oracle products.

Oracle GoldenGate is simple to set up.

Oracle GoldenGate is a high-priced solution because it follows the core-based pricing model versus the software-based pricing model of other solutions.

My company is using Oracle GoldenGate.

In the company, Oracle GoldenGate is used in two environments. One is for data replication, and the other is for reporting purposes. In general, a total of fifty people use the solution.

My rating for Oracle GoldenGate is a six out of ten, mainly because of the price factor.

I strongly recommend Oracle GoldenGate to anyone who has servers and needs to do reporting. It's a solution that has no issues for the purposes I mentioned.

I'm a user of Oracle GoldenGate, not a partner.