(Glue-2211) ODP Fetcher

Owned by SNP
Nov 09, 2022
2 min read

The ODP Fetcher uses an ODP Queue as a data source. For data reading it provides multiple Extraction Modes. It also supports the filtering of selected data.

Creation of ODP Fetcher

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

Activation of ODP Fetcher

After creation, the object is in the saved state.

Mandatory inputs to fill in before the activation:

  • ODP Queue
    • Name of the ODP Queue for data read
    • Provided with F4 help, filtered using context
    • Double click on the ODP queue will open Monitor Delta Queues (transaction ODQMON) with the respected queue and subscriber.
  • ODP Context
    • Name of the ODP Context also known as Provider in Monitor Delta Queues (transaction ODQMON)
    • Provided with a list box
    • Default value is SAPI (DataSources/Extractors)
  • Subscriber name
    • Name of the ODQ subscriber
    • Is configurable, the default is SNP GLUE
  • Subscriber process
    • Name of the subscriber process
    • Is configurable, the default is SNP_PROCESS
  • Execution mode
    • Mode of the execution can also be changed in the extraction process execution screen

Optional inputs before the activation:

  • Selection
    • Checkbox for each field of the ODP Queue that allows you to check them relevant for selection before the extraction

Extraction Modes

ODP Fetcher provides multiple Extraction (Replication) Modes: 

  • Full Load
  • Delta Load
  • Delta Init
  • Recovery of Previous Deltas


Please keep in mind that delta functionality is handled by ODP Queue, not by SNP Glue™ that doesn't store any delta pointers, but can reset delta for a given ODP Queue (e.g. when running delta Initialization with or without data transfer).  

Full Load 

All data from the source will be extracted and transferred to the target. 

Delta Load

Data from the source will be read according to Delta value. In case there is no Subscriber with provided Subscription connected to source ODP (transaction ODQMON), the Extraction process will make Full Load and initialize Delta.

Delta Init

Only the Delta value will be initialized, no data will be transferred.

Recovery of Previous Deltas

Recovery of Previous Deltas is useful when the last delta extraction failed and should be repeated.

Every time the delta load is executed, a check is verifying if the last delta run finished successfully. If not, the delta mode will be automatically switched to Recovery of Previous Deltas. This was done in order to prevent potential data loss due to ODQ delta logic.