Or look into using SQLCl …For example, the following URL establishes a connection to an Oracle instance in the Oracle RAC system named Accounting: jdbc:datadirect: oracle://server1 :1521:ServiceName=Accounting The specific instance that is connected to is determined by a number of factors, including which instances are available and the load on those instances. In the Oracle LDAP URL field, enter the Oracle LDAP URL in the following format: You can actually put the full TNSNAMES entry in the connect string instead of having it look it up, but that can make for a long command line. In the Connection Options list, choose LDAP URL. 2.7 Validating Credentials When Single Sign-On Is Not Used For maximum performance define the size of the connection pool as greater than or equal to the maximum number of threads that run in the event processor. LDAP server profile settings can be overridden in the LDAP realm settings by specifying the property with the prefix ldap.prof, for example: = group=edqusers,ou=groups,dc=example,dc=com.

Quest toad for sql server