NOTE: The template is only available in the Job Service Configuration program.
The SQL server direct template is supplied for configuring the One Identity Manager Service with a direct database connection.
This template already contains the most important modules with settings for a simple One Identity Manager Service configuration with a direct connection to a SQL Server. You can load the template using the menu item Templates > SQL server direct. After loading, the configuration the template needs to be modified as required.
The module list of the One Identity Manager Service configuration gives an overview of the individual configuration sections. A selection of module types is available for certain modules.
To select a module type
-
Click on the module in the module list.
-
Use Insert to open the module type drop-down.
-
Select the module type you want from the list and insert it with the OK button.
To change the name of a module type
-
Click on the module in the module list.
-
Select the module type and click Rename.
-
Change the name of the module type.
-
Press return.
To delete a module type
-
Click on the module in the module list.
-
Select the module type and click Delete.
To edit a parameter value
-
Select the parameter in the Properties column.
-
Click Edit.
When a item is selected in the module list, all possible parameters and their values are displayed. You can change some values by clicking in input field or on the option button in the Value column.
NOTE: The parameter description in each module contains the parameter name, in brackets, which is used in the configuration file.
The following icons are used:
Table 62: Meaning of the icons for the module parameters
 |
The value is passed as a string. |
 |
Compulsory input. The parameter must be altered as required. The value is passed as a string. |
 |
The value is passed as an integer. |
 |
The parameter can be enabled or disabled. |
 |
This parameter is added during run-time. The One Identity Manager Service does not need to be restarted. |
 |
The parameter takes effect after the One Identity Manager Service is restarted. |
The verification test ensures that the minimum requirements for a configuration file are met.
To start the validity check in the One Identity Manager Service configuration
Table 63: Verification test error output
|
No Job provider found. |
Errors |
|
No Logwriter found. |
Errors |
|
No input in compulsory field. |
Errors |
|
No Job destination found. |
Warning |
|
No plugins found. |
Warning |
The MSSQLJobProvider handles One Identity Manager database process requests on a SQL Server. You configure the Job provider in the Process collection module.
Table 64: MSSQLJobProvider parameters
|
Max. number of pending requests (RequestQueueLimit) |
The process requests are internally cached. This parameter defines the maximum number of cache entries. The default value is 1000. |
|
Max. number of pending requests (RequestQueueLimit) |
The process results are internally cached. This parameter defines the maximum number of cache entries. The default value is 10000. |
|
Results flush timeout on shutdown in seconds (FlushTimeoutSeconds) |
The service can continue to write results to the database until this timeout is reached. Input in seconds. The default value is 10 seconds. |
|
Connection parameter (ConnectString) |
Access data for the database server and the database to be used At least one user with the configuration user access level is required for process collection. Some functions may require an administrative user.
-
Server: Database server.
-
Windows authentication: (Optional) Specifies whether the integrated Windows authentication is used. This type of authentication is not recommended. If you decide to use it anyway, ensure that your environment supports Windows authentication.
-
User: User's SQL login name.
-
Password: Password for the SQL user's login.
-
Database: List of possible databases on the database server. Select the database.
-
Encrypt communication: Specifies whether encryption is required for exchanging data between the client and server. Select the minimum encryption level. The encryption level that is actually used depends on the database server configuration. For more information, see the documentation from Microsoft.
Permitted values are:
-
Optional: Communication is not encrypted.
-
Mandatory: Data exchange is encrypted. The Trust server certificate option, allows you to also specify whether to verify the server certificate.
-
Strict (SQL Server 2022 and Azure SQL): The data exchange is encrypted. The server certificate is always verified.
-
Trust server certificate: If this option is enabled, the data exchange between the client and server is encrypted. However, the server certificate is not verified. |
button to test the configuration.