Show TOC

Notes about Transferring Data from SAP Source Systems Using ODPLocate this document in the navigation structure

You can use Operational Data Provisioning (ODP) to connect an SAP system, such as an ERP system, as the source system to the BW system. Communication is performed using RFC. DataSources are provided for use in BW using the ODP context for DataSources (extractors) (SAPI).

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

  • Communication between source and BW system and the configuration of data transfer are simplified. In this way communication using synchronous RFC, ALE/IDocs is skipped and the data trasnfer 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. The monitoring of the PSA 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 and can then be requested for an according time period again by DTP.
  • The Operational Data Provisioning Framework uses a unique technology for different consumers of the source data (for exmaple, BW and SAP Data Services).
Prerequisites

  • SAP systems that provide DataSources for BW using the Operational Data Provisioning Framework must have at least one of the following release levels:

    Release Level of Source Additionally Required SAP Note
    SAP NetWeaver 7.0 SPS 24 SAP Hinweis 1521883 Information published on SAP site
    SAP NetWeaver 7.0 EHP1 SPS 09
    SAP NetWeaver 7.0 EHP2 SPS 08
    SAP NetWeaver 7.3 SPS 08 SAP Hinweis 1931427 Information published on SAP site
    SAP NetWeaver 7.3 EHP1 SPS 05
    SAP NetWeaver 7.4 SPS 02

  • 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 during the data transfer using the ODP framework.

    Table 1: 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 transferred by the extractor is not divided up again for the transfer in order to reach the DTP package size exactly. Rather, the uncompressed size of the data package transferred by the DTP usually corresponds to that of 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 path GoTo Next navigation step Batch Manager Settings End of the navigation path.
    Target system of the batch job Not available
    Maximum number of data packages in a delta request Not available
    Table 2: 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 exactly one synchronous process. You can define the maximum number of work processes for posting to PSA (in BW system) in the InfoPackage on the tab page Processing 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 to you that you can monitor with transaction ODQMON.

Since the data transfer is not controlled using the qRFC outbound queue when using the ODP framework, you do not need any settings in the QOUT Scheduler (transaction SMQS).