Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content
  • How to configure JDBC Connection in TIBCO ActiveMatrix BusinessWorks™ 5 when Oracle DB server connection information is stored in LDAP


    Kurian Kuruvilla

    This article explains how to configure JDBC Connection shared resource in TIBCO ActiveMatrix BusinessWorks™ 5 (BW) when the Oracle DB server connection information is stored in LDAP.

    The first step is to identify the LDAP entry that contains the connection information. For this, run ldapsearch with the Oracle Context DN as the base. For example,

    ldapsearch -h ldaphost -p 389 -b "cn=OracleContext,dc=example,dc=com" "(objectclass=*)"
    
    cn=OracleContext,dc=example,dc=com
    objectClass=orclContext
    cn=OracleContext
    
    cn=orcl19tw2012,cn=OracleContext,dc=example,dc=com
    objectClass=top
    objectClass=orclNetService
    cn=orcl19tw2012
    orclNetDescString=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521))(CONNECT_DATA=(SID=ORCL19TW2012)))

    In the above example, the Oracle Context DN is cn=OracleContext,dc=example,dc=com and the DN of the entry that contains the connection information is cn=orcl19tw2012,cn=OracleContext,dc=example,dc=com (see the attribute orclNetDescString)

    With the above setup, the URLs would be as follows -

    Oracle JDBC driver

    jdbc:oracle:thin:@ldap://ldaphost:389/cn=OracleContext,dc=example,dc=com/orcl19tw2012

    OR

    jdbc:oracle:thin:@ldap://ldaphost:389/orcl19tw2012,cn=OracleContext,dc=example,dc=com

    TIBCO Database Driver Supplement Software

    jdbc:tibcosoftwareinc:oracle://ldaphost:389;LDAPDistinguishedName="cn=orcl19tw2012,cn=OracleContext,dc=example,dc=com"


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...