Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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.
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).
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.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |