Xtract Universal uses the following terms for its components:
|Extraction||Extractions are the main entities in Xtract Universal. An extraction is a combination of a source (SAP system), destination (e.g., SQL server) and a defined extraction type (e.g., Table). When running an extraction, the data that is defined in the extraction type is extracted from the assigned SAP source and written to the assigned destination. A list of all created extractions is displayed in the main window of the Designer.|
|Extraction Type||The extraction type defines what kind of SAP data is extracted by which method. Xract Universal offers 9 extraction types: BAPI, BWCube, BW Hierarchy, DeltaQ, ODP, OHS, SAP Query, Report and Table.|
|Source||A source represents a connection to an SAP System, see Creating an SAP Connection.|
|Destination||A destination defines how the extracted SAP data is processed. This could be a conversion to file-based formats for local or cloud-based file systems or to deliver the data to targets like databases and other APIs. For a complete list of available destinations, see Destinations.|
Basic Functionality - Architecture #
Using Xtract Universal contains two main phases: design phase and execution phase.
In the design phase the user can:
In the execution phase the user can:
- execute the extractions designed in the design phase.
- parameterize extractions that use runtime parameters.
The execution of the extractions takes place on the server.
Depending on the target environment an execution can be triggered either by the XU command line tool - xu.exe / xu.elf or by the consuming destination. For more information, see Pull and Push Destinations.
Find more information in the following subsections: