Siebel Business Analytics Server Administration Guide > Usage Tracking Data Descriptions and Using the Log File Method >

Create Table Scripts for Usage Tracking Data


The SiebelAnalytics\Schema folder contains the following Create Table scripts for DB2, SQL Server and Oracle:

  • SAACCT.Oracle.sql for Oracle
  • SAACCT.DB2.sql for DB2
  • SAACCT.MSSQL.sql for SQL Server

The sample scripts set the usage tracking table name to S_NQ_ACCT. For sites that have Siebel Business Analytics applications, this is the name used in the analytics repository. Sites that build their own repositories should name the usage tracking table to match the name in the corresponding repository.

Siebel Business Analytics Server Administration Guide