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 …
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 …
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 …
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 …
We chose GoldenGate initially because we have a heterogeneous database environment and it was very difficult to report across different data marts residing on different databases. Not only did it become very hard to maintain, the reports were also inaccurate and hard to …
SharePlex was a clear winner in comparison to its competitors. It beats GoldenGate on price, providing equivalent features and performance at a fraction of the price and without the need to license costly Oracle features at the database level. DB Visit was a strong contender …
At the time we did our proof of concept (2011), Shareplex was up and running within a couple of hours. The Goldengate techs were unable to get their product to work. Pricing for Shareplex was half of what Oracle quoted. Goldengate did not include monitoring or compare/repair …
SharePlex is more robust than GoldenGate when it comes to replicating the particular transactions in our environment. GoldenGate has the advantage of supporting hetrogeneous databases, but it does not apply to us since we use a single database platform in this setting. In …
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.
SharePlex really shines when set alongside GoldenGate. The licensing costs of the two products would appear to place them in entirely different ballparks yet they perform nearly identically in practice. SharePlex is suitable for heterogenous replication of one database to another. The list of targets is ever increasing, with support for all major RDBMS vendors as well as support for popular NoSQL and JSON replication. SharePlex is effective when replicating from on-premise to cloud. Whether that's migrating data, creating a high-availability presence in a public or private cloud, or populating a data mart, it does the job quite well.
When first introduced the Change Data Capture process was awkward. Each subsequent release has improved the process.
Sometimes the Shareplex monitoring service in Foglight gets overly aggressive in sending out error notifications and can end up spamming the admins with email alerts for one problem. We have had to tone that down.
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.
Support is very responsive. They take ownership of the problems and see them through to the finish. When a bug is found they work towards developing testing and making the fix available to us to solve the problem.
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.
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
SharePlex support is an award-winning team, which is available for 24 hours, and any time they have solutions with perfect expertise. Besides, SharePlex has supported data migration, with multiple reporting features that ensure there are comprehensive database evaluations. The simplicity of SharePlex installation also gives it a higher mark, is very efficient, and allows companies to understand it easily.
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.
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.