The Xtract IS DeltaQ component forms the top class of the BI components for SAP access by SSIS. With its help, the Extractor API in SAP R/3 can be addressed and in such, the functionality with which BW systems also secure their data supply from the production system can be used.
| - Real transaction-secure delta transfer of data
- Support of all master and variable data including own generic extractors
- No installation in SAP required
- All business contents are available immediately even though no application-specific knowledge (e.g. about the tables’ structure) is required.
| | | The following screenshot shows the editor for the data source 2LIS_12_VCITM. It provides the delivery positions. Three extraction modi are available: “Full” for a complete extraction (without delta); “Delta Init” for a delta initialization; “Delta” for the real delta update that is done via the R/3 delta queue (transaction RSA7).
[ Click on image to enlarge ]
Two pipelines are generated within the data flow. One for the actual data transport and one for the delta protocol. This makes it easy to document every extraction process.
The screenshot shows a DataViewer for both of the pipelines. This clearly depicts how the protocol for the respective request (upper window) proceeds in the one pipeline while the actual data transport is done in the other pipeline (lower window).
|
[ Click on image to enlarge ]
|
