Database Models
TIBCO Configuration Tool (TCT) allows you to configure separate databases for ActiveMatrix Administrator, Database realm, Common logging service and Monitoring service.
By default, the DDL Script Generator generates four separate scripts for each model:
| Scripts | Description |
|---|---|
| admin | The database schema for the core functionality in ActiveMatrix Administrator |
| security | The database schema for Database authentication realm, specifically needed to store users and groups in the database (not applicable for LDAP) |
| commonlogging | The database schema that stores log and payload records created by the Common Logging service. |
| governance | The database schema that stores metadata used by the Monitoring service. The metadata has a separate schema than the actual monitoring data; although they can be in the same database. |
By default, the DDL generator produces scripts for every model. Depending on which databases you want in each model, execute the script for that model in its corresponding database. You can skip one or more DDL scripts if you do not want to use that functionality for the model. For example, while using LDAP authentication realm you skip the DDL scripts for the security model.
The default name for DDL files is composed of <action>_<model>.ddl (where <action> is create, drop or update).
For example, create_admin.ddl is the schema creation script for the core functionality in ActiveMatrix Administrator. Similarly, drop_admin.ddl is the schema deletion script.