Welcome to the Online Help for Xtract Universal.
Xtract Universal is a tool for data extraction from SAP to various target environments. The extracted data can than be further processed e.g., in the context of business intelligence, data integration and data analytics.
Available Components #
The following overview shows, which components are available to extract data from SAP systems.
Extraction Types #
Xtract Universal offers a set of nine extraction types to cover a range of demands of SAP data extraction.
- BAPI accesses BAPIs and RFC function modules.
- BW Cube extracts data from SAP BW InfoCubes and BEx Queries.
- BW Hierarchy extracts Hierarchies from an SAP BW / BI system.
- DeltaQ extracts DataSources (OLTP) and extractors from ERP and ECC systems.
- ODP extracts data via the SAP Operational Data Provisioning (ODP) framework.
- Open Hub Services (OHS) extracts InfoSpokes and OHS destinations.
- Query extracts ERP queries. Note: not BEx queries supplied by BW Cube.
- Report extracts ABAP Reports.
- Table extracts data from SAP tables and views; allows joining several tables on the SAP side.
- Table Join - allows to join several SAP tables. The Join-process takes place entirely within the SAP system without downloading single tables.
Note: obsolete component! Use Table component instead.
Common scenarios when using the components depending on the type of the SAP source system:
| Extraction Type | ERP/ ECC | BW |
|---|---|---|
| BAPI | X | X |
| BW Cube | X | |
| DeltaQ | X | X |
| BW Hierarchy | X | |
| ODP | X | X |
| OHS | X | |
| Query | X | |
| Report | X | |
| Table | X | X |
Note: Further scenarios and combinations are possible.
More information on functions of Xtract Universal is provided in the following sections:
Introduction to Xtract Universal
Getting Started with Xtract Universal
Execute and Automate Extractions