The following section describes the functions of the ODP component of Xtract for Alteryx.

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

About ODP #

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, which requires the data, acts as a so-called subscriber (consumer). The ODP component subscribes to a data provider, for example to an SAP Extractor or to a CDS View.

Operational data provisioning supports mechanisms to load data incrementally, e.g., from extractors, ABAP CDS Views and aDSO objects (see below). With SAP BW/4HANA, Operational Data Provisioning (ODP) becomes the central infrastructure for data extraction and replication from SAP (ABAP) applications to an SAP BW/4HANA Data Warehouse.

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

ODP context SAP Source objects
ABAP Core Data Services [ABAP_CDS] - CDS Views
SAP NetWeaver Business Warehouse [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

Note: Depending on the connected SAP source system there are differences in available provider context.

Technical prerequisites #

There are a few prerequisites that need to be fulfilled on the SAP side, when using ODP. SAP released a number of SAP notes that apply when using Xtract ODP component:

Tip: To get information on the basics of Xtract for Alteryx, refer to Getting Started with Xtract for Alteryx.

How to use the ODP component #

  1. Drag & drop the “Xtract ODP” component to your Alteryx workflow.
  2. Select an SAP connection, navigate to Selected Extraction and click [Edit]. The main window of the component opens.

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

Functions overview #

The window “ODP” contains the following subsections:
ODP Component

  • Operational Data Provider (1) - Search and display the name of the source object.
  • Additional info (2) - Displays the ODP provider context and the data type of the source object.
  • Update mode (3) - Defines the update mode, full or delta update.
  • Fields (4) - Allows selection and setting of the filter options for extractors.
  • Preview (5) - Click [Load Live Preview] to display real-time preview of the extraction data.

Buttons

  • [Show active subscriptions] - Displays details of the subscriber process.
  • [Edit parameters] - Defines runtime parameters that can be used as placeholders for data selections.
  • [Advanced Settings] - Includes the package size for the extraction.
  • [Load Live Preview] - Button to display a real-time preview of the extraction data without executing the extraction.

More information on working with the ODP component is provided in the following sections.


Defining an ODP Extraction

Settings

ABAP CDS Views

BW InfoProviders

HANA Views

Extractors