Oracle^® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Setting Up Oracle BI Disconnected Analytics >

Configuring ODBC DSN for Authentication with Oracle BI Disconnected Analytics

On Windows operating systems, Oracle BI Disconnected Analytics must be configured for authentication. Whenever a disconnected user logs on to Oracle BI Disconnected Analytics, the user name and password are authenticated using SQL Anywhere against a transactional database table. In order for the disconnected client to work in an integrated environment, you must configure the ODBC Data Source Name or DSN on the client machine.

Bear the following points in mind when configuring for ODBC:

• Ensure that OLTP and OLAP are on different databases.
• Minimize refresh intervals.
• Do not perform refresh operations while running Oracle BI Interactive Dashboards.
• Set the Max connections parameter based on the previous considerations.

The following configuration provides connectivity between the disconnected client and the disconnected client transactional database.

To configure ODBC DSN for Oracle BI Disconnected Analytics

1. Navigate to Start > Programs > Administrative Tools > Data Sources (ODBC).

   Click System DSN tab.

2. Click Add button.
3. Select Adaptive Server Anywhere 9.0.

   Click Finish.

4. In Data source name field, enter SIEBEL_OLTP.

   NOTE:  Ensure that the user has appropriate Analytics responsibilities checked.

5. Click Database tab, and then click Browse.

   In the Database file field, point to the local database on the client machine.

6. Click OK to exit the Administrative Tool.