Question / Problem:
Is it supported to query the TotalAgility product databases?
Answer / Solution:
In general it is not supported to query the TotalAgility databases. Data from the system should be retrieved only though documented and supported API calls.
Reporting and Analytics
There is a subset of tables and columns that are documented and supported specifically for use in context of analytics. The following links are for KTA 7.7, but the appropriate documents for each version of KTA are available from the full documentation list for that version.
Diagnostic and Troubleshooting Queries
Knowledgebase articles and Technical Support cases will recommend queries to run as part of general troubleshooting or to diagnose specific issues. These are meant to be run at the direction of Technical Support for troubleshooting/diagnosis, and do not imply any that they are supported in any other context.
Modification of the databases is not supported.
However, to work around or fix an issue, Technical Support may provide a script that modifies the database. This is to be run only at the explicit direction of Technical Support. The general recommendation is to take a backup of all KTA database before running a script that will make a modification.