Oracle GoldenGate Reviews

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.

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.

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 it for a project involving data integration from two distinct sources within our factory. One source was an Oracle database, while the other was a MySQL database. Additionally, we incorporated data from a cloud-based Teradata system that Oracle had acquired. Our task involved configuring the data to create a unified data warehouse.

It's an incredible tool, as it's quite impressive to construct the gateway. The process is surprisingly quick, and it has been around for a considerable period. I would say it operates seamlessly, eliminating the necessity for any data transformation or Excel-related tasks. You can simply input the data and retrieve it effortlessly. The gateway allows for easy management, providing clear insights. It's truly reliable and stands out as an excellent tool.

One feature that stands out for me is the data center capability. Leveraging Azure servers, we can effortlessly synchronize data between servers, whether it's from one source to another. This is done seamlessly without the need for additional configurations, just a simple pump to facilitate the process. Another noteworthy feature is its adaptability to changes in the source, such as the addition of a new column or details in Oracle. There's no necessity to modify subsequent processes; a service adjustment suffices, streamlining the workflow. Its reliability is commendable, and maintenance is both straightforward and efficient. Additionally, it facilitates customization for specific market needs. Overall, it is not only user-friendly but also easy to comprehend in various aspects.

Having a graphical interface would greatly enhance the tool. A clean and user-friendly graphical interface based on common design principles would be beneficial. While the current interface is functional, incorporating a more visually intuitive design, perhaps inspired by widely used interfaces, would make it even more straightforward. Looking ahead to future releases, there are specific features I'd appreciate having. One such feature is the incorporation of pipelines, similar to those in Java, for seamless integration. Additionally, configuring for the Amazon Cloud is currently not straightforward; it often requires adding Python code to customize integrations. I would like to see an enhancement in this aspect, making the configuration process more straightforward and less reliant on intricate coding, particularly during meetings or collaborative sessions.

I have been using it for two and a half years.

The tool is generally highly reliable, although its performance is contingent on the specific environment it operates in. For instance, if the environment is not adequately configured or lacks necessary prerequisites, the tool's reliability may be compromised.

I would rate the scalability capabilities ten out of ten.

I would rate its customer experience and support seven out of ten.

Neutral

The initial setup wasn't overly complex.

Initially, it was deployed on-premise, but due to privacy concerns, we switched to the cloud as well.

The tool has proven to be a time and cost-saving solution. It is effective for current needs and is particularly valuable if you have a significant budget, say, a hundred thousand dollars. The return on investment would make it a worthwhile deal.

I would certainly recommend it. Overall, I would rate it nine 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.

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. 

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.