Published nxs-data-anonymizer 1.9.0, a tool for dumping databases in PostgreSQL and MySQL/MariaDB/Percona. The tool, written in Go, is released under the Apache License 2.0.
The program enables data anonymization based on templates and functions from the Sprig library. NXS-DATA-ANONYMIZER can be used via non-interactive channels (PIPE) in the command line to redirect dumps from the original database directly to the target database with necessary transformations. The anonymization process can be monitored with progress indicators displaying operation status. By using external commands in the “Type: Command” column, field values can be set.
Depending on the entity type in security settings, the tool anonymizes columns for tables based on rules outlined in the Filters section. If a table lacks rules, the data remains protected as the anonymizer excludes them from the resulting dump.
The latest version includes the addition of the Link block to the column filter, enabling the anonymization of interconnected database entities across multiple tables. This block retains rules for anonymizing interconnected columns in tables specified in the configuration throughout the database. Consequently, cells in specific columns that shared values before anonymization will preserve those values post-anonymization.
Moreover, it is now possible to operate with once-granulated data using global variables through a specially developed module, facilitating generation for use in filters.