SSO Using CloudMinder as an OAuth Authorization Server › Create a JDBC Connection to the OTK/OIDC Database (PostGres)

Create a JDBC Connection to the OTK/OIDC Database (PostGres)

If the OTK/OIDC database is PostgreSQL-driven, use the following procedure to create a JDBC connection to the database. This connection enables the Layer 7 Gateway to exchange authentication and authorization data with CA CloudMinder.

Note: Perform this procedure for each tenant for which you configure CA CloudMinder as an external IdP using OAuth. Perform this procedure only once for each tenant, even if the tenant has many OAuth clients.

Follow these steps:

1. In the Layer 7 Policy Manager web interface, click Manage, then Manage JDBC Connections.
2. Click Add.
3. Enter a meaningful Connection Name that corresponds to your JDBC connection. For example, enter the following:

   Forward Inc. JDBC
   

4. In the Driver Class field, enter the following:

   org.postgresql.Driver
   

5. In the JDBC URL field, enter the following:

jdbc:postgresql://<DB-HOSTNAME>:<DB-PORT>/<OTK-DB>

Where <DB-HOSTNAME> is the hostname for the PostgreSQL database, <DB-PORT> is the port on which the database is listening, and <OTK-DB> is the name of the database that was specified in the postgres_oidc.sql file for this tenant.

1. In the User Name field, enter the user name you specified for <OTKDB-USERNAME> in the postgres_oidc.sql file for this tenant.
2. In the Password field, enter the password you specified for <OTKDB-PASSWORD> in the postgres_oidc.sql file for this tenant.
3. Click Test to verify the connection.
4. Click OK, then OK.