Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Setting Up DAC System Properties and Resources >

Creating Database Connections

---

You can set up database connections in the Database Connections tab in the Setup View of the DAC client.

To access the Database Connections tab

1. Launch the DAC client by double-clicking the startclient.bat file in the DAC directory or by running startclient from a command prompt.
2. Click Setup on the DAC toolbar, and then click the Database Connections tab.

Table 13 provides a description of the database connection properties.

Table 13.  Database Connection Properties

Property	Description
Name	Logical name for the connection. (The metadata that comes with Siebel Analytics Data Warehouse has two data sources: OLTP, which points to the Siebel Transaction Database, and the Data Warehouse.)
Type	Source or Warehouse.
Connection Type	Type of database connection. Possible values are the following: Oracle (OCI8). Connect to Oracle using the tnsnames entry. Oracle (Thin). Connect to Oracle using thin driver. DB2. DB@ UDB database. DB2-390. DB2 390 database. MSSQL. Microsoft SQL Server.
Connection String	If you are using... Oracle (OCI8) use the tnsnames entry. Oracle (Thin) use instance name. SQL server use the database name. DB2-UDB/DB2-390 use the connect string as defined in the DB2 configuration.
Table Owner	Name of table owner.
Password	Password for table owner.
DBHost	Host machine where the database resides. This field is mandatory if you are using Oracle (Thin) or MSSQL but is not required if you are using Oracle (OCI8), DB2, or DB2-390.
Port	Port where the database receives requests. Required for Oracle (Thin) and MSSQL databases. Not required for Oracle (OCI8), DB2, or DB2-390 databases.

Bookshelf Home | Contents | Index | Search | PDF