SQL Server Specific Configuration Parameters
| Parameter | Default | Description |
|---|---|---|
| RoleMap_Cache_Enabled | false | Specifies whether to enable caching of users for role mappings during the database operations. Possible settings: — 1, true, or yes – Enables the RoleMap_Cache_Enabled parameter. Any values other than the specified ones will be treated as false. — False- Disables the RoleMap_Cache_Enabled parameter.Note: It is not recommended to use the RoleMap Caching feature as it does not comply with the concept of separation of duties defined at the time of user mapping. |
| Domain_Name | no default | specifies the Active Directory domain to which the host belongs. This parameter is used for the Group or Role Mapping feature for mapping the Windows AD groups. |
| Local_Error_Replacement | no | Enables the error replacement value support for the case when User Name does not match CN (Common Name) in Client Certificate, while making Certificate based Authentication with CipherTrust Manager. To enable this feature set Local_Error_Replacement to yes.The Error Replacement values ( String_Value, Int_Value and Date_Value) must be set depending on the data type of the encrypted columns. Refer to Local Error Replacement Sample for details. |
| DB_Connection_Pool | 10 | Maximum number of connections in the database connection pool. |
| DB_Metadata_Database | Name of the database where the CDP Metadata tables have been installed. | |
| DB_Metadata_Owner | dbo | Name of the user who owns the CDP Metadata tables. |
| BulkCopyTimeout | -1 | Connection timeout (in seconds) used by the Bulk Copy utility. Valid values: any value greater than 0. |
| BatchSize | -1 | Size of the batch used by the Bulk Copy utility. Valid value: any value greater than 0. |
Local Error Replacement Sample
To use this feature, change the properties files as shown here:
#[Local Error Replacement Values]
# Enables Local Error Replacement Values when User Name does not match with CN in Client Certificate
# while making Certificate based Authentication with KS
# Valid values: yes, no
# Default: no
Local_Error_Replacement=no
#Valid String value used as error replacement for char/varchar/nchar/nvarchar data types
# If String_Value is empty it would be considered as null
String_Value=protected
#Valid Integer value used as error replacement for int/money/float/real data types
# If Int_Value is empty or any invalid integer value it would be considered as null
Int_Value=0000
#Valid Date Value used as error replacement for date/datetime/time data types
# date_value input should be according to the date format set for the Database
# If Date_Value is empty it would be considered as null
Date_Value= 01/01/1900 00:00:00
Note
For large object, numeric and decimal data types, Local Error Replacement value will always be NULL.
For
String_Value, # and ; are not supported.
