Configuring the connection for SQL integration - SSO
- John Jellema
- Shraddha Shejawal
Owned by John Jellema
JDBC driver installation
Depending on the used database a specific JDBC driver needs to be installed.
For example, MS SQL JDBC driver is available in
- http://www.microsoft.com/en-us/download/details.aspx?id=11774
Note: Kindly use MS SQL JDBC driver version 9.4 or earlier with SSO 9.x . Ref: https://ubisecuredev.atlassian.net/wiki/x/CYDfMAI
On linux the driver should be placed in
/usr/local/ubisecure/ubilogin-sso/tomcat/lib
Or on Windows
%PROGRAMFILES%\Ubisecure\ubilogin-sso\tomcat\lib
SQL Service creation in SSO Management
New service needs to be added to Ubisecure SSO. Open Ubisecure Management with administrative privileges and navigate to Home → Services. Create new service as instructed below:
| Configuration key | Description |
|---|---|
policy.password.encoding | The encoding of passwords in the associated directory. |
password-name | The password authentication method that is used with this directory. This also defines the password method for step-up methods used with this directory. |
url | The JDBC URL that is used to connect to the database. |
username | The username that is used to connect to the database. |
password | The password that is used to connect to the database. This is not visible in the UI after setting it. |
Example configuration with an external MS SQL database:
|
|---|
