Loading Data from ODP Source Systems Directly into InfoProviders

In the data transfer process (DTP) maintenance screen, you can specify that data is not extracted from the Persistent Staging Area (PSA) of the DataSource. Instead the data is requested directly from the data source at DTP runtime and then transferred to the InfoProvider. The function is mass data and delta compatible.

The flag Do not extract from PSA; use direct access to data source is displayed if the DTP source is a DataSource and the source system is an operational data provisioning (ODP) source system. Using the ODP data replication interface and this function allow you to extract mass data. If the source returns deltas, as is the case for example with ODP contexts BW and SAPI, extraction is also supported in delta mode.

With this function, it is no longer necessary to use InfoPackages to load data to the Persistent Staging Area (PSA) unless you require semantic grouping of the data when loading. To ensure this, the source of the DTP must have persistence in the BW system.

Note

Direct loading in Full mode is only supported for the ODP contexts SAP HANA and SAP Business ByDesign. These contexts do not offer any deltas in the source.
If errors occur during processing, you need to extract the data again in BW because the PSA is not available in the buffer.
For delta DTPs: You can delete requests from a delta DTP in any order. The data records contained in the request set for deletion are not requested from the source any more however with the next delta request. The next delta request requests new data from the source. To ensure that the next delta request returns the data records processed by the request that you want to delete, proceed as follows:
1. Set the retention period for data in the monitor for operational delta queues in such as way as to ensure that the processed data from the request to be deleted is still in the source.
2. Then delete the request in the administration view of the target system, together with the newest request and all requests inbetween.
The next delta request will then request all data available in the source again, in accordance with the deleted request and the request after this.
For delta DTPs: in the delta queue of the source system, the data is deleted during delta queue reorganization after a certain retention period has elapsed and after the data has been updated to the BW system. When deleting requests in the InfoProvider, you should therefore bear in mind that you might not be able to retrieve the data from a request in the source system any more. If the data of deleted requests in the delta queue can no longer be retrieved, you have to delete all the delta requests of the same DTP from the InfoProvider and execute a new delta request, in order to start delta initialization.