Oracle GoldenGate Reviews

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

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.

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.

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.

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. 

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.