Abstract: Systems and methods are provided for generating and implementing data auditing functionality supporting multiple database platforms. A database management computer system can engage a shadow audit module to automate and optimize the implementation of data auditing functionality for multiple database platforms that may be utilized by an enterprise application to record data interactions (e.g., insertions, updates, deletions, etc). The shadow audit module may run generated audit SQL code to create an audit trigger in the selected main data tables. Each audit trigger may be a procedure and/or a flag that is stored in the main data table to run or transmit a signal indicating a change may have occurred on the record indicating the required replication of the modification in the shadow audit data table.

Abstract: Systems and methods are provided for generating and implementing data auditing functionality supporting multiple database platforms. A computer system may engage a shadow audit module. The shadow audit module may generate audit code, and run the audit code against a main data table to create a corresponding shadow audit data table. The shadow audit module may also run the generated audit code to create one or more audit triggers that are placed in the main data table and are configured to run when a data modification is made to the main data table. The shadow audit module may replicate the data modification in the shadow audit data table when a data modification is made to the main data table and an audit trigger has run.