The following section shows how to use the ODP component.
Look up Data Objects #
- Within the main window of the component “Xtract ODP” navigate to Operational Data Provider and click [Search] ( icon) (1).
The window “Operational Data Provider Lookup” opens.
- In the field Name (2) enter a name of an extractor using wildcards (*), if needed.
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
- Query as InfoProvider
- Semantically partitioned objects
SAP HANA Information Views [HANA] - Analysis Views
- Calculation Views
- Associated Attribute Views
DataSources/Extractors [SAPI] - DataSources and Extractors
- Click [Search] ( icon) (4) and select the extractor of your choice from the displayed list (5).
- Click [OK] (6) 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, see Activating DataSources in the SAP OLTP System.
Set Up an ODP Extraction #
- 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 a Hierarchy, see Select Hierarchy for filter options.
- Optional: To create delta extractions, select the corresponding Update Mode.
- Click [Load live preview] (8) to display a live preview of the data without executing an extraction.
- Before executing an extraction, check the extraction settings.
Update Mode #
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.
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.
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 #
- Choose an item in the subsection Fields of the main window of the component and click Edit.
The window “Edit Selections” opens.
- Click [Add] to add a new filter criterion.
- 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.
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 values do (not) lie 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.
- 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 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 icon to change the input type to parameters ( 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.
- 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.