ODP(OData)

This page shows how to use the ODP(OData) extraction type.
The ODP(OData) extraction type can be used to extract ODP-based data via OData services.

About ODP via OData

Open Data Protocol (OData) is a web protocol for querying and updating data. OData can be used to access the Open Data Provisioning (ODP) framework and extract ODP data, e.g., Hierarchies, Tables, Views, DataSources, etc.

To extract ODP data via OData, a corresponding OData service is required. The data model of the service specifies, which data sets are accessible and how the data is structured. Once the service is registered in the SAP Gateway system, Xtract Universal can consume the service.

For more information, see SAP Help: ODP-Based Data Extraction via OData.

Prerequisites

• OData services for ODP extractions are available in the SAP system, see SAP Help: Generating a Service for Extracting ODP Data via OData.
• To extract a DataSource, the DataSource is activated in SAP, see SAP Help: Set Up and Activate DataSources.
• Before creating ODP (OData) 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.

Supported Features

• All available ODP contexts of an SAP system are accessible.
• Delta extractions (with initial full load) if the ODP data source supports deltas, see Subscriptions.
• Data packaging for large amounts of data, see Package Size.
• Selections to filter the data before extraction, see Selections.

Limitations

Delta subscriptions are limited to one SAP user per service. The ODP framework has to be exposed in multiple different services for a single user to have multiple delta subscriptions.

Create a ODP(OData) 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 of type RFC from the drop-down menu Source.
3. Enter a unique name for your extraction.
4. Select the extraction type ODP(OData). The ODP(OData) extraction type is only available if the SAP source connection uses the OData protocol.
5. 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 OData Services

1. In the main window of the extraction type, click [ ]. The window “Service Selection” opens.
   

2. In the field Search pattern , enter one of the following characteristics:

   • name of an OData service
   • description of an OData service
   • name of the entity inside the OData service

   Use wildcards (*), if needed.
   

3. Click [Search] . Search results are displayed.

4. Select an OData service and click [OK] to confirm.

The application now returns to the main window of the extraction type.

Define the ODP(OData) Extraction Type

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

1. In the section Fields, select the items you want to extract.
   
2. Optional: Edit a selection you want to change or dynamize. For more information, see Edit Selections.
   
3. Optional: Activate the option Delta / Change tracking to initialize delta extractions. For more information, see Subscriptions.
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.