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 |
Siebel Analytics Installation and Configuration Guide, Version 7.5, Rev. C Published: 18 April 2003 |