Skip to content

ODP

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

About ODP

Operational data provisioning (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 acts as a subscriber (consumer) and subscribes to a data provider. ODP supports mechanisms to load data incrementally from data providers. For SAP BW/4HANA, ODP is the central infrastructure for data extraction and replication from SAP (ABAP) applications to an SAP BW/4HANA Data Warehouse.

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

Provider Context SAP Source Objects
ABAP Core Data Services [ABAP_CDS] - CDS Views
SAP NetWeaver Business Warehouse or BW4/HANA [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/Extractors [SAPI] - DataSources and Extractors
SAP LT Queue Alias [SLT~your_queue_alias] - SAP Tables
- Cluster tables
- Pool tables

Depending on the connected SAP source system there are differences in available provider contexts.
For more information on SAP ODP, see SAP Wiki: Operational Data Provisioning (ODP) and Delta Queue (ODQ).

Prerequisites

Note

The ODP API 1.0 has limitations compared to ODP API 2.0, e.g., ODP API 1.0 does not support the extraction of Hierarchy DataSources. For more information, see SAP Wiki: Limitation of ODP API 1.0.

Warning

Missing Authorization.
To use the Xtract ODP component, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects accordingly.

Add an Xtract ODP Component

Follow the steps below to add an Xtract Table component to your SSIS package:

  1. Drag&drop the Xtract ODP component from the SSIS toolbox into your data flow task.
    New
  2. Double-click the component. A connection manager is automatically assigned to the component and the main window of the component opens.

    Note

    If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

The majority of the functions of the component can be accessed in the main window.

Look up Data Objects

  1. In the main window of the component, click [ ]. The window “Operational Data Provider Lookup” opens.
    Open-Look-Up-ODP
  2. In the field Name, enter the name of an extractor . Use wildcards (*), if needed.
    Look-Up-ODP
  3. Select a Context . Depending on the connected SAP source system there are differences in available Provider Contexts.
  4. Click [ ]. Search results are displayed.
  5. Select an extractor and click [OK] to confirm.

The application now returns to the main window of the component.

Note

To find DataSources, they have to be activated in SAP.

Define the Xtract ODP Component

The Xtract ODP component offers the following options for data extractions:

  1. In the section Fields, select the items you want to extract.
    Datasource Preview

    Note

    TS_SEQUENCE_NUMBER is a technical primary key that can be added to the output. When working with identical data sets, the data set with the highest sequence number is the most current data set.

  2. Optional: edit a selection you want to change or dynamize. For more information, see Edit Selections.

    Note

    If your data source is a Hierarchy, see Hierarchy Segments for filter options.

  3. Select an Update Mode, e.g., to initialize delta extractions.

  4. Click [Load live preview] to display a live preview of the first 100 records.
  5. Check the Settings before running the SSIS package.
  6. Click [OK] to save the component.

You can now run the SSIS package.


Last update: July 4, 2024