Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
$250
Per License
Winshuttle
Score 7.5 out of 10
N/A
Winshuttle is an SAP-focused data management and robotic process automation platform. It is designed to enable the building and adaptation of Excel and SharePoint-based interactive forms and workflows for SAP without programming.
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.
Winshuttle is well suited to help any company who has data that needs to move from SAP to 'somewhere'. The output file can be Excel, Text, or Access. Query has been greatly expanded in its ability to use SQL statements directly in the product at the 'pre-download' point. For example, you want to have one column do calculations on the data that is being pulled out of SAP via the Query and placed in a specific cell - this can be done - right in the Query script and the result will be produced in your receiving Excel file. I have another small scenario I call 'On the fly" uses. When our asset team had to change their depreciation on a very large number of assets mid-year, Winshuttle Transaction was very helpful. The update would have taken DAYS and lots of shredded nerves to update.
"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.
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.
Fantastic tool and honestly the best out there for the particular need. I cannot think of any reason we wouldn't renew as it truly offers the perfect solution to what is often a supremely difficult process. Also, I believe that from a cost perspective it is quite agreeable given the amount of benefit/ROI received
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.
- I have used Winshuttle Transaction and Direct and the interface is simple, intuitive and easy to understand. - Not much technical knowledge of SAP is required before loading the data. - Data can be loaded for any sheet of an Excel spreadsheet - Output messages from Winshuttle are very clear and can be used to as an input to other data loads that use these output data
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.
The winshuttle staff are some of the best in the business. I have been working with them for several years and always have had a positive interaction. There support staff are very knowledgeable. There product managers are very supportive as well and always open to hear feedback on how you like the product and any gaps that you would like to find a solution to better improve the products.
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
Winshuttle works better with SAP than UiPath does in terms of performance and stability. The time to deploy a Process in Winshuttle is faster and less complex. It doesn't require coding skills as much as for UiPath. Winshuttle excels in batch input operations and also has a useful query reporting tool.
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.
