How to set jdbc URL in LDAP format to the "Common and Required Data Source Properties" in RSA IMG 6.8.1
2 years ago
Originally Published: 2015-12-09
Article Number
000065139
Applies To
RSA 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
Issue
The 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
Tasks
This article addresses how to apply for the connection string to the URL under "Common and Required Data Source Properties."
Resolution
Below 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" 
Notes
The 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.