ComplianceBuilder / DB 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 transfer 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.
Data Change Notifications
You 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 un-acknowledged notification.
Audit Tables
If you change the structure of a tablethat CB / DB monitors, all you need todo is recreate the corresponding Audit table. CB / DB's "Recreate" function does this seamlessly: it creates a new Audit Table based on the newstructure and preserves the old Audit Table.
Reporting
CB / DB 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.
Data Change Notifications Screenshot »
