Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Setting Up the Informatica Server and Informatica Repository Server >

Process of Creating ODBC Database Connections

The Informatica Server uses native drivers to connect to the source and target databases to move data. Depending on the source and target database type, you can optionally configure the Informatica Server to use ODBC drivers supplied by your database vendors to connect to the source and target databases. The Informatica Repository Server uses native drivers to connect to the repository database.

You also need ODBC connections when you create the data warehouse tables in the DAC in a later configuration task (for more information, see Process of Creating Data Warehouse Tables). In the case of Oracle database, use the Oracle Merant ODBC Driver that comes with the Oracle BI Applications install. For all other databases, you should use ODBC drivers supplied by your database vendor.

To create database connections for DB2 installations

1. Using the DB2 Client Configuration Assistant, create a database connection to the Oracle Business Analytics Warehouse, the transactional database, and the Informatica repository.

   NOTE:  If you use the DB2 Client Configuration Assistant to create database connections, you can omit step 2, because the DB2 Client Configuration Assistant automatically creates System DSNs (default behavior).

2. If necessary, in Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Oracle Business Analytics 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 Oracle Business Analytics Warehouse, the 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 transactional database using the Oracle Merant ODBC driver that is supplied with Oracle BI Applications.
3. In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Oracle Business Analytics Warehouse and transactional database using the Informatica-supplied Merant Closed driver.
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 the following:
   • an ODBC connection to the Oracle Business Analytics Warehouse
   • an ODBC connection to the transactional database

     NOTE:  Select SQL Server as the ODBC driver.

2. Test the connections to make sure they work.

NOTE:  When you use the ODBC Data Source Administrator to create a database connection, make sure that you select the SQL Server authentication option using a login ID and password entered by the user.

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

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