:: Vital Path - Compliance Builder

ComplianceBuilder / SharePoint Edition

Powerful Compliance Tools for Enterprise Databases

ComplianceBuilder / Database provides management and control of any RDBMS-based system, including SQL-based applications, batch systems and custom-developed DB applications.

CB / DB is designed to monitor data changes in Oracle database tables, record each change event and maintain an archive of all changed records. You can instruct CB / DB to issue and route data change notifications, and to require an authenticated acknowledgement and sign-off.

CB / DB can monitor data changes on one or multiple Oracle databases. Users set up these easy-to-configure parameters via CB / DB’s Web menu-driven interface.

For each database table you want to monitor, CB / DB creates a corresponding Audit Table that mirrors the structure of the monitored table. CB / DB also creates triggers that monitor the target table and transfers any data changes to the Audit Table. The transferred information includes a record of the change event as well as the complete record that was modified.

ComplianceBuilder Database Features

Data Change Notifications can specify whether CB / DB should issue and route notifications upon detecting database table changes. If notifications are issued, when a Data Change Event occurs, CB / DB sends a notification to the address where the change originated, or to a specific pre-configured group. You can specify whether notification sign-off is required, and how long CB / DB should wait before it “times out” an unacknowledged notification.
Audit Tables If you change the structure of a table that CB / DB monitors, all you need to do is recreate the corresponding Audit table. CB / DB’s “Recreate” function does this seamlessly: it creates a new Audit Table based on the new structure and preserves the old Audit Table.
Reporting offers comprehensive database change reporting capability as a standard feature.The SQL Data Changes Report displays data from monitored RDBMS records in both summary and detail formats. You can optionally configure the report to display only selected database tables or fields, or only the old/new values of the data that was changed.