Wiki source code of Déploiement du module d'audit (DDAudit)
Last modified by Aurelie Bertrand on 2025/12/19 11:11
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{ddtoc/}} | ||
| 2 | |||
| 3 | |||
| 4 | ---- | ||
| 5 | |||
| 6 | (% class="wikigeneratedid" %) | ||
| 7 | This document describes the installation of the audit module integrated into DigDash Enterprise. This module enables a system administrator to view the list of data cubes and Flows as well as the history of user sessions. | ||
| 8 | |||
| 9 | = Installing the module = | ||
| 10 | |||
| 11 | You can deploy the audit module from the**Digdash Metadata Service//~://** | ||
| 12 | |||
| 13 | 1. Launch the **Studio**. | ||
| 14 | 1. Click on the **Managers** button in the left-hand sidebar. | ||
| 15 | 1. In the box that appears, click on **DigDash Metadata Service**. | ||
| 16 | [[image:Managers_EN.png||alt="Managers" height="445" width="767"]] | ||
| 17 | ➡ The **DigDash Metadata Service **box appears. | ||
| 18 | [[image:DigDashMetadata_service_EN.png||alt="DigDash Metadata Service"]] | ||
| 19 | 1. Select the **New Audit Module** component and click **Install Now**. | ||
| 20 | When the installation is complete, a success message is displayed | ||
| 21 | 1. Click **OK** and then **Close**. | ||
| 22 | |||
| 23 | == (% style="color:inherit; font-family:inherit; font-size:max(20px, min(24px, 12.8889px + 0.925926vw))" %)Items created during installation(%%) == | ||
| 24 | |||
| 25 | A new **DDAudit** role containing the following elements is created: | ||
| 26 | |||
| 27 | * Pre-defined data models for creating visualisations of audit data | ||
| 28 | * Pre-defined flows: list of cubes, lists of flows and lists of user sessions | ||
| 29 | * A dashboard displaying audit data | ||
| 30 | |||
| 31 | = Configuring the DDAudit database = | ||
| 32 | |||
| 33 | You need to configure a DDAudit database to store audit data. We recommend using a MariaDB database. MySQL and PostgreSQL databases are also supported. | ||
| 34 | |||
| 35 | To do this | ||
| 36 | |||
| 37 | 1. From the home page, go to **Configuration -> Server settings -> Database -> [[Audit data>>doc:Digdash.deployment.configuration.configuration_guide.audit_data.WebHome]]**. | ||
| 38 | 1. Enter : | ||
| 39 | 1*. The **URL of the database** | ||
| 40 | 1*. The **User** and **Database password.** | ||
| 41 | [[image:Audit_data_EN.png||alt="Configurer base de données"]] | ||
| 42 | |||
| 43 | 1. ((( | ||
| 44 | You can also : | ||
| 45 | |||
| 46 | * delete old data: enter a date until which to delete the data in the **Delete audit events until** field. | ||
| 47 | * set the data retention period: enter the period in numbers of days in the **Data retention period** field. | ||
| 48 | ))) | ||
| 49 | |||
| 50 | (% class="box warningmessage" %) | ||
| 51 | ((( | ||
| 52 | ❗If you change this connection information, don't forget to change the named connection to the DDAudit database. | ||
| 53 | ))) | ||
| 54 | |||
| 55 | = Creating the named connection to the database = | ||
| 56 | |||
| 57 | Once the database has been configured, you need to create the database connection. To do this: | ||
| 58 | |||
| 59 | 1. Display the Studio **Managers** tab. | ||
| 60 | 1. Click **Databases**. | ||
| 61 | 1. Click the **+** button to create a new database connection. | ||
| 62 | ➡ The **Edit Database Connection** box appears. | ||
| 63 | 1. Select the **SQL** type. | ||
| 64 | 1. Enter the name of the connection: **DDAudit**. | ||
| 65 | 1. Then enter your database configuration information. | ||
| 66 | 1. Leave the database restricted to the **DDAudit** role. | ||
| 67 | [[image:DBConnection_Audit_EN.png||alt="DDAudit connection"]] | ||
| 68 | 1. Check that the connection works by clicking on the **Test connection** button. | ||
| 69 | 1. Click** OK**. | ||
| 70 | |||
| 71 | We will now select the database connection in the data models. | ||
| 72 | |||
| 73 | = Selecting the database in the data models = | ||
| 74 | |||
| 75 | To link the audit data templates to the database connection : | ||
| 76 | |||
| 77 | 1. In the Studio data templates panel, go to the **DDAudit** role tab. | ||
| 78 | 1. Edit the data models and select **DDAudit** from the **Connection** drop-down list.[[image:1766134088880-278.png||alt="Connection"]] | ||
| 79 | 1. Click **Reload **to refresh the preview. | ||
| 80 | 1. Click **Finish**. | ||
| 81 | |||
| 82 | = Accessing DigDash Enterprise audit data = | ||
| 83 | |||
| 84 | In order to view this information you need to add the **DDAudit** role to your DigDash Enterprise administrator or any other user you wish for this task. | ||
| 85 | |||
| 86 | From the **Configuration -> Server Status** page, start the audit services you wish to use (session audit service, cubes and flows, etc).[[image:Audit_services_EN.png||alt="Audit services"]] | ||
| 87 | |||
| 88 | Predefined dashboards can be accessed directly from the** **Dashboard, in the DDAudit role. | ||
| 89 | |||
| 90 | [[image:1766136875249-788.png||alt="Dashboard"]] | ||
| 91 | |||
| 92 | You can also create your own flows based on data models, or even new data models on the audit database. | ||
| 93 | |||
| 94 | = Location of DDAudit database files = | ||
| 95 | |||
| 96 | In some cases, you may need to change the location of DDAudit database files. | ||
| 97 | See the page [[Modifying the location of DDAudit database files>>doc:.DDAudit_location.WebHome]] for more information |