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.
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.
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, the Siebel transactional database, and the Siebel Data Warehouse repository. Use the parameters in Table 15.
- 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, the Siebel transactional database, and the Siebel Data Warehouse repository. Use the parameters in Table 15.
- 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.
- 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).
- 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, 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.
- 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 Published: 09 September 2004 |