(Glue-2005) Glue Settings

Owned by SNP
Jun 02, 2020

You can open Glue Settings from Glue Cockpit (transaction /DVD/GLUE) by clicking on the setting's icon (Ctrl+Shift+F7), as shown in the screenshot below. You can also do it simply by running transaction /DVD/GL_SETT. Also, you can click on "Goto" toolbar menu and select "Glue Settings" item.

Glue Main Settings

Once the transaction /DVD/GL_SETT is executed, the screen with Glue Main Settings will be opened and the following settings will be displayed:

 

File (Binary) storage settings

This category of settings enables you to setup parameters for extraction to file storages like /wiki/spaces/ReuseLib/pages/701071414, GCP (Google Cloud Platform) and BigQuery, AWS S3, Hadoop or others.

  • ALLOW_BIN_DELETION - Allows data deletion from the binary storage. Input value: X = allow. Default value: space.
  • BIN_DATA_FILE - Binary data file name. Input value: file name with placeholders. Supported placeholders listed below. Default value: <GLUE_TABNAME>_<GLUE_REQUEST>.
  • BIN_REQUEST_METADATA_FILE - Binary request metadata file name. Input value: file name with placeholders. Supported placeholders listed below. Default value: <GLUE_TABNAME>_<GLUE_REQUEST>.
  • BIN_TABLE_METADATA_FILE - Binary table metadata file name. Input value: file name with placeholders. Supported placeholders listed below. Default value: <GLUE_TABNAME>_<TIMESTAMP>.
Placeholder
Replaced with
<TIMESTAMP>Current timestamp
<DATE>Current date
<USERNAME>Current user
<GLUE_TABNAME>Glue table name
<GLUE_REQUEST>Glue extraction request
<GLUE_CR_DATE>Glue table creation date
<GLUE_CR_TIME>Glue table creation time
<STORAGE_ID>Glue table Storage ID

<EXTRACTION_TIMESTAMP>

Extraction timestamp
<EXTRACTION_DATE>

Extraction date

<YEAR>Current year
<MONTH>Current month
<DAY>Current day
<VARIANT_NAME>Variant name

  • MASS_APPEND_PART_VALUE - Mass Execution: Append partitioning value to filename: If set to 'X', the value used to split data into partition via (Glue-2005) Mass Execution functionality is appended at the end of the filename. 

    This functionality uses only the first value of the select option and handles just single values and intervals. Therefore, we do not recommend to use it in case the complex select-option values are expected for the partitioning field. 

Extractor 2.0 settings

Category of settings related to Extractor 2.0 objects. For more information about the Extractor 2.0 concept refer to documentation (Glue-2005) Extractor 2.0.

  • AUTO_CONS_CREATION - Glue Table - Automatic creation of GLUE Consumer. Input value: 'X' = enabled. Default value: space.
  • EXT2_CUSTOM_LIB_INCL - Custom libraries include in Extractor 2.0. Input value: name of INCLUDE. Default value: space. In order to specify more than one include, use semicolon (';') as a separator, e.g. ZDVD_INCLUDE1;ZDVD_INCLUDE2;ZDVD_INCLUDE3.
  • EXT2_DEF_START_RT_CODE - Default start routine code in Extractor 2.0. Input value: ABAP code. Default value: space.
  • EXT2_DEF_END_RT_CODE - Default end routine code in Extractor 2.0. Input value: ABAP code. Default value: space.

Other settings

Glue Expert Settings

You can open Glue Expert Settings from the Glue Main Settings (transaction /DVD/GL_SETT) by clicking on the "Expert settings" button, as shown in the screenshot below or by running the transaction /DVD/GL_SETT_EXPERT.


Once the transaction /DVD/GL_SETT_EXPERT is executed, the screen with Glue Expert Settings will be opened and the following settings will be displayed:

Customizing settings

Category of settings for enhancing Glue standard functionality. For more information refer to /wiki/spaces/GLUE/pages/944603241.

  • ALLOW_DELETE_GLREQUEST - Allows to delete a field GLREQUEST from Glue table in Glue Data Dictionary. Input value: 'X' = enabled. Default value: space.
  • ALLOW_DELTA_VALUE_RESET - Adds an option in Delta Tools pop-up to overwrite last delta value for extractor delta types DATE, TMSTMP and NUM_RNG. Input value: 'X' = enabled. Default value: space.
  • ALLOW_TRIGGER_OPERATIONS - Adds a trigger status option in Delta Tools pop-up to and option to Enable/Disable trigger for extractors with delta type TRIGGER. Input value: 'X' = enabled. Default value: space.
  • AUTH_CHECK_MODIFIABLE - Allows to create, edit, and delete the functionality of Glue object when Glue variants are forbidden for systems which are not modifiable (based on the field CCNOCLIIND from table T000). Input value: 'X' = enabled. Default value: 'X'.

Glue authorization objects settings

These settings allow to turn on/off authentication checks for Glue/SAP objects.

  • AUTH_OBJ_GLUE - Enables the authentication for auth. object - GLUE. Input value: 'X' = enabled. Default value: space.
  • AUTH_OBJ_GL_OBJ - Enables the authentication for auth. object - GL_OBJ. Input value: 'X' = enabled. Default value: space.
  • AUTH_OBJ_SAP - Enables the authentication for auth. object - SAP. Input value: 'X' = enabled. Default value: space.
  • AUTH_OBJ_SAP_CUBE - Enables the authentication for auth. object - SAP_CUBE. Input value: 'X' = enabled. Default value: space.
  • AUTH_OBJ_SAP_ODS - Enables the authentication for auth. object - SAP_ODS. Input value: 'X' = enabled. Default value: space.
  • AUTH_OBJ_STOR - Enables the authentication for auth. object - STOR. Input value: 'X' = enabled. Default value: space.


Transporting settings

In order to transport Glue settings into a target system, you need to perform actions on both source and target systems. Please follow the procedure below.

Actions on a source system

  1. Collect settings into transport request using the corresponding button from Glue Main/Expert Settings screen.
  2. Release the transport request following standard SAP procedure.

Actions on a target system

  1. Import transport request into a target system in SAP Transport Management System (tcode STMS)
  2. Perform import of request in Glue Transport Management System (tcode /DVD/GLTR).


All changes made in transactions /DVD/GL_SETT and /DVD/GL_SETT_EXPERT are saved and can be accessed by clicking on "Display History" button as shown in the screenshot below.