Bookshelf Home | Contents | Index | Search | PDF

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

Creating Database Connections

---

The Informatica 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 transactional database, as shown in Figure 4.

Figure 4.  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 15. You also use this same information when configuring Informatica.

Table 15.  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. For SQL Server, the connect string is the DSN for the OLAP and OLTP.
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

1. Using DB2 Client Configuration Assistant, create a database connection to the Siebel Data Warehouse, the Siebel transactional database, and the Siebel Data Warehouse repository. Use the parameters in Table 15.
2. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using an ODBC driver.
3. Test the connections to make sure they work.

To create database connections for Oracle installations

1. Using Net8 Assistant, create a native connect string (net service name) to the Siebel Data Warehouse, the Siebel transactional database, and the Siebel Data Warehouse repository. Use the parameters in Table 15.
2. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using an Oracle 8 ODBC driver.

   NOTE:  Use an Oracle 8 driver (32 bit to 64 bit) for an Oracle 9i Siebel Data Warehouse. The connection only succeeds with Oracle 8 drivers.

3. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using the Merant Closed driver. This ODBC driver was installed during Informatica Client installation (the exact name depends on the specific release of Informatica being used).
4. Test the connections to make sure they work.

To create database connections for SQL Server installations

1. Create a database connection to the Siebel Data Warehouse, the Siebel transactional database, and the Siebel Data Warehouse repository. Use the parameters in Table 15.

   NOTE:  For SQL Server running Unicode-configured databases, you must specify the database type ODBC.

2. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using a SQL Server ODBC driver.
3. Test the connections to make sure they work.

Bookshelf Home | Contents | Index | Search | PDF