(Glue-2308) DSO Fetcher

Owned by SNP
Aug 23, 2023
2 min read

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

Supported DSO types:

Creation of DSO Fetcher

Perform the steps outlined in the chapter How to create a Fetcher Object with the DSO Fetcher option selected under the Component implementation dropdown of step 4.

Activation of DSO Fetcher

After creation, the object is in a saved state.

Mandatory inputs to be filled in before activation

  • Source DSO

    • Name of DSO for data read

  • Delta type

    • Dropdown menu with all available delta types

    • For more information see Delta type

  • Key deduplication

Optional inputs 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

    • Record mode selection specifies the filter on 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 functionality is very useful when combined with Key deduplication functionality. More details on this topic can be found in the section below.

Key deduplication

This functionality removes duplicate values from a single data load, keeping only the latest 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 latest values are transferred during a single data load.
As a result, only the latest data, respecting the current delta value are read for further processing.

To use this functionality, you need to check the Key deduplication checkbox in the fetcher definition.