Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse 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. 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 SiebelAnalytics\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 SiebelAnalytics\DAC\lib directory.
  • If you are using Oracle 8.x, copy the file named classes12.zip and paste it in the SiebelAnalytics\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 SiebelAnalytics\DAC\lib directory.

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

• MSSQL. If you are using an MSSQL database, download the SQL Server JDBC drivers from Microsoft's Web site. Copy the files msbase.jar, mssqlserver.jar, and msutil.jar to the SiebelAnalytics\DAC\lib directory.
• Teradata. If you are using a Teradata database, find the directory where Teradata is installed. Copy the files terajdbc4.jar, log4j.jar, and tdgssjava.jar and paste them in the SiebelAnalytics\DAC\lib directory. Depending on the Teradata JDBC version, you may not have log4j.jar and tdgssjava.jar.