SAS Data Management vs. Winshuttle

When data is in a system that needs a complex transformation to be usable for an average user. Such tasks as data residing in systems that have very different connection speeds. It can be integrated and used together after passing through the SAS Data Integration Studio removing timing issues from the users' worries. A part that is perhaps less appropriate is getting users who are not familiar with the source data to set up the load processes.

Incentivized

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.

• SAS/Access is great for manipulating large and complex databases.
• SAS/Access makes it easy to format reports and graphics from your data.
• Data Management and data storage using the Hadoop environment in SAS/Access allows for rapid analysis and simple programming language for all your data needs.

Incentivized

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

Incentivized

• Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
• Debugging errors from the logs is a complicated process.
• E-mail alert system is very primitive and needs customization to make it more modern,
• Cannot send SMS alerts for jobs.

Incentivized

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

Incentivized

We are happy with the software and its functionality. As a SAS-shop, DataFlux is a logical choice for complex data integration.

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

Incentivized

The main negative point is the use of a non-standard language for customizations, as well as the poor integration with non-SAS systems. However, there is no doubt that it is a high-performance and powerful product capable of responding optimally to certain requirements.

Incentivized

- 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

Incentivized

It worked as expected.

Incentivized

With SAS, you pay a license fee annually to use this product. Support is incredible. You get what you pay for, whether it's SAS forums on the SAS support site, technical support tickets via email or phone calls, or example documentation. It's not open source. It's documented thoroughly, and it works.

Incentivized

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.

Incentivized

No, I do not have it.

Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.

Incentivized

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.

Incentivized

• We have more users who can connect to the many different data sources.
• Our users do have existing SAS programming knowledge and that can carry over.
• Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.

Incentivized

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