ODP

This page shows how to use the ODP extraction type.
The ODP extraction type 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 ODP extraction type 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 ODP extraction type provides data transfer from the following providers (also called Provider Context):

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

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.
• Implement the following SAP notes to use ODP:
  • 1931427 - ODP Data Replication API 2.0
  • 2232584 - Release of SAP extractors for ODP replication (ODP SAPI)
  • 1560241 - Release of DataSources for ODP data replication API
  • 2196500 - ODP Package size cannot be reduced below 50 MB
  • 2191995 - ODQ Package Size cannot be reduced below 50 MByte
• DataSources have to be activated in SAP, see SAP Help: Activating DataSources in the SAP OLTP System.
• Before creating ODP extractions, test the ODP source in SAP using the ABAP report RODPS_REPL_TEST to rule out and troubleshoot ODP problems in the ODP source. For more information, see SAP Wiki: Replication test with RODPS_REPL_TEST.

Create an ODP Extraction

1. In the main window of the Designer, click [New] to create a new extraction. The window "Create Extraction" opens.
   
2. Select an SAP Connection from the drop-down menu in Source and enter a unique name for your extraction.
3. Select the extraction type ODP and click [OK]. The main window of the extraction type opens automatically.

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

Look up Data Objects

1. In the main window of the extraction type, click [ ]. The window “Operational Data Provider Lookup” opens.
   
2. In the field Name, enter the name of an extractor . Use wildcards (*), if needed.
   
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 extraction type.

Define the ODP Extraction Type

The ODP extraction type offers the following options for data extractions:

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

   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 Extraction Settings and the General Settings before running the extraction.
6. Click [OK] to save the extraction type.

You can now run the extraction, see Execute and Automate Extractions.

Related Links

• Youtube Tutorial: SAP ODP incremental load to SQL server