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.
Last updated
Was this helpful?