The ClearSCADA Guide to the Database provides information about the structure of the ClearSCADA database. It also explains how to use the ClearSCADA Database Schema to locate specific information about the database tables.You may need to access this information when:
- Creating Mimics (for animations, pick action menus, embedded Lists, and so on)
- Creating Trends (trace source)
- Creating Reports
- Creating Logic programs (function block diagrams, structured text programs, and so on)
- Customizing the Alarm Banner (adding extra columns, and so on)
- Adding or modifying extra fields in the database
- Using external applications to access the database (via ODBC, OPC, SOAP, or Automation).
If you are unfamiliar with the structure of the database and how the ClearSCADA Database Schema works, we suggest that you:
- Familiarize yourself with the structure of the database (see Understanding the Database).
- Learn how to use the ClearSCADA Database Schema to view information about different tables (see Working with the Database Schema).
This guide also provides information about the Configuration Change CRC feature that can be used to help to detect whether an item's configuration has changed (see Understand Configuration Change CRCs)