(Glue-2411) DSO Fetchers

Owned by SNP
Nov 20, 2024
2 min read

DSO Fetchers use a standard DataStore Object as their data source. To read, you need to provide the DSO name and some additional parameters described in this document.

Supported DSO types:

Creating DSO Fetchers

Perform the steps provided under Creating Fetcher Objects and select DSO Fetcher from the Component implementation drop-down menu in step 7.

Activating DSO Fetcher

After creation, the object is in a saved state.

The following information is mandatory before the activation:

  • Source DSO

    • Name of the DSO for the data read

  • Delta type

    • Drop-down menu with all available delta types

    • For more information, see the chapter Delta type

  • Key deduplication

the following information is optional before the activation:

  • Filter definition

    • Checkbox for each field of the DSO that allows you to mark the field as relevant for selection before the extraction

       

  • Record mode selection

    • Specifies the filter on the technical InfoObject 0RECORDMODE

    • By default, the values for After-Image, Add, and New-Image are selected, meaning that only records with these technical values will be transferred

       

To transfer data regardless of the 0RECORDMODE value, you can either select all values or none.

This function is very useful when combined with Key deduplication function. See below for more information.

Key Deduplication

This function removes duplicate values from a single data load, keeping only the most recent value for each record. The “deduplication“ process uses the primary key of the active DSO table together with the selection of 0RECORDMODE values to ensure that only the most recent values are transferred during a single data load.
As a result, only the most recent data is read for further processing - respecting the current delta value.

To use this function, you need to select the Key deduplication option in the fetcher definition.