(Glue-2002) Advanced DSO Fetcher

Owned by SNP
Last updated: Feb 13, 2020
3 min read

The Advanced DSO Fetcher uses an Advanced DSO as a data source. For data read you need to provide Advanced DSO name and some additional parameters described in this document.

The Advanced DSO Fetcher supports these types of Advanced DSOs:

  1. Enterprise data warehouse architecture

    1. Data acquisition layer (including corporate memory)

    2. Corporate memory - compression capabilities

    3. Corporate memory - reporting capabilities

    4. Data warehouse layer - delta calculation

    5. Data warehouse layer - data mart

  2. Classic objects

    1. Standard DataStore Object

    2. Write-optimized DataStore Object

    3. InfoCube

Creation of Advanced DSO Fetcher

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

Your system version needs to support Advanced DSOs in order to use this functionality.

Activation of Advanced DSO Fetcher

After creation, the object is in a saved state.

Mandatory inputs to be filled before the activation

  • Advanced DSO

    • name of the Advanced DSO for data read

  • 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

  • Filter definition

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

  • Recordmode selection

    • Recordmode 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.

In order to transfer data regardless 0RECORDMODE value, you can either select all values or none.

This functionality is very useful when combined with Key deduplication functionality. See how it works 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 semantic key of Advanced DSO together with the selection of 0RECORDMODE values to ensure that only the latest values are transferred during a single data load.
In the result, only the latest data, respecting the current delta value are read for further processing.

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