How to use LDAP to connect to a database - for example, to an Oracle DB.
The URL connection-string could possibly be best formed as:
String url = "jdbc:oracle:thin:@ldap://" + ldapHost + "/" + instance + ldap_context;
and look like:
String url = "jdbc:oracle:thin:@ldap://ldap-server:389/testInstance,CN=Admin,O=myOrganization,C=AB";
This string could then be included in one of our JITL jobs. Either:
- PLSQL job or
- SQLPlus job
The user ID and password along with the URL would then be included in the job parameters.