db-anonymiser

The db-anonymiser is a powerful tool designed to facilitate the anonymization of database data in compliance with RGPD regulations. This utility supports major databases including MS SQL Server, PostgreSQL, and Oracle, providing users with a robust solution for data privacy.

Key Features

• Java-Based Application: Requires Java 17 to run and includes an executable JAR file.
• Configurability: Utilizes a JSON configuration file to define data sources and anonymization rules dynamically.

Prerequisites

To utilize the db-anonymiser, ensure the following:

• Ensure Java 17 is installed and configured on your machine.
• Obtain the JAR file for db-anonymiser.
• Create a JSON config file for database anonymization.

Usage Instructions

To execute the program, run the following command, specifying the JSON configuration file:

java -jar dbanonymizer.jar application.json

If encountering memory issues, consider increasing the JVM maximum memory size with the -Xmx parameter, as the application typically consumes between 200 and 400 MB.

JSON Configuration Structure

The JSON file consists of two primary sections:

1. Datasources: Define multiple data sources for the application.

   Example:

   "databases": [
       {
           "refId": "myuniqueRefId1",
           "driverClassName": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
           "url": "jdbc:sqlserver://;serverName=myservername1;databaseName=mydatabasename1;encrypt=true;trustServerCertificate=true",
           "username": "test",
           "password": "test"
       },
       {
           "refId": "myuniqueRefId2",
           "driverClassName": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
           "url": "jdbc:sqlserver://;serverName=myservername2;databaseName=mydatabasename2;encrypt=true;trustServerCertificate=true",
           "username": "test",
           "password": "test"
       }
   ]
   

   Each refId must be unique for proper identification.

2. Anonymisation Rules: Specify the rules dictating how data should be anonymized.

   Example:

   {
       "tableName": "Table1",
       "primaryKey": "id",
       "columnName": "column1",
       "anonymiser": "COMPANY_NAME",
       "databaseRefId": "myuniqueRefId1"
   }
   

   Anonymization types include:

   • COMPANY_NAME
   • CREDIT_CARD
   • DATE
   • EMAIL
   • FIRST_NAME
   • FULL_NAME
   • LAST_NAME
   • PHONE_NUMBER
   • SIMPLE_NAME
   • CITY
   • POST_CODE
   • STREET_NAME
   • ALPHANUM
   • LITTERAL

   For the LITTERAL type, specify the actual value to anonymize with the litteralValue attribute:

   Example:

   {
       "tableName": "Company",
       "primaryKey": "Company_Id",
       "columnName": "BRN",
       "anonymiser": "LITTERAL",
       "litteralValue": "00000",
       "databaseRefId": "myuniqueRefId2"
   }
   

Conclusion

The db-anonymiser provides a flexible and effective means of protecting sensitive data while maintaining the functionality of databases in compliance with data protection regulations.