Oracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis.
$250
Per License
VirtaMove
Score 10.0 out of 10
N/A
VirtaMove (formerly AppZero), offers the eponymous VirtaMove Migration Intelligence Suite allowing the user to move legacy apps to modern, secure servers.
Vice President, Chief Architect, Development Manager and Software Engineer
Chose Oracle GoldenGate
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 …
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 …
They are system-limited. Oracle GoldenGate provides more flexibility to use in different use cases and topologies. Most of the other tools are not matured like the Oracle GoldenGate. Oracle GoldenGate is best compared to other tools in terms of high performance, configuration …
We evaluated Data Guard since we were in the market for replication during disaster and recovery. [Oracle] GoldenGate has much more features besides what we indented to use it for and has helped us with different ways to present our application to our clients.
Oracle GoldenGate is the preferred solution for streamlining cross-platform data replication; with Autonomous Database, Data Pump import and export can provide similar results but are less robust and require much more customization. Data Pump does provide a great degree of ease …
It wasn't easy to set up replication to a message queue using SharePlex. We had challenges using the product when the application was doing a lot of "rollbacks to savepoint". SharePlex always showed a lag. When I was testing SharePlex, there was no way to offload the workload …
We evaluated SQData, Dell Shareplex and some other replication software. OGG was our choice for breadth of services and wide range of RDBMS and Big Data solutions it supports.
Oracle GoldenGate is a data integration and virtualization management solution for all businesses. It offers real time data integration and replication services for IT management. We liked Oracle pricing model since we already have a working relationship with them. Training was …
SharePlex offers a cheaper alternative and is sometimes faster performing as well for simpler replication needs, but Oracle GoldenGate comes with tonnes of features that I have not seen in any other competing technology. OGG offers real time flat file generation, integration …
I don't believe that there is a product that can match the capabilities of Oracle GoldenGate. As I stated earlier, it has so many use cases because of the ability of the product to handle the logical transformation of data from source to target. It can be used for DR but that …
I have not use any other application for this purpose. I've selected AppZero based on peer recommendation and found it to fulfill the functionality I was looking for.
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.
Best suited for applications where installing from scratch is not an option or a very difficult one. Migrating applications that you are familiar with, you have support for or have done in the past, via AppZero, in my experience, may become more time/resource consuming. In my environment it makes little sense for example to migrate an Office Suite via AppZero. Good at collapsing tiers (e.g. old application whose demand has waned and it no longer needs to serve large number of users). The score is awarded is a bit misleading, AppZero is invaluable when you have no other choice but for mainstream applications its value drops.
When documentation regarding the implementation of an application is missing (e.g. old versions and support is prohibitive to obtain, or in case of homegrown applications) it becomes the tool available to perform the migration.
There is always a back-out option, and different approaches/attempts can be made.
Will provide you insight on what otherwise would be a "blackbox" application.
Allows you to consolidated multi-tiered applications into fewer/single tiers.
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.
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.
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.
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.
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.
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.
I have not use any other application for this purpose. I've selected AppZero based on peer recommendation and found it to fulfill the functionality I was looking for.
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.
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".
It has certainly proved to be a worthwhile investment. There were cases where to migrate an application several versions behind with lapsed support would've been a many zeroes expense. Done via AppZero, it was a LOT cheaper.
