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 three 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. Otherwise, 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 in the case of WODS, you must clear this checkbox manually.
If the Parallel Extraction checkbox stays checked, offloaded data will be not processed.
DTP definition requirements
Delta Load is not supported. In case Delta Load is selected as Extraction mode only Active data 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