Siebel Analytics Platform Installation and Configuration Guide > Configuring the Siebel Analytics Data Sources >

Configuring Oracle Databases for the Siebel Analytics Server Under Windows

Analytics License: All licenses.

Operating System: Windows only.

Databases: Oracle only.

This topic is part of the Roadmap for Configuring Siebel Analytics Platform.

When the native database is Oracle, the machine running Siebel Analytics Server must have the Siebel Analytics-supported Oracle Client installed. In the tnsnames.ora file, the defined entry name must match the Data Source Name used in the connection pools used in all Siebel Analytics repository physical Oracle databases.

For example, in the following example of a tnsnames.ora entry, the corresponding Siebel Analytics repository connection pool Data Source Name is ITQA2.

ITQA2 =
   (DESCRIPTION =
      (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = ITQALAB2)(PORT = 1521))
   (CONNECT_DATA =
      (SERVICE_NAME = ITQALAB2.corp)
      )
   )

The following procedure shows how to check repository connection pool settings against the Oracle tnsnames.ora settings.

To check that an Oracle database refers to the Siebel Analytics Server machine

1. Log on to the Server Administration Tool.
2. In the physical layer, double-click on the appropriate OLTP cylinder icon. Expand it.
3. Double-click the appropriate OLTP Connection Pool to open the Connection pool window.
4. In the Connection Pool window, check that the following is true:
   • The Call Interface field displays the appropriate value for the release of Oracle being used.
   • The Data Source Name displays the Oracle alias that you have defined in the tnsnames.ora setting.

     NOTE:  This Data Source Name is not the DSN name defined in Settings > Control Panel > Data Sources (ODBC).

5. In the Oracle folder, open the tnsnames.ora file.
6. Check that a valid entry name exists with the following characteristics:
   • Matches the Siebel Analytics repository's connection pool settings for the Data Source Name
   • Specifies the targeted Oracle physical database