(Glue-2008) Glue Settings

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 Microsoft Azure, 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>. It is possible to create subfolders for example <LOAD_TYPE>/<GLUE_REQUEST>. This feature is not supported for BINFILE and Google cloud storage.
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>.
BIN_EMPTY_LOAD_DATA_FILE - Indicates whether the (empty) data file should be generated for loads that contain no data e.g., empty delta load. Set the value = X in order to allow empty data files transfer.
BIN_EMPTY_LOAD_METADATA - Indicates whether the metadata JSON file should be generated for loads that contain no data e.g., empty delta load. Set the value = X in order to allow the generation of metadata files for these loads.

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
<LOAD_TYPE>	Load type (full or delta)

MASS_APPEND_PART_VALUE - Mass Execution: Append partitioning value to the filename: If set to 'X', the value used to split data into partition via (Glue-2008) 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 the documentation (Glue-2008) 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.
EXT2_ENHANCED_LOGS - Enhanced logging messages for Extractor 2.0 objects when marked. Input value: 'X' = enabled. Default value: space.
LIMITED_LOGGING - Logging of only failed extractions for Extraction Process. Input value: 'X' = enabled. Default value: space.
ENABLE_DATA_VALIDATION - Displays "Data Validation" checkbox in Extraction Process reports, which use Glue Consumers. When the checkbox is checked, data extracted to the storage will be verified with the source data using XOR hash function. Based on the type of target storage the data will be either verified by packages after every write operation or at the end of the extraction. Input value: 'X' = enabled. Default value: space.
Please note, while this will prove that the load was successful and consistent, it will also slow down the data extraction process.
FIFO_CONSUMER_ATTEMPTS_NUM - Number of attempts to acquire the lock for FIFO Consumer. Input value: Integer. Default value: 2.
FIFO_CONSUMER_WAITING_TIME - Waiting time for FIFO Consumer to acquire the lock again. Input value: Decimal number. Default value: 0.2
FIFO_FETCHER_ATTEMPTS_NUM - Number of attempts to acquire the lock. Input value: Integer. Default value: 2.
FIFO_FETCHER_WAITING_TIME - Waiting time for FIFO Fetcher to acquire the lock again. Input value: Decimal number. Default value: 2.0

Other settings

DEFAULT_DATE_FORMAT - Default date format used within Date format business function defined in the Glue extraction process e.g., DD/MMM/YYYY. This parameter is used on action Apply date format function and can be overwritten manually. Default value: space.
DEFAULT_TIME_FORMAT - Default time format used within the Time format business function defined in the Glue extraction process e.g., HH:MM:SS. This parameter is used on action Apply time format function and can be overwritten manually. Default value: space.
ENABLE_BO_BROWSER - Enables Business Objects browser. Input value: 'X' = enabled. Default value: 'X'.
ENABLE_GL80_FOLDERS - Enable (Glue-2008) Folders in Object tree in (Glue-2008) Object Navigator. Input value: 'X' = enabled. Default value: space.
ENHANCEMENT_ID - Enhancement ID used in Dynamic Selection using BAdi. Input value: name for enhancement ID. Default value: space.
ROLLNAME_REPLACEMENT_DATE - Data element used to replace original data elements with technical type d. In case you wish to use date format function, the replacement needs to be a character-like and compatible with your date format. E.g., date format DD/MMM/YYYY requires at least 11 characters. The data elements are replaced while importing fields to the Glue table and can be manually overwritten. However, invalid data types might lead to extraction failure. Default value: space.
ROLLNAME_REPLACEMENT_TIME - Data element used to replace original data elements with technical type t. In case you wish to use time format function, the replacement needs to be a character-like and compatible with your time format. E.g., time format HH:MM:SS requires at least 8 characters. The data elements are replaced while importing fields to the Glue table and can be manually overwritten. However, invalid data types might lead to extraction failure. Default value: space.

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

ALLOW_DELETE_GLREQUEST - Allows you 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 you 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 you 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

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

Actions on a target system

Import transport request into a target system in SAP Transport Management System (tcode STMS)
Perform import of the 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.