Single Sign-On Service › SSO Getting Started Guide › SSO Using CloudMinder as an OAuth Authorization Server › Create a JDBC Connection to the CloudMinder Oracle Database

Create a JDBC Connection to the CloudMinder Oracle Database

Create a JDBC connection to the CloudMinder Oracle database. This enables the Layer 7 Gateway to exchange authentication and authorization data with CloudMinder.

Note: Perform this procedure for each tenant for which you configure CA CloudMinder as an external IdP using OAuth. You only need to do this once per tenant, not once per OAuth client for that tenant.

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:

   Forward Inc. JDBC

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

   com.l7tech.jdbc.oracle.OracleDriver
   

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

   jdbc:l7tech:oracle://<DB-HOSTNAME>:<DB-PORT>;Database=<DB>
   

   Where <DB-HOSTNAME> is the hostname for the Oracle database, <DB-PORT> is the port on which the database is listening, and <DB> is the name of the Oracle service.

6. In the User Name field, enter the user name you specified for <OTKDB-USERNAME> in the oidc_otk.sql file for this tenant.

   You created this user name, and the password referenced in the following step, in the procedure entitled the Create the OTK/OIDC Database.

7. In the Password field, enter the password you specified for <OTKDB-PASSWORD> in the oidc_otk.sql file for this tenant.
8. Click Test to verify the connection.
9. Click OK, then OK.