Installing and Setting Up the DAC Platform
Installing and Setting Up Oracle BI Applications
4-41
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.
4.7.4.2 How to Create 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.
4.7.4.3 How to Create 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.
Server Name
Enter the tnsname for the database.
Client Version
Select 10gR1 for 10g and 11g databases.
Field
Description