Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Installing Siebel Data Warehouse-Related Software on Windows >

Installing Java SDK and Drivers

---

This section provides instructions for installing the Java SDK and the JDBC drivers.

NOTE:  The DAC client requires the SDK for the Java 2 Platform, Standard Edition, Version 1.4.1.

To install Java SDK 1.4.1 or above

• Download the Java SDK from the Sun Web site, and install it using a directory path with no spaces, such as D:\j2sdk141

To install JDBC drivers

• 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 and paste it in the DAC\lib directory.
  • If you are using Oracle 8.x, copy the file named classes12.zip and paste it in the 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 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.

• 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 DAC\lib directory.

Bookshelf Home | Contents | Index | Search | PDF