(Glue-2408) CDS Fetcher

Owned by SNP
Aug 20, 2024
3 min read

CDS Fetcher is a type of Fetcher in SNP Glue used to extract data from CDS views/entities. It supports the filtering of selected data and extraction of delta.

Prerequisites

  • SAP_BASIS 740 or higher

  • SAP_ABA 740 or higher

Creating CDS Fetchers

Perform the steps provided under How to Create a Fetcher Object and select CDS Fetcher from the Component implementation in the drop-down.

Activating CDS Fetchers

After creation, the object is in the saved state.

Mandatory parameters

  • CDS Name: Name of CDS. Can be found in CDS view. Do not use sql View Name. Use Value help to get available objects.

    image-20240816-124240.png
    Image of correct CDS Name for Fetcher

  • Delta Type: Drop-down menu with all available delta types. See Manage Delta for more information.

  • CDS Type: Either Generic or Delta Enabled. Defines how delta is handled.

 

Generic CDS Type

If Generic CDS Type is selected, delta type is configurable by user. See Manage Delta for more information.

NOTE: CDS Type Generic does not support TRIGGER Delta.

Delta Enabled CDS Type

If Delta Enabled CDS Type is selected, Delta type is determined by Glue automatically and cannot be changed by user. Delta type is determined by analyzing CDS annotations.

Currently supported Delta Annotations are:

  • Analytics.dataExtraction.delta.byElement - Delta by element specified as either DATE or TIMESTAMP.

    image-20240816-121742.png

  • Analytics.dataExtraction.delta.changeDataCapture - This refers to TRIGGER Delta. Change Data Capture is supported either by specified mapping or in automatic mode found in CDS annotations.

  1. TRIGGER: Delta type TRIGGER is used if CDS has “CHANGEDATACAPTURE” annotation either with mapping or automatic. In case of CHANGEDATACAPTURE with mapping there is a possibility that TRIGGERS on multiple tables are deployed. TRIGGER configuration is given by CDS itself and cannot be changed in Glue.

  2. TIMESTAMP: Delta type TIMESTAMP is used if CDS has “DELTA.BYELEMENT” annotation. Glue will automatically decide if element name provided in this CDS annotation is timestamp.

  3. DATE: Delta type DATE is used if CDS has “DELTA.BYELEMENT” annotation. Glue will automatically decide if element name provided in this CDS annotation is date.

Archiving using Trigger delta

There is a possibility to use trigger delta for archiving. 

Using this functionality, deleted records captured by a trigger are marked as archive instead of delete. When a record is archived, the deletion flag (by default GLDELFLAG field) contains the 'A' character.

If you want to use the archiving functionality, you must execute the extraction in the trigger delta mode with a specific user. The archiving users must be specified in the transaction /DVD/GL_SETT in the setting 'EXT2_ARCHIVING_USERS'  separated by ',' delimiter.

If a trigger delta is already initiated, changing this setting will not take effect. To do so, you must reactivate the triggers. 

  • Selection

    • The checkbox for each field of the CDS allows you to mark them relevant for selection before the extraction.