Query & Extract Transactional SAP Data
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: .
Transactional SAP data use:
- Ad-hoc operational reporting
- Data firefighting driven by business-changes
- Prototyping steady-state BI reports
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.
Extract SAP data for Immediate & Accurate Analysis
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. :
Select, Map and Run.
| 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. |
| 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 |
