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

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

If the OTK/OIDC database is Oracle-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:

   Forward Inc. JDBC

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

   com.l7tech.jdbc.oracle.OracleDriver
   

5. Complete the JDBC URL field:

   For a standalone Oracle installation, 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.

   For an Oracle RAC installation, enter the following:

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

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

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

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