SAPBIDataStore Extract
This extract retrieves transactional data stored in Data Store Objects (DSO). A DSO is an architectural component of a SAP BW system with a flat structure (flat table) and no star schema concept, such as InfoCubes. It generally contains granular data on a highly detailed level necessary for line item reporting. During the staging process, it is loaded before InfoCubes.
Note: In SAP BW/4HANA, DataStore Objects (classic) have been replaced with a new unified persistent object type, the Advanced Data Store Object (aDSO). Therefore, this extract type can no longer be used for BW/4HANA. In order to extract from aDSO, the extract types SAPTable (with a connection of type SAP), or Relational/RelationalTable (with a connection of type SAPHana) may be used.
Settings
Connection | Name of the SAP connection. |
Datastore | Name of the Data Store Object |
Filter | Filtering criteria for each field of the DSO (optional). The filtering criteria are described in the article Filtering with SAP Connector. |
Export data fields | Fields of the DSO that are extracted. Key fields and data fields are handled in the same way. |
Bulk size | Size of blocks for Jedox In-Memory DB Server write requests. |
Use caching | Memory, disk, or none (default). See Caching in Extracts. |
Example:
Updated July 8, 2024