Bookshelf v7.5.2: Creating Database Connections for OLAP and OLTP

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse >

Creating Database Connections for OLAP and OLTP

The Administrator Workstation needs an ODBC connection and a native connection to the Siebel Data Warehouse (which holds the Informatica repository), and a native connection to the Siebel Transaction Database, as shown in Figure 3.

Figure 3. Native and ODBC Connections

To define the ODBC connections between the Administrator Workstation and the Siebel Data Warehouse, you need the setup information shown in Table 3. You also use this same information when configuring Informatica (read To configure Informatica Repository Manager).

Table 3. ODBC Connect Information for the Siebel Data Warehouse
Field	Description
Connect String	The native connect string to the Siebel Data Warehouse. For DB2, use the Data Source Name. For Oracle, use the native connect string.
ODBC Data Source	The Data Source Name (DSN) for the Siebel Data Warehouse.

NOTE: When creating a password, do not use any spaces. Also, the password must not be blank (null).

To create database connections for DB2 installations

Using DB2 Client Configuration Assistant, create a database connection to the Siebel Data Warehouse (OLAP), the Siebel Transaction Database (OLTP), and the Siebel Data Warehouse repository. Use the parameters in Table 3.

In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using an ODBC driver.

Test the connections to make sure they work.

To create database connections for Oracle installations

Using Net8 Assistant, create a native connect string (net service name) to the Siebel Data Warehouse (OLAP), the Siebel Transaction Database (OLTP), and the Siebel Data Warehouse repository. Use the parameters in Table 3.

In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using an Oracle ODBC driver.

In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using the driver named "Merant Closed 3.5 32-Bit Oracle8." This ODBC driver was installed during Informatica Client installation.

Test the connections to make sure they work.

To create database connections for SQL Server installations

Create a database connection to the Siebel Data Warehouse (OLAP), the Siebel Transaction Database (OLTP), and the Siebel Data Warehouse repository. Use the parameters in Table 3.

In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using a SQL Server ODBC driver.

Test the connections to make sure they work.