F Creating ODBC Database Connections for DAC

This appendix provides instructions for creating ODBC database connections for DAC.

The DAC Client requires an ODBC connection to the Oracle Business Analytics Warehouse when the database type is Oracle, SQL Server, DB2, and DB2-390 in order to upgrade the data warehouse schema using the DDL Import Utility.

Additionally, Siebel CRM source systems require an ODBC connection to the OLTP (source) database on the machine where Oracle BI Applications software is installed. This ODBC connection will be used by the DDLIMP utility.

For the ODBC connections to Oracle databases, you must use the Oracle Merant ODBC Driver that is installed with the DAC platform installation. For all other databases, you should use ODBC drivers supplied by your database vendor.

Note:

On Windows Vista, the Oracle Merant Driver is not successfully installed by the DAC installer. Use Microsoft ODBC Administrator to configure an ODBC connection with the native ODBC driver instead. Use this ODBC when upgrading tables in the Oracle Business Analytics Warehouse using the DAC Client.

Refer to the appropriate instructions for your database type:

• Section F.1, "Creating ODBC Connections for Oracle Databases"

• Section F.2, "Creating ODBC Connections for DB2 Databases"

• Section F.3, "Creating ODBC Connections for SQL Server Databases"

• Section F.4, "Creating ODBC Connections for Teradata Databases"

F.1 Creating ODBC Connections for Oracle Databases

Follow these instructions for creating ODBC connections for Oracle databases on Windows. For instructions on creating ODBC connections for Oracle databases on UNIX or Linux, see the documentation provided with your database.

Note: You must use the Oracle Merant ODBC driver to create the ODBC connections. The Oracle Merant ODBC driver is installed by the Oracle BI Applications installer. Therefore, you will need to create the ODBC connections after you have run the Oracle BI Applications installer and have installed the DAC Client.

To create ODBC connections for Oracle databases

1. On the Windows machine that will host the DAC Client, navigate to the ODBC Data Source Administrator.

   Use the System DSN tab of the ODBC Data Source Administrator to create an ODBC connection to the Oracle Business Analytics Warehouse database using the Oracle Merant ODBC driver that is supplied with Oracle BI Applications.

   For example, you might create a database connection called Connect_to_OLAP.

2. Click the System DSN tab.

3. Click Add.

4. In the list of drivers, select the Oracle Merant ODBC driver that is installed with DAC, for example, Oracle Merant ODBC Driver in DAC 10g_Oracle - OH1.

5. In the ODBC Oracle Driver Setup dialog, enter or select the following:

   Field	Description
   Data Source Name	Enter any meaningful name.
   Server Name	Enter the tnsname for the database.
   Client Version	Select 10gR1 for 10g and 11g databases.

   
   

6. Click Test Connect to make sure the connection works.

7. (If your source system is Siebel CRM) In Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Siebel transactional database using the Oracle Merant Closed driver.

F.2 Creating ODBC Connections for DB2 Databases

Follow these instructions for creating ODBC connections for DB2 databases on Windows. For instructions on creating ODBC connections for DB2 databases on UNIX or Linux, see the documentation provided with your database.

To create ODBC connections for DB2 databases

1. Using the DB2 Client Configuration Assistant, create a database connection to the Oracle Business Analytics Warehouse database on the machine that will host the DAC Client. If your source system is Siebel CRM, also create an ODBC connection to the transactional database on the machine where you will run the Oracle BI Applications installer.

   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, on Windows, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Oracle Business Analytics Warehouse (and, if your source system is Siebel CRM, to the transactional database) using an ODBC driver.

3. Test the connections to make sure they work.

F.3 Creating ODBC Connections for SQL Server Databases

Follow these instructions for creating ODBC connections for SQL Server databases on Windows.

To create ODBC connections for SQL Server databases

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 database on the machine that will host the DAC Client.

   • (If your source system is Siebel CRM) An ODBC connection to the transactional database on the machine where you will run the Oracle BI Applications installer.

   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.

F.4 Creating ODBC Connections for Teradata Databases

Follow these instructions for creating ODBC connections for Teradata databases.

To create ODBC connections for Teradata databases on Windows

1. On the Windows machine that will host the DAC Client, in the System DSN tab of the ODBC Data Source Administrator, create an ODBC connection to the Oracle Business Analytics Warehouse 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, set the Character Set parameter to UTF8.

To create ODBC connections for Teradata databases on UNIX

1. Using the Teradata ODBC driver, create an ODBC connection for the Teradata database.

2. Set the following variables in the ODBC.INI file:

   • DateFormat=AAA

   • SessionMode=ANSI

   • NoScan=Yes

3. For UNICODE environments, in the Teradata ODBC Driver Advanced Options dialog, add the following:

   • CharacterSet=UTF8