Change Tracking Framework Diagrams

Change Tracking Framework Diagrams

Diagram C01Change Tracking Framework Data Tables
Diagram C02Change Tracking Framework Configuration Tables

Diagram C01. Change Tracking Framework Data Tables

Change Tracking Framework Data Tables

Change Tracking Framework allows tracking changes of the configured tables.

Use the logs.view_captured_objects view to check and create table triggers for tracking changes.

These triggers write table record changes into the logs.change_logs table.

The framework generates the required configuration using logs.view_administrator_handlers and logs.view_translations views to add the context menu items for tracking changes in Microsoft Excel.

Use the logs.base_tables table to link views and procedures to the underlying tables.
The framework generates context menu items for such views and procedures using settings of the specified base tables.

Add users who can check changes to the log_users role.
These users can revert changes if they have INSERT, UPDATE, and DELETE permissions on the underlying tables.

Add users who can configure change tracking features to the log_admins role.
The administators must have the permission to CREATE and DROP triggers in the target schema.
To clear logs, administators must also have UPDATE permissions on the captured tables.

The generated triggers and procedures use the logs.tables table to find the underlying objects if the underlying object_id or name are changed.

Diagram C02. Change Tracking Framework Configuration Tables

Change Tracking Framework Configuration Tables

Change Tracking Framework includes complete copies of SaveToDB Framework tables.

This allows using Change Tracking Framework as is, without additional requirements.

The logs.handlers table contains the handler configuration.
It configures action menu items.

The logs.translations table contains translations of database objects, columns, parameters, and generated help headers.

The logs.formats table contains Excel table formats for framework objects.
The SaveToDB add-in applies these formats in the first connection to database objects.
Users can save and reload table formats using SaveToDB Table Format Wizard or Save Table Format and Load Table Format menu items.

The logs.workbooks table contains a configuration to generate a workbook to edit the database help.
Use the Application Workbooks wizard to generate it.