TDM DB - General Parameters
The TDM DB tdm_general_parameters table holds the name of each parameter (param_name) and its value (param_value). The following categories of parameters are populated in this table:
TDM Clean-Up Parameters
The clean-up parameters are automatically created in tdm_general_parameters by TDM DB creation scripts:
- The cleanup_retention_period defines the number of months of the retention period of Inactive records. The clean-up process deletes inactive records that are older than the retention period.
LUI Separator Parameters
To create different LUIs per environment and data version, the TDM concatenates additional identifiers to each IID: environment name (for all tasks), and version identifier for Data Versioning tasks. By default, the LUI's parts are separated by an underscore. For example: ENV1_45773. However, if the source entity ID contains an underscore, another separator must be set on the LUI.
- For example, to enable the TDM process to parse the LUI correctly and to get the correct Customer ID, if the source Customer ID is 123_4, the LUI separator must not be an underscore.
The param_name of the LUI separator is iid_separator.
The param_value must be populated by the String set as a separator.
Note that the iid_separator setting impacts all LUs in the project.
Example:
Insert the following record to tdm_general_parameters to set the separator to @ :
insert into tdm_general_parameters (param_name, param_value) values ('iid_separator', '@');
The LUI of Customer 123_4 and environment ENV1 is ENV1@123_4.
Reservation Period Parameter
An admin user of the environment's owner can reserve entities for an unlimited period. However, a tester user is limited and can only set a retention period that does not exceed the maximum retention period, defined in the TDM DB.
The maximum number of days for the entity reservation is set in the MAX_RESERVATION_DAYS_FOR_TESTER parameter.
TDM Portal General Parameters
The TDM Portal param_name is tdm_gui_params. The value of this parameter includes a list of the following parameters:
- maxRetentionPeriod: maximum number days when setting a retention period on extract tasks. Default value is 90 days.
- defaultPeriod: default retention period on extract tasks. Default value is 5 days ("unit":"Days","value":5).
- permissionGroups: list of the TDM permission groups. The following options are currently supported: admin,owner, and tester.
- TDM Version
TDM DB - General Parameters
The TDM DB tdm_general_parameters table holds the name of each parameter (param_name) and its value (param_value). The following categories of parameters are populated in this table:
TDM Clean-Up Parameters
The clean-up parameters are automatically created in tdm_general_parameters by TDM DB creation scripts:
- The cleanup_retention_period defines the number of months of the retention period of Inactive records. The clean-up process deletes inactive records that are older than the retention period.
LUI Separator Parameters
To create different LUIs per environment and data version, the TDM concatenates additional identifiers to each IID: environment name (for all tasks), and version identifier for Data Versioning tasks. By default, the LUI's parts are separated by an underscore. For example: ENV1_45773. However, if the source entity ID contains an underscore, another separator must be set on the LUI.
- For example, to enable the TDM process to parse the LUI correctly and to get the correct Customer ID, if the source Customer ID is 123_4, the LUI separator must not be an underscore.
The param_name of the LUI separator is iid_separator.
The param_value must be populated by the String set as a separator.
Note that the iid_separator setting impacts all LUs in the project.
Example:
Insert the following record to tdm_general_parameters to set the separator to @ :
insert into tdm_general_parameters (param_name, param_value) values ('iid_separator', '@');
The LUI of Customer 123_4 and environment ENV1 is ENV1@123_4.
Reservation Period Parameter
An admin user of the environment's owner can reserve entities for an unlimited period. However, a tester user is limited and can only set a retention period that does not exceed the maximum retention period, defined in the TDM DB.
The maximum number of days for the entity reservation is set in the MAX_RESERVATION_DAYS_FOR_TESTER parameter.
TDM Portal General Parameters
The TDM Portal param_name is tdm_gui_params. The value of this parameter includes a list of the following parameters:
- maxRetentionPeriod: maximum number days when setting a retention period on extract tasks. Default value is 90 days.
- defaultPeriod: default retention period on extract tasks. Default value is 5 days ("unit":"Days","value":5).
- permissionGroups: list of the TDM permission groups. The following options are currently supported: admin,owner, and tester.
- TDM Version
