Skip to content

ODP OData Services

This page shows how to use the ODP OData service type.
The ODP OData service type can be used to extract ODP-based data using 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.iQ can consume the service.

odp-odata

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

Tip

For information on how to create OData services that provide ODP based data, refer to the Knowledge Base Article: Create OData Services using the SAP Gateway Builder.

Supported Features

  • All available ODP contexts of an SAP system are supported, see SAP Help: ODP-Based Data Extraction via OData. This includes:
    • BW (SAP NetWeaver Business Warehouse InfoProviders)
    • DataSource / Extractors (Service-API / S-API)
    • ABAP CDS Views (ODP-CDS)
    • SLT (Subscriber/Replication)
  • 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 Filters.

Limitations

The following limitations apply to delta extractions:

  • Delta loads are supported for:
  • Delta subscriptions are limited to one SAP user per service. To enable multiple delta subscriptions for a single user, the ODP framework must be exposed via multiple services.

Prerequisites

Create a ODP OData Service

To create a new ODP OData web service in Xtract Universal.iQ:

  1. Open the Services menu.
  2. Click [Add Service].
  3. Enter a unique name and a description.
  4. Optional: Activate the checkbox Enable MCP Access and add an MCP description to expose the service via the Xtract Universal.iQ MCP Server.
  5. Select an existing SAP connection from the Connection dropdown. If no connection is available, create a connection, see Connect to SAP.
  6. Select ODP OData from the Type dropdown.
  7. Select a target environment from the Destination dropdown. By default, Xtract Universal.iQ services return SAP data in HTTP response of the service (HTTP destination).
  8. Click [Save].

The service is now listed in the Services menu.

Next, select the SAP object you want to extract.

Look Up an OData Service

To select an OData service from your SAP source system:

  1. Create a new service of service type ODP OData or edit an existing service.
  2. In the Source section of the service, click [Select Data Provider]. The "Select Data Provider" menu opens.
  3. Enter the name or description of an SAP OData service. Use wildcards ( * ) if needed.
  4. Click [Search] to display the search results.
  5. Select an SAP OData service from the list of search results. The "Select Data Provider" menu closes.

Xtract Universal.iQ loads and displays the metadata of the SAP OData service.

Next, configure the remaining service settings.

Configure the ODP OData Service

After creating the service, configure the service using the following workflow:

  1. Go to the output columns section and select the fields you want to extract. By default all fields are selected.
  2. Optional: Activate the option Delta / Change tracking to initialize incremental loads, see Subscriptions.
  3. Optional: Define filters to limit the result set of the service, see Filters.
  4. Optional: Edit the Service Settings to define how the data is extracted from SAP.
  5. Optional: Edit the Destination Settings to define the output of the service.

For more information, see ODP OData Settings.

Run and Automate the Service

Last update: September 17, 2026