ODP(OData)

This page shows how to use the Xtract ODP(OData) component.
The Xtract ODP(OData) component 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 IS 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.
• Use an XTRACT_ODATA connection manager.

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.

Add an Xtract ODP(OData) Component

Follow the steps below to add an Xtract ODP(OData) component to your SSIS package:

1. Drag&drop the Xtract ODP(OData) component from the SSIS toolbox into your data flow task.
   

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 OData Services

1. In the main window of the component, 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 component.

Define the Xtract ODP(OData) Component

The Xtract ODP(OData) component 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 Settings before running the SSIS package.
6. Click [OK] to save the component.

You can now run the SSIS package.