Even with the variety of business intelligence (BI) systems installed and operated at most companies, one of the top challenges reported by SAP end-users is the lack of easy access to real-time SAP data in the transactional system. The ability of end-users to easily query and extract transactional SAP data is critical for many purposes beyond BI for corporate performance measurement, including:
If an existing BI report or standard SAP report does not meet the data extraction requirements, the next best option is to access the transactional system data via the various SAP-provided tools such as the table browser (SE16/SE16N/SE17), SAP Query (SQ01 or SQVI), etc. Access to these transactions is, however, turned off for most users due to security issues around organization-level controls.
In the absence of other options, business users petition their technical teams to build a new BI report or to write a custom query to get to their data. This adds tremendously to the load of the already stretched IT support teams and the users never get their reports in a timely manner. querySHUTTLE was expressly designed to allow business users to securely and easily extract SAP transactional data into familiar Microsoft Excel and Access formats for immediate and accurate analysis.
A variety of governance features and performance tuning features in querySHUTTLE ensure that these user-generated queries have minimal impact on the SAP server performance.
| querySHUTTLE Features | Benefits |
| SOX-compliant security around user data access leveraging standard SAP security profiles without requiring SE16/SQ01/SQVI access | Not only preserves the table-level security in SAP, but also organizational-level security in a user's standard SAP security profile. See how in this video. |
| Dynamic processs optimization for query execution | Minimizes the performance impact of queries on SAP server |
| Easy-to-use software with extensive table and field search capability and an intuitive where-clause builder | Empowers business users to create their own queries |
| Single or multi-table extracts with automatic joins. Supports Transparent Tables, Cluster Tables, Pooled Tables, and Views | Flexible and powerful for many different purposes |
| Integrated scheduler | Allows off-line query execution and automated runs of routine extracts |
| Map and extract data to Excel, Access, text files, or XML | Complete flexibility in the output format |
Learn more about querySHUTTLE:
"With Winshuttle, you can import massive amounts of data directly from a spreadsheet, which is a format that employees know and understand. It's changed how we approach all kinds of SAP data” from mass changes to periodic data cleansing."
- Lynn Farrell, SAP HR and Payroll Manager, Southwark Council
"We're a victim of our own success. I'm adding another member to our team because of the sheer volume of data we're handling with transactionSHUTTLE. This solution has completely changed how we approach and manage many of our projects."
- Peter Hebert, manager of HR data management, RBC
"transactionSHUTTLE gives us the ability to do things we weren't able to do before. We have significantly reduced our manual data entry costs, reduced headcount, and minimized the burden on IT."
- Paul Cahill, Director of Information Technology, Hubbell Wiring Systems
"We have saved over $1 Million in avoided programming, reduced data entry workload costs and Service Level Agreement (SLA) costs."
- Chantal Gauvreau, Business Process Manager, SAP Center of Excellence, Canada Post
"Winshuttle offers the complete automation solution. It's easy-to-install, well-documented desktop software, with excellent technical support"
- Erin Stone, SAP FI/CO Senior Analyst, B. Braun
"Data entry is no longer an IT headache. Our users no longer blame our SAP system and instead fully embrace it."
- Rick Davis, Manager, Enterprise Systems
We now use the term "Winshuttling" to refer to any solution that makes our lives easier.
- Steve Walker, Manager of Supply Chain Systems, Under Armour