Likelihood to Recommend
I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.
Vice President, Chief Architect, Development Manager and Software Engineer
Read full review
Qlik Replicate works very well with relational data platforms, both on premise and in the cloud, for example Oracle, SQL Server, PostgreSQL, MySQL and others, it also works very well with DB2. If the data source is MongoDB, it is more complicated and currently there is no possibility of sending data to MongoDB.
Read full review Pros As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well. For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target). It is robust and the performance meets our SLA, even for a large amount of data volume. The error report is not only detailed but hits the right points, so trouble shooting is easy. Read full review Replicate is extremely stable and does not generate a lot of alerts/failures/issues that take up time to troubleshoot. It is very easy to add new source tables to a Replicate task so that we're always in sync with new data available from the CRM. It's nice that Qlik Replicate also allows you to create a job to stop and then restart your tasks during maintenance windows that occur on both the source and target systems. Read full review Cons The earlier versions of Golden Gate were complex to use as there was no front end. All that works was the command line. The cost of the product can be a detriment to most companies. The product has been augmented over the years and has so many features that it can be overwhelming. Read full review The base Replicate web GUI is lacking. If you have dozens or more tasks, it's hard to get a sense of how they're performing. Enterprise Manager solves all of these problems but is a separate install. The support portal is extremely difficult to navigate. It's hard to track down exactly what you're looking for. It would be helpful to have better documentation and example queries for the tables in the Enterprise Manager analytics database. Destination databases that don't support common DDL commands behave unpredictably. And the replication of schema changes isn't consistent. Read full review Likelihood to Renew
Oracle GoldenGate is a core part of our business.
Read full review
The availability of the replicated data in disparate environments has is now crucial. Replacing a product like Qlik Replicate would require significant time, investments, and work. In addition, Qlik Replicate is reasonably reliable with few failures.
Read full review Usability
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
Read full review
We now have greater business flexibility and scalability, and our big data integration projects have a quick rate of growth, which has been profitable for us. Independent of the sources involved, maintaining data consistency between sources is easy. One of my favorite features is the way it lets owners of the source system start and stop processes from updating their system windows.
Read full review Reliability and Availability
Oracle GoldenGate has only gone down for us when the data being sent was bad.
Read full review Performance
Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
Read full review Support Rating
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
Read full review
The issue I've had is that Qlik does an awful job of keeping their customers informed when new versions of the software are available. We found that we were using a version that was no longer supported and could never get help. When it came time to get us upgraded so that we were on a current version, no one knew how to help get us to where we needed to be. We had to purchased professional services time and even then I was basically on my own to get everything built out and set up. Qlik needs to be more proactive with communicating about new releases and how to get your version upgraded in the most secure, safe way possible.
Read full review In-Person Training
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
Read full review Online Training
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
Read full review Implementation Rating
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
Read full review
Follow the directions from the Qlik documentation. They are pretty straight forward and easy enough to follow. If you follow these, then you are not likely to have issues on implementation.
Read full review Alternatives Considered
We use Oracle Data Guard as a backup tool, but not for data replication. Data Guard is not suited for real-time data replication in our non-normalized reporting database nor for the database we are using for our upgrade project, as Data Guard is not able to transform data and is not able to synchronize data into different schemas, which is necessary for our project. Additionally, our project database is on Oracle 12g not 11i: I am not 100% sure Data Guard is able to replicate from 11i to 12g
Read full review
Great tool for data replication solution for Oracle/SQLServers/etc. Real easy to get it set up and start realizing business value. Getting the PoC accomplished in a short window. Product costing and easy to start small and scale as needed. It helped cover most of our ask compared to other solutions.
Director -Enterprise Architect and Technology Strategist
Read full review Scalability
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
Read full review Return on Investment In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables. But both issues are solved now. Installation is straightforward, easy. Deployed everything within Oracle Data Integrator. Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days. Management Pack and VeriData are additional packs for your management and data verification needs. Read full review Prior to using Qlik Replicate, we used an ETL solution to copy data from the Oracle ERP system to the Microsoft SQL Server BI system at a 15-minute interval. It was very tedious to maintain. Qlik Replicate is much easier to use and we replicate data near real-time now. Read full review ScreenShots Qlik Replicate Screenshots