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
Operational Data Provider #
shows the name of the source object
Additional info #
shows the ODP provider context
shows the data type of the source object
Update Mode #
extracts the data in full mode
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.
re-runs the last delta update
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:
Tip: The information displayed in the “Delta Subscriptions for product” window can also be viewed in SAP transaction ODQMON.
|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.
The number of defined filters, e.g. , 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.
Within the window “Edit selection” you can add new, edit and delete existing fiters.
- 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”.
The window “Edit Runtime Parameters” opens.
- 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”).
- 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.
- Click [OK] (3) to confirm.
- To define the parameters, choose an item in the subsection Fields and click [Edit] (4). The window “Edit Selections” opens.
- Click [Add] (5). Filtering option fields open.
- 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.
- 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.
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.