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

Process of Changing the Analytics Database Settings

Analytics License: All licenses.

Operating Systems: All.

Databases: All databases.

The database you use with Siebel Analytics may require that you change the Siebel Analytics database type or database connections settings. If this is the case for your deployment, perform the following tasks:

• Verify the database type and connection properties.
  • See the topic About Locating the Database Setup Script Under UNIX.
  • Physical database type.

    See the topic Changing the Analytics Database Type. For more details, see the topics about setting up database objects in Siebel Analytics Server Administration Guide.

  • Database connection properties.

    Your SiebelAnalytics.rpd application repository contains preconfigured database connections. You must reconfigure database connections to match your environment. See the topics Changing the Siebel Analytics Database Connection Pool Settings and
    About Changing Database Connection Pool Settings Under UNIX.

    For more details, see the topics about setting up and managing connection pools in Siebel Analytics Server Administration Guide.

• After you reconfigure your database connections, you may need to perform the following tasks:
  • Copying the repository file to the UNIX machine.

    If you use AIX, HP-UX, or Solaris, copy the repository file to the UNIX machine.

• If you are using the Update Rowcount functionality and running a heterogeneous environment (servers on UNIX and Analytics Administration Tool on Windows), see the topic About Updating Row Counts in Native Databases.
• If you use Oracle DBMS, you may need to perform the following tasks:
  • Setting the ORACLE_HOME Variable for Solaris
  • About Oracle Database Configuration in Siebel Analytics Server Under UNIX
  • Configuring Oracle Databases for the Siebel Analytics Server Under Windows
  • Configuring HP-UX with Oracle 9i Clients
• If you use IBM DB2 DBMS, you may need to perform the following tasks:
  • Configuring DB2 Connect Under UNIX
• If you use ODBC, you need to perform the following task:
  • Configuring an Analytics ODBC Data Source Under UNIX
  • Under Windows, configuring Siebel Analytics ODBC Data Source Names is done through the Server Administration Tool. See the topic in the Siebel Analytics Server Administration Guide.
• If you use Teradata, you need to perform the following task:
  • Configuring Teradata Data Source for Analytics Under UNIX