Technical Prerequisites #

There are a few prerequisites that need to be fulfilled on the SAP side, when using ODP. SAP released a number of SAP notes that apply when using Xtract ODP component:

About Xtract ODP #

The Xtract ODP component can be used to extract data via the SAP Operational Data Provisioning (ODP) framework.

ODP is a framework in SAP ABAP applications for transferring data between systems.
ODP provides a technical infrastructure for data extraction and replication from different SAP (ABAP) Systems e.g.:

  • ECC
  • S/4 HANA
  • BW
  • BW/4 HANA

The Xtract ODP component, which requires the data, acts as a so-called subscriber (consumer). The ODP component subscribes to a data provider, for example to an SAP Extractor or to a CDS View.

Operational data provisioning supports mechanisms to load data incrementally, e.g., from extractors, ABAP CDS Views and aDSO objects (see below). With SAP BW/4HANA, Operational Data Provisioning (ODP) becomes the central infrastructure for data extraction and replication from SAP (ABAP) applications to an SAP BW/4HANA Data Warehouse.

ODP provides data transfer from the following providers (also called Provider Context):

  • ABAP Core Data Services (CDS) Views
  • BW and BW/4HANA InfoProviders
  • HANA Information Views in HANA based SAP Systems
  • DataSources and Extractors

Note: Depending on the connected SAP source system there are differences in available provider context.

The following example depicts the available provider context with BW /4 HANA connected as SAP source system. A BW or ECC system contains less options in the provider context list.

ODP Provider Context from an BW/4 HANA System

SAP Source Objects and Suitable ODP Contexts #

ODP context SAP Source objects
ABAP Core Data Services [ABAP_CDS] - CDS Views
SAP NetWeaver Business Warehouse [BW] BW/4HANA:
- DSO / aDSO
- CompositeProvider
- InfoObjects
- Query as InfoProvider
BW systems:
- CompositeProvider
- InfoCubes
- Semantically partitioned objects
- HybridProviders
- MultiProviders
- InfoSets
SAP HANA Information Views [HANA] - Analysis Views
- Calculation Views
- Associated Attribute Views
DataSources/Extractos [SAPI] - DataSources and Extractors

Suitable ODP contexts can be selected within the ODP Lookup window.

Xtract ODP - Functions Overview #

The window “Define Data Source for SAP ODP” contains several subsections:

  • Operational Data Provider - displays the name of the source object
  • Additional info - displays the ODP provider context and the data type of the source object
  • Update mode - defines the update mode, full or delta update
  • Fields - allows selection and setting of the filter options for extractors
  • Preview - Section with a real-time preview of the extraction data

Buttons

  • [Show active subscriptions ] - Button to display details on subscriber process
  • [Edit parameters] - Button to define run-time parameters that can be used as placeholders for data selections
  • [Load Live Preview] - Button to display a real-time preview of the extraction data without executing the extraction