SQL Server example

This section shows how to set up audit trails for a SQL Server table.

The following Customers table will be used as a writeback destination table.

This example assumes that you already have an existing extension using the Customers table as the destination table

To enable audit trails for the Customers table:

1. Create a new table Customers_log with the same structure as the writeback destination table and add the extra auditing columns

Note that the Id column (customer id) is not a primary key on this table since it will be duplicated on the Customers_log table. If you want to assign an id for each audit row, you can add a RowId column and set it as an identity column.

2. Go to the writeback extension in Qlik sense and enable logs

3. Enter Customers_log as the Audit log table name

4. Go to your writeback extension, add a record and click on Save.

5. Edit the existing record and click on Save

6. Open the Customers_log table

As you can see from the Customers_log screenthost, Qommentary audits all changes made by users.