The following section shows how to use the Xtract ODP component.

Look up Data Objects #

  1. Click magnifying-glass. The window “Operational Data Provider Lookup” opens.
  2. Enter a name of an extractor in the field Name (1). Use wildcards (*), if needed. Datasource Sales Document Item Data (2LIS_11_VAITM)
  3. Select a Context (2). Depending on the connected SAP source system there are differences in available 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
    SAP LT Queue Alias [SLT~your_queue_alias] - SAP Tables
    - Views
    - Cluster tables
    - Pool tables
  4. Click magnifying-glass and select the extractor of your choice from the displayed list (3).
  5. Click [OK] to confirm your input.

The application now returns to the main window of the component.

Note: To find DataSources, they have to be activated in SAP.

Define an ODP Extraction #

  1. Optional: Create selections by activating or deactivating fields (4).
    To add filters click the [Edit] option next to the fields. If your data source is a Hierarchy, see Select Hierarchy for filter options.
  2. Optional: To create delta extractions, select the corresponding Update Mode.
  3. Click [Load live preview] (5) to display a live preview of the data without executing an extraction. Datasource Preview
  4. Before executing an extraction, check the extraction settings.

Update Mode #

Full update:
Extracts the data in full mode

Note: The Delta update option is ready for input only if the ODP provider in the SAP source system supports delta updates.

Delta update:
Runs a delta initialization, if no delta initialization is available for selected subscriber. Runs a delta update, if there is a delta initialization for the selected subscriber.

  • Extract data
    Allows extracting data when running a delta initialization. Leaving this checkbox unchecked runs a delta initialization without extracting data.
  • Auto-sync subscription
    Allows deletion of the existing subscription and creates a new subscription, if required. Each extraction has an internal ID, which is part of the subscriber. If you change the filter of an extraction after the delta initialization, the Auto-sync subscription option automatically deletes the existing subscription and creates a new one. A subscription is deleted, if the error message “Illegal change in selection parameters” returns from the SAP system.

Delta recovery:
Re-runs the last delta update

Direct read (without ODQ):
Directly reads all available data, bypassing the ODQ (Operational Delta Queue). Direct read is the only update mode that supports data aggregation functions (Maximum, Minimum and Sum).

Selections and Filters #

  1. Choose an item in the subsection Fields of the main window of the component and click Edit. The window “Edit Selections” opens.
    ODP Fields
  2. Click [Add] to add a new filter criterion.
    ODP Selection With Parameters
  3. Select Include in the Sign column to only include the filtered data to the output.
    Select Exclude in the Sign column to exclude the filtered data from the output.
  4. Select an operator in the Option column. The operator filters data according to the table below.

    Operator Meaning
    (Not)Equal True if data is (not)equal to the content of operand 1.
    GreaterOrEqual True if data is greater than or equal to the content of operand 1.
    GreaterThan True if data is greater than the content of operand 1.
    LessOrEqual True if data is less than or equal to the content of operand 1.
    LessThan True if data is less than the content of operand 1.
    (Not)ContainsPattern True if data matches (does not match) the pattern in operand 1. Wildcards (*) are supported, but need to be preceded by at least one letter or number, e.g., PR* works, *PR* does not.
    (Not)Between True if data values do (not) lie between the values of operand 1 and operand 2.
  5. Enter static values or select runtime parameters for filtering.
    • Static values: Enter values directly into the Low and High input fields. If runtime parameters are available, make sure that the static-value icon is displayed next to the input field. Clicking on the icon switches between static input values and runtime parameters.
    • Runtime Parameters: Click on the static-value icon to change the input type to parameters ( dynamic-value icon). If no icons are displayed, open the Edit Runtime Parameters menu and create runtime parameters.
      Select a runtime parameter from the drop-down list.
  6. Click [Load live preview] to check the results of the filters.
    If runtime parameters are defined, you are prompted to populate the parameters with actual values.

The number of defined filters is displayed in square brackets next to the Edit option.