Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Configuring the DAC Metadata Repository >

Creating ODBC Database Connections

The Informatica Server and Repository Server require native connections to the Siebel Data Warehouse and Siebel transactional database. The Informatica client needs both an ODBC connection and a native connection to the Siebel Data Warehouse and transactional 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 transactional database.

To create database connections for DB2 installations

1. Using the DB2 Client Configuration Assistant, create a database connection to the Siebel Data Warehouse, the Siebel transactional database, and the Informatica repository.
2. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Siebel Data Warehouse and transactional database 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 Siebel transactional database, and the Informatica repository.
2. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Siebel Data Warehouse using the Siebel Merant ODBC driver that is supplied with Siebel Enterprise Server.
3. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Siebel Data Warehouse and transactional database 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. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Siebel Data Warehouse and Siebel transactional database using a SQL Server ODBC driver.
2. Test the connections to make sure they work.

To create database connections for Teradata installations

1. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection for the Teradata database.
2. Set the following parameters:

   Field	Enter
   DateFormat	AAA
   SessionMode	ANSI
   NoScan	Yes

3. For Unicode environments, in the Teradata ODBC Driver Advanced Options dialog box, set the Character Set parameter to UTF8.