Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse > Process of Configuring the Table Analyze Utility >

Setting the Environment Variable for the JDBC drivers

This task is a step in the Process of Configuring the Table Analyze Utility.

You need to add the path of your target database's JDBC drivers to the CLASSPATH environment variable. Depending on what target warehouse database you use, the JDBC drivers needs to be installed on the PowerCenter Server machine:

• Oracle. If you are using an Oracle database (other than 8.x), find the directory where Oracle is installed. The JDBC driver is named ojdbc14.jar in the jdbc\lib directory.

  If you are using Oracle 8.x, the JDBC driver file is named classes12.zip.

• DB2. If you are using a DB2 database, find the directory where DB2 is installed. The JDBC driver is named db2java.zip in the Java subdirectory.
• MSSQL. If you are using an MSSQL database, download the SQL Server JDBC drivers from Microsoft's Web site. The JDBC drivers are named msbase.jar, mssqlserver.jar, and msutil.jar.
• Teradata. If you are using a Teradata database, find the directory where Teradata is installed. The JDBC drivers are named terajdbc4.jar, log4j.jar, and tdgssjava.jar. Depending on the Teradata JDBC version, you may not have log4j.jar and tdgssjava.jar.

To set the CLASSPATH environment variable for the JDBC drivers

• In the Windows System Properties window, add to the CLASSPATH environment variable the path for the JDBC driver directory and the full file name.