Clickable staff directory icon.
Clickable forms icon.
Clickable org chart icon.
Clickable about us icon.

Connection Instructions

How to access and connect to the Campus Data Warehouse.

Oracle LDAP Service (recommended)

  • Requirements: Oracle 8i and above
  • Your sqlnet.ora file should contain the following lines:

NAMES.DEFAULT_DOMAIN = ucdavis.edu NAMES.DIRECTORY_PATH = (LDAP, ONAMES, TNSNAMES)

  • You will also need to create a new file in the same directory as sqlnet.ora called "ldap.ora". This file should contain the following lines. Please make sure there is not an extra space before any of the three lines below. Extra spaces are ignored in sqlnet.ora file, but an extra space in ldap.ora will cause it to fail.

DIRECTORY_SERVERS= (oraldap1.ucdavis.edu:389:636,oraldap2.ucdavis.edu:389:636) DEFAULT_ADMIN_CONTEXT = "dc=ucdavis,dc=edu" DIRECTORY_SERVER_TYPE = OID


TNSNAMES.ORA (NOT recommended)

  • Requirements: Oracle 8i and above
  • Your sqlnet.ora file should contain the following lines:

NAMES.DIRECTORY_PATH = (TNSNAMES)

  • Your tnsnames.ora file in the same directory as sqlnet.ora file should be having the below entry for CDW database:

isods_prod.ucdavis.edu = (DESCRIPTION = (ADDRESS = (COMMUNITY = TCP.ucdavis.edu) (PROTOCOL = TCP) (Host = afs-oda4b.ucdavis.edu) (Port = 1861) ) (CONNECT_DATA = (SID = isodprod) (GLOBAL_NAME = isodprod.ucdavis.edu) ) )


JDBC Connection:

Explicitly define the host, port and sid. You should be aware that if for some reason we make any changes, you will need to change your configuration as well

  • Host: afs-oda4b.ucdavis.edu
  • Port: 1861
  • SID: isodprod

Specific Instructions for Mac OSX:

  1. Go to http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html
  2. Follow the instructions to download and install the Oracle 9i/Thin JDBC driver for Mac OSX
  3. Use the classes.zip driver located in the jdbc_thin_9_0_1/jdbc/lib/ folder created during the previous step in conjunction with the instructions of the SQL query program to add the newly installed driver to the collection of drivers that the program can use.
  4. When connecting to the Campus Data Warehouse using the JDBC protocol, use the following information:
    • Host: afs-oda4b.ucdavis.edu
    • Port: 1861
    • SID: isodprod