(1809) Data Transfer Process (DTP) Including Offloaded Data
- SNP
- Anonymous
It is possible to transfer already offloaded data from a DataProvider to an InfoProvider through the standard DTP. In this kind of DTP load, offloaded data is read from a DataProvider, appended to other data and stored in the target InfoProvider.
The following four requirements must be fulfilled for a DTP load which includes offloaded data:
- SAP HANA Execution must be switched off in the DTP definition
The SAP HANA Execution checkbox must be cleared. If you execute the DTP with a selected checkbox, the HANA database handles all data processing without the application server. In the result, the functionality for reading offloaded data, isn't used at all.
See the figure DTP definition requirements for the correct settings.
- Parallel Extraction must be switched off in the DTP definition
By most types of objects, the Parallel Extraction checkbox is automatically switched off after the SAP HANA Execution is cleared. Only by the Write Optimized DataStore object (WODS) and ADSO - Data acquisition layer you must clear this checkbox manually.
If the Parallel Extraction checkbox stays checked, offloaded data will be not processed.
DTP definition requirements
- The Extraction Mode is set to "Full".
Delta Load isn't supported. In the case Delta Load is selected as the extraction mode, only data from the Active data table will be loaded.
- Some data of the DataProvider is successfully offloaded
This requirement means that at least one offloading request is successfully offloaded. If no request is offloaded, DTP will run as usual, but won't include any offloaded data.
Offloaded DataProvider
After successful execution of a DTP load, the DTP Monitor displays which data is from the offloaded DataProvider, as you can see in the next figure:
DTP monitor after load from offloaded DataProvider