Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the Windows Environment >

Creating and Configuring Siebel Analytics Tables (Stand-Alone Only)

---

NOTE:  If you have pointed the Siebel Analytics Server to the Siebel transactional database, you do not need to create Siebel Analytics tables. Follow these steps only if you are running Siebel Analytics Stand-Alone.

Siebel Analytics Server contains the following Siebel Analytics tables. The first is used by the Siebel Analytics Server; the remaining four are used by Siebel Analytics Scheduler. If you are not using Siebel Analytics Scheduler, you do not need the information in this section.

S_NQ_ACCT

Siebel Analytics Server generates Usage Tracking data files (if usage tracking is enabled in NQSConfig.ini). A sample JavaScript has been bundled with the Siebel Analytics Server software that extracts information from the Usage Tracking files and loads them to a table in the back-end database. The S_NQ_ACCT table stores all the information regarding Accounting Data.

S_NQ_JOB

The Siebel Analytics Scheduler requires a back-end database table to store information regarding the scheduled jobs. The S_NQ_JOB table stores this information.

S_NQ_INSTANCE

The Siebel Analytics Scheduler requires a back-end database table to store information regarding the instances of the scheduled jobs. The S_NQ_INSTANCE table stores information pertaining to job instances.

S_NQ_ERR_MSG

This table stores error messages for Siebel Analytics Scheduler job instances that do not complete successfully.

S_NQ_JOB_PARAM

This table holds information about Siebel Analytics Scheduler job parameters for scheduled jobs.

You can either create a new database to store the tables or use an existing one. After you have created a database, create the Scheduler tables by executing SAJOBS.xxx.sql (where xxx is the database type). If you are using usage statistics, create the table in SAACCT.xxx.sql.

Database Tables and the Siebel Analytics Scheduler

The Scheduler supports several commercial databases with ODBC connections, such as the following:

Microsoft SQL Server 7 and 2000
Oracle 7.3, 8.x, 8i, 9i
IBM DB2UDB V6 and V7

For a complete list of supported databases, see Siebel System Requirements and Supported Platforms.

There is a one-to-one relationship between the back-end database and the Scheduler. Therefore, the following conditions must be met:

The Scheduler needs to be configured to use a database, and the database must be available for use, before the Scheduler service will start.
Do not configure multiple Siebel Analytics Scheduler services to use a single database.

NOTE:  Before you create a database and tables, you must have an administrative sign-on account.

To create a database and tables for Microsoft SQL Server

Create a database named S_NQ_SCHED using Enterprise Manager. Make sure that you have enough free disk space to accommodate Siebel Analytics Tables (a minimum of 500 MB for Siebel Analytics applications).
Using S_NQ_SCHED as the current database, use Query Analyzer to open the file SAJOBS.MSSQL7.sql and execute it to create the Siebel Analytics Scheduler tables.
Open the file SAACCT.MSSQL7.sql and execute it to create the Accounting table.

To create a database and tables for Oracle

Proceed in one of the two following ways:
Create a new database named S_NQ_SCHED, and create a user named S_NQ_SCHED.
In one of your existing databases, create a user named S_NQ_SCHED.
Provide your own password to the user S_NQ_SCHED.
Using the Oracle client configuration tool, create an Oracle Service to the current S_NQ_SCHED database with this user ID and password.
Using the SQL Worksheet, open the file SAJOBS.Oracle.sql and execute it to create Siebel Analytics Scheduler tables.
Open the file SAACCT.Oracle.sql and execute it to create the Accounting table.

To create a database and tables for IBM DB2

Create a database named S_NQ_SCHED with a valid user ID and password.
Using Command Center, open the file SAJOBS.DB2.sql and execute it to create Siebel Analytics Scheduler tables.
Open the file SAACCT.DB2.sql and execute it to create the Accounting table.

Updating the Scheduler Configuration

The Windows user ID used to access the Siebel Analytics Server Administration Tool must have the appropriate permissions to modify the Registry.

To update the Scheduler configuration

From the Siebel Analytics Server Administration Tool, open a repository in online mode.
Choose Manage > Jobs from the Administration Tool toolbar.

The Siebel Analytics Job Manager opens in a new window.

For more on updating the Scheduler configuration, refer to the section on configuring Siebel Analytics Scheduler in Siebel Analytics Scheduler Guide.

Bookshelf Home | Contents | Index | Search | PDF