Data Provisioning from SAP Systems with Operational Data Provisioning (New)

Using operational data provisioning source systems with context SAPI - DataSources/Extractors, you can provide DataSources (extractors) from SAP systems for transferring data to BW.

Data provisioning using operational data provisioning as an alternative to previous provisioning of DataSources from SAP source systems (using the service API) offers you the following advantages:

  • Communication between source and BW system and data transfer configuration are significantly simplified. Communication using synchronous RFC, ALE/IDocs is skipped and data transfer is not controlled using the qRFC outbound queue.
  • The operational data provisioning framework with the new (operational) delta queues takes over tasks and services that were previously covered by the Persistent Staging Area (PSA). The data transfer process (DTP) in particular can fetch data directly from the (operational) delta queues. This makes InfoPackages and loading using the PSA optional. PSA monitoring is triggered in this case by the delta queue monitor (transaction ODQMON).
  • Delta data of the application can be retained for a definable time period in the (operational) delta queue. The data can also be requested again during this time period by the DTP.
  • The operational data provisioning framework uses a standardized technology for different consumers of the source data (for example, BW and SAP Data Services).

DataSources from source systems with the SAP NetWeaver releases listed below are available as providers for the ODP framework and can be transferred from BW systems with SAP NetWeaver 7.4 SPS 05 and higher:

The DataSources must be released for data provisioning using operational data provisioning. The release is completed using report RODPS_OS_EXPOSE. For more information, see SAP-Hinweis 1560241 Information published on SAP site.

Configuration of Data Transfer

Different settings and functions are required for the data transfer from an SAP source system to BW. Customizing for extractors (transaction SBIW) is provided in the source system for this. However, note that the following settings and functions listed here are not relevant:

  • Maintain the Control Parameter for Data Transfer (table ROIDOCPRMS)

    The following tables show if and how the control parameters of the table ROIDOCPRMS are replaced when data is transferred using the ODP framework.

    Data Transfer Process
    Control Parameter in Table ROIDOCPRMS Setting for Transfer Using the ODP Framework
    Maximum size of data package A data package of 50 MB is requested by the extractor. The size of a data package to be transferred can be increased in the definition of the data transfer process on tab page Extraction. However, the data package passed by the extractor is not divided up again for the transfer, in order to achieve the DTP package size exactly. Instead, the uncompressed size of the data package transferred by the DTP usually corresponds to the largest multiplication of 50 MB that fits into the DTP package size.
    Maximum number of rows in a data package Not relevant
    Frequency with which the info IDocs are sent obsolete
    Maximum number of parallel processes for data transfer In the data transfer process, you can define the maximum number of work processes using Start of the navigation pathGoTo Next navigation step Batch Manager SettingsEnd of the navigation path.
    Target system of the batch job Not available
    Maximum number of data packages in a delta request Not available
    InfoPackage
    Control Parameters in Table ROIDOCPRMS Settings for Data Transfer Using the ODP Framework
    Maximum size of data package The size of the data package is set to 50 MB.
    Maximum number of rows in a data package Not relevant
    Frequency with which the info IDocs are sent obsolete
    Maximum number of parallel processes for data transfer The data transfer takes place in one single synchronous process. In the InfoPackage, you can define the maximum number of work processes to be updated to the PSA (in the BW system), by using the options on the Processing tab under Parallel Processing .
    Target system of the batch job Not available
    Maximum number of data packages in a delta request Not available
  • Check Delta Queue (transaction RSA7)

    In the ODP framework, there are (operational) delta queues available, which you can monitor with transaction ODQMON.

Since the data transfer is not controlled by means of the qRFC outbound queue when the ODP framework is used, you do not need any settings in the QOUT Scheduler (transaction SMQS).
Related Information