Skip to main content

Audit

Auditing is the process of tracking and recording changes made to a DB entity. It logs INSERT, UPDATE, and DELETE operations, helping with data integrity, compliance, and troubleshooting.

Benefits of Auditing​

  • Tracks Changes – Maintains a history of modifications.
  • Security & Compliance – Helps meet regulatory requirements (e.g., GDPR, HIPAA).
  • Debugging & Troubleshooting – Identifies unexpected changes.
  • Data Recovery – Restores data in case of accidental deletion.

Steps to Create an Audit​

  1. Open Entity Audit Settings:

    • From the Explorer menu, right-click on the entity and select Audit.
    • The Properties Panel will slide up from the bottom.

  2. Select Audit Options:

    • Choose the operations to track:
    • INSERT – Logs new records added.
    • UPDATE – Tracks modifications to existing records.
    • DELETE – Records data before deletion.
    • Select specific columns to audit or choose Select All to track changes in all columns.

  3. Save & Apply:

    • Click Save to confirm the changes.
    • A success message "Audit saved successfully" appears.

Upon successful selection, the message "Audit changes applied successfully" appears.