CData Sync vs. Oracle GoldenGate

Well: Upsert Less: Critical data with no interruption of the service

Incentivized

Oracle [GoldenGate] is well suited for data replication where real-time results are important, such as data reporting. There is potential to have the users query the replicated database, which can have separate resources set up to be compressed or using lower performing or cheaper resources. As mentioned, columns with LOBs can become a headache, as they will need to be synchronized in their own group many times. Tables containing data in CHAR, VARCHAR, NUMBER, DATE, or other non-LOB columns, however, are able to be replicated quite seamlessly. [Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.

Incentivized

• UPSERT
• Friendly interface

Incentivized

• OGG can be used and integrated with heterogeneous databases as well as homogeneous databases.
• OGG is easy setup as well as easy learning curve
• OGG supports large databases
• OGG support many uses cases (topologies) such as unidirectional replication, bidirectional, peer-to-peer, Broadcast, Cascading replication etc.
• OGG can be used not only for CDC (change capture), can be used to full load

Incentivized

• Although efficient for SQL servers and MySQL, as well as Snowflake. It is not strong for other database engines, and an upgrade on this would do a lot.
• The installation process is manual as opposed to the cloud installation it should be.
• A feature of syncing auto increment ID key, that will help in existing data management.

Incentivized

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

Incentivized

Oracle GoldenGate is a core part of our business.

Incentivized

It is easy to setup and use

Incentivized

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.

Incentivized

Oracle GoldenGate has only gone down for us when the data being sent was bad.

Incentivized

Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

Tableau is another similar software tool, unlike CData Sync, rather transforms data into actionable insights. While CData Sync works with automation, Tableau uses a drag box on its AVA, which in turn slows the work speed on the syncing of data. Over the years, I enjoyed the friendly and customizable option of CData Sync over Tableau's.

Incentivized

Oracle is tightly integrated with Oracle Exadata and is a better fit for using Oracle databases.Both products support heterogeneous databases but using Exadata, it just seemed to make better sense to use the Oracle GoldenGate product. We also take advantage of the Oracle GoldenGate Veridata product to compare datasets and make sure they are still in sync.

Incentivized

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.

Incentivized

• Reserves resources by covering human power via its automated sync method.
• Saves time: on launching data collectively into a compatible domain.

Incentivized

• Oracle GoldenGate guarantees our standing-by database in passive data center, is always in "pre-warmed" status, as the data is always in-sync with the master database in our active data center. At any time, the standing-by database can kick in in case the active DC encounters the serious issue. This significantly increases the IT application's high availability and promise to "business as usual".

Incentivized