/
(Glue-2408) Advanced DSO Fetcher

(Glue-2408) Advanced DSO Fetcher

Owned by SNP
Aug 20, 2024
3 min read

Advanced DSO Fetchers use an Advanced DSO as their data source. For the data read, provide the Advanced DSO name and some additional parameters described in this document.

Advanced DSO Fetchers support the following 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

Creating Advanced DSO Fetchers

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

Your system version must support Advanced DSOs to use this function.

Activating Advanced DSO Fetchers

After creation, the object is in a saved state.

The following information is mandatory before the activation:

  • Advanced DSO

    • Name of the Advanced DSO for the data read

  • Delta type

    • Drop-down menu with all available delta types

    • For more information, see the chapter Delta type

  • Load type

    • Default extraction type

    • Can be changed before each extraction

    • For more information, see chapter Load type

If Delta is set to REQUEST, it is possible to run extraction also when ADSO has active requests

The following information is optional before the activation

  • Filter definition

    • Checkbox for each field of the Advanced DSO that allows you to mark the fields 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 the Key deduplication function. See below for more information.

Key Deduplication

This function 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 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 must select the Key deduplication option in the Fetcher definition.

Not all types of Advanced DSO templates support this function.

The following Advanced DSO templates are supported:

Corporate memory: Compression capabilities
Corporate memory: Reporting capabilities
Data warehouse layer: Delta calculation

 

It is possible to adjust the structure of the SNP Glue Table consumer automatically when it is used in combination with an Advanced DSO in the Extraction Process. For more information, see the chapter Automatically Adjusting the Consumer Structure. 

 

Related content