Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the UNIX Environment > Installing and Configuring Siebel Analytics Components >

Creating and Configuring Siebel Analytics Tables

---

The Siebel Analytics Server contains the following Siebel Analytics tables. The first table, S_NQ_ACCT, is used by the Siebel Analytics Server. The remaining four tables are used by Siebel Analytics Scheduler.

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.

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

Siebel Analytics Tables Considerations

If you are not using Siebel Analytics Scheduler, you do not need the information in this section.
Follow these steps only if you are running Stand-Alone Siebel Analytics.

Description of the Siebel Analytics Tables

S_NQ_ACCT

The Siebel Analytics Server generates Usage Tracking data files (if usage tracking was enabled in NQSConfig.ini). A sample JScript 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.

Bookshelf Home | Contents | Index | Search | PDF