Using NT database authentication

From a security perspective, it may be desirable to allow the pdrLoader application’s connection to the target database to use NT authentication. The procedure for this varies across JDBC driver implementations and requires a type 2 driver. This document only covers the requirements for the Oracle database platform. Please refer to JDBC vendor documentation for further information.

The procedure for creation of an externally identified user in Oracle is beyond the scope of this document. Configuring the pdrLoader to use NT database authentication requires the following steps:

  1. Log into the Windows account under which the pdrLoader is to be run and validate the database connectivity by typing the following at the MS-DOS command prompt:

    2. C:\pdr\Lib>sqlplus /@your_service_name_or_sid

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 20 15:02:01 2005

    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

    Connected to:

    Oracle9i Enterprise Edition Release 9.2.0.5.0 – Production

    With the Partitioning, OLAP and Oracle Data Mining options

    JServer Release 9.2.0.5.0 – Production

    SQL>

  2. In the pdrLoader.properties file, configure the db_url property to use the OCI style URL. An example is:

    db_url=jdbc:oracle:oci8:@your_service_name_or_sid

  3. You need to use the Oracle JDBC driver compatible with your Oracle client or server install. This is generally found in the $oracle_home\jdbc\lib directory, and has a name like classes12.zip or classes12.jar. Please consult your Oracle documentation for further information.

  4. Remove ojdbc6.jar from the pdrLoader’s lib directory and in the pdrEnvironment.bat file. Replace the entry of ojdbc6.jar in the CLASSPATH variable with the full path to your Oracle JDBC driver (with the name like classes12.zip or classes12.jar). An example of the altered entry in the pdrEnvironment.bat file is:

    set CLASSPATH=AppPdrLoader.jar;C:\oracle\ora92\jdbc\lib\classes12.jar; ftp.jar;commons-codec-1.2.jar;commons-pool-1.3.jar;cryptix32.jar;log4j-1.2.8.jar;.

  5. Remove the db_user and db_password properties from the pdrLoader.properties file. Alternatively, simply comment out the properties by putting a hash (#) at the start of the line.