Statistica Enterprise / Statistica Server installations often require a database in SQL Server or Oracle. What is this database for and what information does it store in its tables ?

Statistica Enterprise/Statistica Server leverages the Universal Data Access as implemented by Microsoft’s ODBC and OLE DB Standards. This is seamlessly handled via the registration of a System DSN (Data Source Name) during the installation of the Statistica Enterprise Server. The repository is used to look up configurations that are specific to a Statistica environment and it stores information about all the users and their deployed configurations so they may securely collaborate in working with data and the advanced analytic modules Statistica .

It is highly recommended to make updates only through the application and to use the below tables to query only if there is a need to analyze the data stored in the Statistica meta database.

DISCLAIMER : TIBCO Support is not responsible for any manual updates made to these tables using a SQL Editor since this may corrupt the Statistica Enterprise installation. It is not recommended to update the Statistica Enterprise Repository manually. It is recommended to take regular back up of the Enterprise meta database in a production environment. ANY ATTEMPT TO MODIFY THE DATABASE WILL VOID SUPPORT WITH TIBCO UNLESS AS PROVIDED IN A HOTFIX OR WORKAROUND BY TIBCO SUPPORT.  

All sensitive information in the Enterprise database is usually stored as a BLOB or encrypted text. The tables that are not listed below are used by the application and are of no use to the end user . Some of the tables in the Statistica Enterprise Repository that may be used to query are listed below with a brief description of the information they store:

CSALARM - Contains details of MAS (Monitoring and Alerting Server) alarms that are recorded by Statistica Server
CSCHRT - Contains all the characteristics defined in Statistica Enterprise
CSCINP - Contains the mapping of Characteristics in Profile/Data Configuration.
CSCOLOR - Contains all the Colors defined in System Options>> Dashboard>>Alarm Dashboard Colors. There are 3 colors that are already in this table by default - Red, yellow and Green.
CSCustomAlarm - Contains all the alarms recorded by the SPC charts with Alarmin Node in a workspace
CSDASH - Contains information about MAS Dashboards that are stored in Statistica Enterprise.
CSDBINFO - Contains information about the version of meta database. This maybe useful if a user has a backup of an Enterprise database and is unsure of which Statistica version it corresponded to. For more details, refer to : https://support.tibco.com/s/article/Statistica-metadatabase-version-and-corresponding-Statistica-version
CSDOC - Contains information about the binary documents that stored within Statistica Enterprise
CSENT - Contains the System View Directories and the components of reports and their corresponding link to their physical path on the Statistica server.
CSEXDB - Contains information about all the Database connections that are defined in Statistica Enterprise
CSGPRM - Contains a mapping of Groups in Statistica Enterprise and the permissions each group has.
CSGROUP - Contains information about all the groups defined in Statistica Enterprise >>User Management >>Groups.
CSHDFS - Contains a list of all HDFS Servers defined in Statistica Enterprise
CSICON - Contains the icons that are used in Statistica Enterprise. There are 3 icons by default for IQC Analysis, SVB Analysis and Dashboard. More Icons can be added by using Add/Delete Icons in each folder. This is specifically useful when defining a folder a Unit Operation for Product Traceability.
CSINI - This table contains the contents of some of the system options defined in Statistica Enterprise
CSLABEL - Contains information about all the labels that are created for either Data Entry Setup inputs or labels for storing information about Action and Causes of SPC charts.
CSLOG - Stores the audit log of all the activities performed within Statistica Enterprise
CSMON - Contains information about all the analysis configurations that are deployed to Statistica Enterprise
CSNODE - Contains all the System View folders created within Statistica Enterprise.
CSOCACHE - Contains SDMS cached information used by Statistica Enterprise.
CSOPT - Contains Options for Analysis Configurations in Statistica Enterprise
CSPERM - Contains the different permissions within Statistica Enterprise.
CSPROF - Contains all the Data Configuration details created in Statistica Enterprise.
CSTS - Contains information about all the tasksets defined in Statistica Enterprise (related to MAS)
CSTSSTAT - Contains basic statistical information about run times of a taskset such as the last Run time, The number of times the taskset has run etc.
CSUPRM - Contains a mapping of Users in Statistica Enterprise and the effective permissions each User has.
CSUSER - Contains a list of all the Enterprise Manager Users corresponding to Statistica Enterprise >>User Management >>Users.
CSUSGP - Contains a mapping of Users and Groups in Statistica Enterprise

Below are some of the tables used by Statistica Data Entry:
CSCHRT - Contains all the characteristics defined in Statistica Enterprise
CSDESDAT - Used by Statistica Enterprise to map Data Entry Session ID, Sequence and Sample ID of the entered data
CSDESESS -  Used by Statistica Enterprise to map Data Entry Session ID and the Parent Sequence ID
CSDVLD - This table contains the reasonable high and the reasonable low values defined for characteristics in Statistica Enterprise
CSLABEL - Contains information about all the labels that are created for either Data Entry Setup inputs or labels for storing information about Action and Causes of SPC charts
CSLDAT - Contains mapping between sample and labelid and actual value of the label in Data Entry Samples
CSLINP - Contains the sequence of Labels in a data entry setup
CSLPDEF - Contains the default values of labels in Data Entry setups
CSPSQ - Contains the Data Entry Sequences defined in Statistica Enterprise
CSPSQDAT - Contains the sequence of Data Entry Setups in a Sequence
CSSAMP -Contains the mapping of samples and the data entry setup with the time of creation
CSSPAPPR - Contains Sample Approval details of tables in Data Entry Setup
CSSPCMNT - Contains user comments when completing,approving or rejecting a Data Entry Sample
CSSTN -  Conatins user about Stations used by Manual Data Entry Setup. This is a deprecated feature and is no longer actively used.
CSVALUE - Contains the Values of Static and Dynamic List labels in Data Entry Setup
CSVDAT - Contains the actual value entered in a Data Entry Sample.
CSVINL - Contains mapping of List Labels and their Values defined in CSVALUE

What is the purpose of some of the tables in Statistica Meta Database or Statistica Repository (that is typically named SEWSS or Statistica Enterprise) ?