(Glue-2108) Standard DSO to Storage Extractor

Owned by SNP
Last updated: Aug 17, 2021 by Marian Vidra
3 min read

Standard DSO to Storage extractor allows you to transfer data from standard DSOs to external storage.


To create Standard DSO to Storage extractor

  1. Go to Extractor Workbench.
  2. In the context menu of Standard DSO to Storage select Create Extractor.
  3. Specify the following parameters:
    • Extractor name – technical name of the extractor
    • Description – description of the extractor.
    • Extractor type – this value is predefined, for this type of extractor select the Standard DSO to Storage extractor.

    • Source InfoProvider – source from which the data is transferred. In this case standard DSO object.

      Only standard DSOs are supported by this extractor type. It's not possible to create this type of extractor using write-optimized DSOs or other InfoProviders than the standard DSOs.

    • Target table – name of the created target (Glue) table. For information on how to create a Glue table, see the chapter (Glue-2108) Create a Glue Table.

      If the fields of a target table, which you created for this extractor, were imported from an existing InfoProvider, they must include the row RECORDMODE of the data element CHAR1.

      If the row isn't included, you need to append it. You can find instructions on how to append rows, in the section Insert fields manually. This row is necessary for the Change log delta.  

  4. Specify a Package.

  5. For Standard DSO to Storage extractor only the Change log delta is supported and you cannot alter it to a different delta type. Define Delta parameters with these steps

    1. Click on Tools .
    2. Select the checkbox for the Record mode values that should be loaded from the Change log table of the specified DSO. 
    3. Confirm. For more information about Change log delta, see the chapter BW Delta Mechanisms.

  6. Optionally, you can select the checkbox "Automatically adjust target table structure" during extraction run, which will automatically alter the target Glue table in case any new InfoObjects were added to the source DataSource Object.

  7. The structure of the Glue table may be the same or it may differ from the source DSO:
    1. If the structure of a Glue table is the same as the structure of a source DSO, the field mapping is generated by Glue automatically. (For example, if the Glue table was created from fields of a source InfoProvider).

    2. If the structure of the Glue table is different from the structure of the source DSO, you might need to specify Field Mapping manually.
      In this case, fill in the fields which are missing or aren't set correctly in the column Source Table Field.
  8. You may change the transfer rule or edit the routine. For more information, see the chapter (Glue-2108) Transfer Rules.
  9. You may select fields, which are used for filtering (selection) of data by the Variant definition. More information can be found in the section Variant Selection.
  10. Before you use an extractor, save it and activate it. In the case you activate an unsaved extractor, it will be saved automatically before activation.
  11. The next step is to create a Variant.