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: These are automatically created in tdm_general_parameters by TDM DB creation scripts.

  • LUI separator parameters: By default, the LUI separator is set to underscore. However, if the source entity ID contains an underscore, another separator must be set. 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 a 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.

  • TDM GUI parameters: The 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. Detault 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.

Previous

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: These are automatically created in tdm_general_parameters by TDM DB creation scripts.

  • LUI separator parameters: By default, the LUI separator is set to underscore. However, if the source entity ID contains an underscore, another separator must be set. 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 a 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.

  • TDM GUI parameters: The 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. Detault 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.

Previous