The following section gives an overview over the settings that can be changed for the ODP component. The settings can be changed in the window “Define data source for SAP ODP”. There are two ways to open the “Define data source for SAP ODP” window:

  • Create a new extraction (see Define an Extraction with the “SAP Table or View” component as an example)
  • In the main window of the designer, choose an existing ODP extraction and click [Edit].

The settings are located the left side of the window “Define data source for SAP ODP” under subsections:

  • Operational Data Provider
  • Additional info
  • Update mode

    ODP Settings

Operational Data Provider #

shows the name of the source object

Additional info #

Context
shows the ODP provider context

Type
shows the data type of the source object

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, in case there is none for this subscriber. Runs a delta update, in case there already is a delta initialization for this 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 one if required. Each extraction has an internal ID, which is part of the subscriber. If you then change the filter of an extraction after the delta initialization, this 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

Subscriptions #

To display more details about the subscriber process, depending on the product, either click Show Subscriptions / Show active subscriptions at the top or at the bottom of the “Define data source for SAP ODP” window:

Subscriptions


Tip: The information displayed in the “Delta Subscriptions for product” window can also be viewed in SAP transaction ODQMON.

ODP Subscriber

Column name Explanation
Queue Technical name of all subscriptions of a specific Theobald Software Xtract product (e.g., Xtract Universal).
Process Technical name of a subscription
R. (number of requests) Number of executed delta requests
Last request Timestamp of the last delta request
Created Timestamp of the init request

To delete a subscription click on the dustbin icon on the right side of the window.

Filtering - dynamic setting of the selection filters #

Filtering options are located in the window “Define data source for SAP ODP” under subsection Fields.
ODP Fields

The number of defined filters, e.g. [1], is displayed in the square brackets to the left of the field name under Selections.
Choose a field under Selections and click [Edit] to define a filter.
The window “Edit selection” opens.
ODP ABAP CDS View Filter Within the window “Edit selection” you can add new, edit and delete existing fiters.

Edit Parameters
#

  1. To display editing function for the parameters, depending on the product, click Edit Parameters either at the top or at the bottom of the window “Define data source for SAP ODP”.
    ODP Edit parameters
    The window “Edit Runtime Parameters” opens.
    ODP Add parameters
  2. Click [Add] (1) to define parameters which can be used as placeholders for data selections. These placeholders need to be populated with actual values at extraction runtime. This allows you to dynamically set filters at runtime.
    Tip: Parameter0..-n is the default naming for the added parameter. You can enter a name of your choice (see the given example: “p_MATNR”).
  3. Click on the drop-down menu (2) and assign one of the following data types to a parameter. The data types can, but don’t need to correlate to SAP data types.
    • String: This data type can be used for any type of SAP selection field.
    • Integer: This data type can be used for numeric SAP selection fields.
    • Flag: This data type can only be used for SAP selection fields, which require an ‘X’ (true) or a blank ‘‘ (false) as input value.
  4. Click [OK] (3) to confirm.
  5. To define the parameters, choose an item in the subsection Fields and click [Edit] (4). The window “Edit Selections” opens.
  6. Click [Add] (5). Filtering option fields open.
  7. Click the icon next to the Low and High input fields (6). If there are defined parameters, icon switches to the parameter icon.
    Clicking the icons switches the option between entering actual input values and entering defined parameters.
    ODP Selection With Parameters
  8. To check the defined parameters, click [Load live preview].
    If you have assigned parameters as selection filters, you are prompted to populate the parameters with actual values.
    ODP provide values

To display parameters within SSIS #

Parameters appear as properties of the Xtract ODP object as well as the SSIS Data Flow. The parameters and properties be populated at SSIS package runtime using standard SSIS functionality, such as expressions, variables, etc.
ODP properties