Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Setting Up the DAC Client >

Creating ODBC Database Connections

The Informatica Server and Repository Server require native connections to the Siebel Data Warehouse and OLTP database. The Informatica client needs both an ODBC connection and a native connection to the Siebel Data Warehouse and OLTP database.

NOTE:  If the Informatica Server is installed in MSSQL in non-ASCII mode, it will need an ODBC connection to the Siebel Data Warehouse and OLTP database.

To create database connections for DB2 installations

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

To create database connections for Oracle installations

  1. Using Net8 Assistant or Oracle Net Service, create a native connect string (net service name) to the Siebel Data Warehouse, the OLTP, and the Informatica repository.
  2. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse using the Siebel Merant ODBC driver that is supplied with Siebel Enterprise Server.
  3. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse and OLTP using the Informatica-supplied Merant Closed driver. This ODBC driver was installed during the 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.
  2. In the ODBC control panel, System DSN tab, create an ODBC connection to the Siebel Data Warehouse and OLTP using a SQL Server ODBC driver.
  3. Test the connections to make sure they work.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 11 March 2004