• Installing the module
  • Items created during installation
• Configuring the DDAudit database
• Updating the named database connection
• Accessing DigDash BI audit data
• Location of DDAudit database files

This document describes the installation and configuration of the DigDash BI audit module. In particular, this module enables administrators to view audit information, such as the list of data cubes and Flows, and the history of user sessions.

Installing the module

You can deploy the audit module from the DigDash Metadata Service:

1. Launch Studio.
2. Click the ‘Managers’ button in the left-hand sidebar.
3. In the box that appears, click on DigDash Metadata Service.
   
   
   ➡ The DigDash Metadata Service box appears .
4. Search for and select the Audit Module component corresponding to your version of DigDash BI. In this example, version 2025R2 is used.
   
5. Click Install Now.
6. When the installation is complete, the following message appears:
   
7. Click OK, then Close.
   ➡ A message stating that the interface has to be refreshed appears.
8. Click Yes.

Items created during installation

The following items are created during installation:

• A connection named Ddaudit.
• A DDAudit role containing:
  • predefined data models for creating visualisations from audit data;
  • predefined flows (list of cubes, flows and user sessions);
  • a dashboard for viewing audit data.

Configuring the DDAudit database

You must configure a DDAudit database to store the audit data. We recommend using a MariaDB database. MySQL and PostgreSQL databases are also supported.

To do this:

1. From the home page, go to Configuration > Server Settings > Database > Audit Data.
2. Enter:
   • The database URL
   • The databaseusername and password.
     

3. You can also carry out the following operations:

   • delete old data: enter a date up to which you wish to delete data in the ‘Delete audit events up to’ field.
   • set the data retention period: enter a number of days in the ‘Data retention’ field.

Updating the named database connection

Once the database has been configured, update the named connection ‘DDAudit’ created during the module installation.

1. Open the Managers tab in Studio.
2. Click Databases to open the Database Connection Manager.
3. Select and edit the Ddaudit database.
4. Enter your database connection details.
5. Restrict access to the database to the DDAudit role.
   
6. Check that the connection is working by clicking the Test Connection button.
7. ClickOK.

The database connection is updated in all audit data models.

Accessing DigDash BI audit data

To access audit data, assign the DDAudit role to the DigDash BI administrator or any other authorised user.

From the Configuration > Server Status page, start the audit services you wish to use (session, cube and Flow audit services, etc.).

The predefined dashboards are accessible from the Dashboard, within the DDAudit role.

You can also create your own flows based on data models, or even new data models based on the audit database.

Location of DDAudit database files

In some cases, you may need to change the location of the DDAudit database files.
See the page Changing the location of DDAudit database files for further information