Oracle GoldenGate vs Winshuttle

• Ease of installation
• Ease of maintenance
• Powerful output with sub-second speed
• Supporting Big Data and Cloud environment
• Capturing source data based on transnational log, no cost on source CPU
• Handle the distribution and the delivery of committed data in real-time
• Supports heterogeneous systems regarding target or source database
• Can be implemented uni-directional, bi-directional or peer-to-peer mode
• Zero downtime migration
• Supports data distribution
• Can be used for disaster recovery or data protection

Read full review

• "Training" I feel Winshuttle was extremely easy to learn' my team and I went to a week long training class on the uses of the software upon finishing the course we all became internal (company) support as well as expert functional users.
• "Ease of use" once a user learns the basics processes of the software it is functionally very easy to use and if there are problems with in the processing that cannot be supported internally Winshuttle community and support quickly helped clear up those issues, "if they occurred"
• "Processes data FAST" once the transaction is mapped and recorded the user can move through (process) large amounts of data very quickly, saving lots of time by eliminating manual steps.
• "Data Error Correction" through the transactional processing of large amounts of data, nothing is ever perfect, usually during data migration process if a single line fails the process stops, the correction is made to the data and the process starts all over again. Winshuttle data migration process doesn't stop it will provide a list of exceptions upon completion of the data load. It does this by only processing the "good" data and when bad data is encountered it is skipped and an error message is created and added to the data sheet. With this process the user now only has to worry about exceptions that didn't load and also knows why the line failed so making correction are easier and faster.

Read full review

• Setting Up Oracle GoldenGate as HA in an Oracle RAC environment. While this is possible to do and there is documentation out there, I've found that specific Oracle GoldenGate and Oracle RAC experience is needed in order to make this happen. That level of experience does not exist everywhere.
• Monitoring Oracle GoldenGate. Currently there are two main options for monitoring Oracle GoldenGate, the first, GoldenGate Monitor, does not scale well as it becomes very non-performant when you have more than 10-15 GoldenGate Managers reporting to it, the second, Oracle Enterprise Manager, while getting better still requires a lot of manual configuration to have Oracle GoldenGate talk to the OEM agent. While this has got a lot better with 12c GoldenGate, I still feel that there is room to improve here.
• Unable to replicate certain Data Types. Again, less of an issue in 12c Oracle GoldenGate, but there are still some Data Types that Oracle GoldenGate is unable to replicate.

Read full review

• The use of Winshuttle is particularly helpful with systems where data volumes are always very high. If data volumes are not an issue, the use of Winshuttle for cut-over activities might not result in a significant perceivable difference in time savings.
• For businesses and sectors that rely on business processes that are complex and tedious with a lot of manual interventions, Winshuttle comes in real handy. However, in situations of fairly straightforward business cases, it would be hard to see perceivable gains from the use of Winshuttle.
• At times, the use of complex business process with multiple fields from one transaction needs to be fed into the next for further processing, if the screen sequence changes based on each set of information, the processing could fail. However, these could be overcome by grouping similar screened transactions into one chunk and others into another.

Read full review

• As Oracle GoldenGate integrated well with the Oracle products we were already using, we didn't need to spend additional time and money to purchase or develop an integration solution.
• XStream and Active Data Guard licenses come free with Oracle GoldenGate, reducing overhead costs.
• Eliminated the need to scale our workstations up in terms of hardware resources. Creating read-replicas to offload read requests gave more opportunities to scale horizontally.

Read full review

• We've been able to automate several time consuming, high volume tasks so that our analysts could focus on actual data quality and not data entry.
• We've been able to create reports and forego custom IT configuration by using Query and Transaction to come up with our own solutions.
• We've been able to pivot our strategy more quickly by easily adjusting and updating master data when processes change.

Read full review