Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Configuring the DAC Client >

Installing JDBC Drivers for DAC Database Connectivity

This section provides instructions for installing the appropriate JDBC driver in the DAC\lib directory to enable DAC database connectivity. If the required JDBC drivers are not already installed, you need to install the JDBC driver on the machines where both the DAC server and DAC client are installed.

To install JDBC drivers in the OracleBI\DAC\lib directory

• Oracle. If you are using an Oracle database (other than 8.x), find the directory where Oracle is installed. Copy the file named ojdbc14.jar in the jdbc\lib directory and paste it in the OracleBI\DAC\lib directory.
  • If you are using Oracle 8.x, copy the file named classes12.zip and paste it in the OracleBI\DAC\lib directory. Also, edit the ORACLELIB setting in the config.bat file as follows:

  set ORACLELIB=%DAC_HOME%\lib\classes12.zip

• DB2. If you are using a DB2 database, find the directory where DB2 is installed. In the Java subdirectory copy the file named db2java.zip and paste it in the OracleBI\DAC\lib directory.

  NOTE:  If your source or target database is DB2-UDB, you also need to create DB2-UDB stored procedures to be used during the ETL process. For instructions, see Creating Stored Procedures for DB2-UDB.

• MSSQL. If you are using an MSSQL database, download the sqljdbc.jar driver file from Microsoft's Web site. Copy the sqljdbc.jar file to the \DAC\lib directory (for example, <DRIVE>:\OracleBI\DAC\lib\sqljdbc.jar).

  NOTE:  You need the SQL Server 2000 Driver for JDBC SP3 for SQL Server 2000.

• Teradata. If you are using a Teradata database, copy the files tdgssconfig.jar, TdgssUserConfigFile.xml, terajdbc4.jar, log4j.jar, and tdgssjava.jar from the Teradata installation directory to the \OracleBI\DAC\lib directory. Depending on the Teradata JDBC version, you might not have some of the above files.