Bookshelf Home | Contents | Index | PDF     

Siebel Analytics Platform Installation and Configuration Guide > Configuring Siebel Analytics Scheduler Server >

Creating Analytics Scheduler Databases and Tables

Analytics License: Platform only.

Operating System: Windows only.

Databases: All databases.

This task is part of the Process of Configuring Scheduler Server for Stand-Alone Analytics. You can either create a new database in which to store the tables or use an existing database.

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

To create a database and tables for use by Analytics Scheduler

  1. Make sure that you have a valid administrative account to create a database and tables.
  2. Create the database, or use an existing database.
  3. Create the Scheduler tables by executing SAJOBS.xxx.sql (where xxx is the database type).

    Use the appropriate procedure for your back-end database, as shown in Creating Analytics Scheduler Databases and Tables for a Relational Database.

    If you are using usage statistics, create the table in SAACCT.xxx.sql.

Table 25 gives brief descriptions of the database tables used by Siebel Analytics Scheduler.

Table 25. Analytics Scheduler Table Names and Descriptions
Table Name
Table Description

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 relational database. The S_NQ_ACCT table stores all the information regarding Accounting Data.
For information about usage tracking, see Siebel Analytics Server Administration Guide.

S_NQ_JOB

This table is used by Scheduler to store information about scheduled jobs.

S_NQ_INSTANCE

The S_NQ_INSTANCE table stores information about scheduled job instances.

S_NQ_ERR_MSG

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

S_NQ_JOB_PARAM

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

  
Siebel Analytics Platform Installation and Configuration Guide