The SAP Table Fetcher uses an SAP table as a data source. For data read provide multiple Delta types and Load types. It also supports filtering on selected data.
Creation of an SAP Table Fetcher
Perform the steps outlined in How to Create a Fetcher Object with SAP Table Fetcher as the option selected under the Component implementation dropdown of the step 4.
Activation of an SAP Table Fetcher
After creation, the object is in the saved state.
Mandatory inputs to be filled before the activation
- SAP Table
- name of SAP table for data read
- provided with F4 help
- Delta type
- a dropdown menu with all available delta types
- for more information see Delta type
- Load type
- default extraction type
- changeable before each extraction
- for more information see Load type
Optional inputs before the activation
- Selection
- checkbox for each field of the SAP table that allows you to mark them relevant for selection before the extraction
Changes to Load type and Selection parameters won't deactivate Fetcher, only Extraction processes will be deactivated. This will preserve data for delta (if there is some).
Delta type
The SAP Table Fetcher provides multiple delta types:
- FULL, DATE, TMSTMP, VALUE, VALUE_DIST
- for more information see Manage delta
- TRIGGER
- for more information see Trigger delta type for SAP Table Fetcher
Trigger delta type for SAP Table Fetcher
For general information about this delta type see Trigger delta.
Trigger state
On activation of the SAP Table Fetcher with delta type TRIGGER, the saving of newly added records is not automatically turned on (mentioned in the link above).
There are two ways to do this:
- execute extraction with any Load type except the basic Full Load (Repair) Without Delta Update
- manually activate triggers through the use of the (Glue-2011) Trigger Management functionality accessible via the Manage Trigger button
The state of the trigger is also displayed next to Manage Trigger button. There are 3 different states in which the trigger can be: Active, Inactive, Inconsistent (can be repaired by reactivation of the trigger in Trigger Management).
Trigger delta additional settings
- Read deleted entries - when this is checked, also the keys of entries that were deleted since the last extraction will be read after entries that were inserted or updated.
- Deduplicate deleted entries - deleted entries, for which there were any inserts after the deletion, won't be transferred (not supported for cluster tables)
Trigger delta for Database Views
SAP Table Fetcher also supports trigger delta for Database Views. For this scenario to work, it is required to specify the trigger table name.
It must be one of the tables that is part of the Database View. It is strongly advised to have all key fields of the trigger table name in the output of the Database View. Otherwise, it might lead to a situation, where an excessive amount of data is replicated to the target storage. This is due to the fact that one entry in the shadow table might be translated into multiple entries from the Database View due to missing key fields in the output of the Database View.