The following section shows how to use the ODP component.

Look up Data Objects #

  1. Within the main window of the component “Xtract ODP” navigate to Operational Data Provider and click [Search] ( magnifying-glass icon) (1).
    The window “Operational Data Provider Lookup” opens. Datasource Sales Document Item Data (2LIS_11_VAITM)
  2. In the field Name (2) enter a name of an extractor using wildcards (*), if needed.
  3. Select a Context (3). 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
  4. Click [Search] ( magnifying-glass icon) (4) and select the extractor of your choice from the displayed list (5).
  5. Click [OK] (6) to confirm your input.
  6. Optional: Create selections by activating or deactivating fields (7). To add filters click the [Edit] option next to the fields. If your data source is Hierarchy, see Select Hierarchy for filter options.
  7. Click [Load live preview] (8) to display a live preview of the data without executing an extraction. Datasource Preview
  8. Before executing an extraction, check the extraction settings.

Note: To find DataSources, they have to be activated in SAP, see Activating DataSources in the SAP OLTP System.

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.

  • On delta initialization
    Checking the Extract data checkbox, allows extracting data when running a delta initialization. Leaving the 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

Note: TS_SEQUENCE_NUMBER is a technical primary key that can be added to the output. When working with identical data sets, the data set with the highest sequence number is the most current data set.

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)Between True if data lies (not) between the values of operand 1 and operand 2.
    In True if data is part of the content of operand 1. This operator is only available for List parameters.
  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.