Oracle GoldenGate Reviews

I have used Oracle GoldenGate for a couple of different scenarios. One client wanted to keep their main database secure, so we set up GoldenGate to replicate data in a separate environment for reporting purposes. This allowed users to query the replicated data without directly accessing the main database. Another client needed real-time access to historical data without active data guards, so we implemented GoldenGate to enable querying of archived data from both Oracle and non-Oracle sources. 

The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios. Secondly, its versatility in supporting data replication across different operating systems and platforms is highly valuable, making it the go-to tool for heterogeneous environments.

In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting. I believe enhancing the monitoring tools would make GoldenGate even more efficient.

I have been using Oracle GoldenGate for a few months.

It is a stable product.

GoldenGate is quite scalable.

While the technical support for Oracle GoldenGate is generally great, it has room for improvement in escalating critical issues to senior engineers promptly. Sometimes, customers face delays or multiple interactions with junior support engineers before resolving. I would rate the support as a nine out of ten.

Positive

I find the initial setup process of Oracle GoldenGate to be straightforward and haven't encountered any complexities with it. I would rate the easiness of the initial setup as an eight out of ten.

The deployment process for Oracle GoldenGate begins with understanding the customer's replication needs. It is essential to clarify which data to replicate and any limitations. Documentation and workflow planning follow, listing objects and target environments. For major changes like database migrations, a careful cut-over plan is crucial. The deployment time for Oracle GoldenGate varies based on the data size and initial load type, but with good connectivity, it can be quick.

Maintenance isn't difficult and mainly involves proactive monitoring to address issues before they occur. Additional attention may be needed only if businesses want to adjust configurations or address performance lags.

Oracle GoldenGate instantly replicates data changes from primary databases to secondary ones, ensuring real-time updates across systems. Its monitoring features detect issues promptly, minimizing downtime. Overall, GoldenGate provides reliable real-time data integration, enhancing business processes efficiently.

In one organization, we employed Oracle GoldenGate for data replication. We opted for a three-way setup to integrate data between source and target databases without directly impacting either side. Placing an intermediary server between the source and target, we configured GoldenGate parameters. This allowed data to flow from the source to the intermediary server and then to the target, meeting our specific requirements. Depending on cost considerations, we sometimes chose a simpler two-way replication directly from source to target. 

The conflict detection and resolution feature of Oracle GoldenGate ensures that data replication tasks are executed seamlessly without any conflicts. This results in a flawless data replication process for customers, leading to a positive experience without any complaints or issues related to data consistency or integrity.

I would recommend considering Oracle GoldenGate for real-time data replication, especially if cost is a factor compared to DataGuard. Additionally, GoldenGate is easier to manage with the right technical expertise. Training the team on managing it can streamline operations and provide business advantages.

Overall, I would rate Oracle GoldenGate as a ten out of ten.

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.

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.

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'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.

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.

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.