(Glue-1911) Extraction Process

Owned by SNP
Oct 14, 2019

Extraction Process object handles the transformation of the data. The transformation is executed between acquiring the data through (Glue-1911) Fetcher and storing the data through (Glue-1911) Consumer.

Extraction Process serves also for the execution of an extraction and monitoring of launched extractions.

Creation of Extraction Process object

  1. Run the transaction /DVD/GL80 to open (Glue-1911) Object Navigator
  2. Right-click on the desired package and select option Create Extractor 2.0 object
  3. Enter the name of the new Extraction Process in Object name and short information about it in Description
  4. Select Extraction Process in Component type dropdown and in Component implementation leave the default implementation
  5. Confirm the popup

Activation of an Extraction Process

After the creation, the object is in the saved state.

Mandatory parameters to filled before the activation

Mandatory buttons to press before the activation

  • Suggest Mapping
    • button in the toolbar of Transformation part 
    • generate mapping based on the filled Fetcher and Consumer

Optional inputs before the activation

  • Start Routine
    • button in Transformation toolbar for ABAP code editor
    • executed before the transformation part of the extraction
  • End Routine
    • button in Transformation toolbar for ABAP code editor
    • executed after the transformation part of the extraction
  • Rule

Additional functionalities of Extraction Process

Extraction Process provides besides the Common functionalities of Extractor 2.0 objects also few others functionalities.

Execute extraction

Execution of the extraction is done by the pre-generated report, based on the Execution Process. Therefore each report can contain different input parameters.

The pre-generated report has an execution button and can have 4 sections of inputs:

  • Basic parameters - section for general settings of the extraction
    • Preview mode
      • enabled, data will be not written to the target but only the sample will be displayed on the screen
    • Package size
      • number of rows selected for each package of package based source
    • Package size MB
      • input for number of MB, with compute button Calculate
  • Selection filter - section is generated based on the selection in the specific (Glue-1911) Fetcher
  • Additional Fetcher config - section generated for editable parameters of the (Glue-1911) Fetcher
    • Load type
    • Use cursor
      • enabled, data from the source will be processed by the packages 
  • Additional Consumer config - section generated for editable parameters of the (Glue-1911) Consumer
    • Truncate target
      • enabled, all data will be deleted from the target before writing from the source

Press of the execute button will raise the pop-up with two buttons for execution type and cancel button:

  • Dialog - the extraction will be executed in a dialog process
  • Background - pop-up with a schedule will be displayed and after the confirmation, the extraction will be executed in the background process

Monitor 

 Monitor provides detailed information about each executed extraction of current Extraction Process:

  • Request - unique identification of an execution
  • Name - name of the Extractor 2.0 object
  • Mode - mode on which the execution was executed (Dialog/Background)
  • Status - icon which indicates in which state the execution is
    • Running - red truck
    • Success - green square
    • Failed - red circle
    • Error - yellow flash
  • User - name of the user which executed the extraction
  • Start date -  start date of an execution
  • Start time -  start time of an execution
  • Runtime - time of the duration of an extraction in seconds
  • Rows read - number of read rows
  • Rows written - number of written rows
  • Test mode - sign if the extraction was executed only in test mode

For detailed information about an execution flow of the extraction double-click on the desired request row.