000032148 - How to set jdbc URL in LDAP format to the "Common and Required Data Source Properties" in RSA IMG 6.8.1

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000032148
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Access Request Manager
RSA Version/Condition: 6.8.1
Platform: WebSphere 8.5.5
Database version: Oracle 12c
IssueThe user is setting up a new environment with Websphere 8.5.5 and Oracle 12c.
From the new Oracle database it needs to use a JDBC URL in LDAP format to connect database from Websphere.
   User-added image
TasksThis article addresses how to apply for the connection string to the URL under "Common and Required Data Source Properties."
ResolutionBelow are examples of the connection strings to connect to the Oracle Database.
An example of a database specifier using the Lightweight Directory Access Protocol (LDAP) syntax is as follows: 
"jdbc:oracle:thin:@ldap://ldap.acme.com:7777/sales,cn=OracleContext,dc=com"

When using SSL, change the syntax to  be as shown below. 
"jdbc:oracle:thin:@ldaps://ldap.acme.com:7777/sales,cn=OracleContext,dc=com" 
NotesThe JDBC Thin driver can use LDAP over SSL to communicate with the Oracle Internet Directory if you substitute ldaps: for ldap: in the database specifier.
The LDAP server must be configured to use SSL. If it is not, then the connection attempt will hang. 

Attachments

    Outcomes