SQL schema as database model input
From this version is it possible to create g9 Anonymizer projects from import of database models based on SQL files with CREATE TABLE statements.
Multiple database schemas/connections
You may now mix several schemas from SQL or database connections. The generated program however, will only have support for one connection. All database operations must use this one and only connection.
Map Input only, Output only, Input and Output
In earlier versions, map was defined as an Anonymization Column function. This function is removed and replaced with properties on the remaining Anonymization Column functions. The properties are organized with heading Mapping File where you can define the wanted mapping type.
Fast Cascading Delete
There are 3 different methods supported for deleting a record and its children and you can choose the method that fits best.
Export to ANO file
We will in the near future release several cloud services similar to g9 Anonymizer. The services are based on the ANOnymization language. This Export to ANO file function will create an ANO file containing the same information as the Anonymization model and rules.
Every task can have SQL statements run before and after running the task itself. This is useful if it is necessary to disable/enable functions, triggers or other database mechanisms during the updates.
Set repeatable random
If you need the same behavior on all runs, use the
setRepeatableRandom(true) function. It will ensure that random functions use the same seed every time.
Erase functions with Cascading anonymizations that accepts NULL value in the foreign key, have the property Set null to foreign key, where it is possible to set true/false. Using true will generate use of
Vendor specific database type
JDBC type 1111 (Other) is imported as VENDOR_SPECIFIC_TYPE with default type
unknown.VendorSpecificType. This type cannot be used in anonymizations.
This is g9 Anonymizer
g9 Anonymizer provides a fully programmable anonymization solution and solves some of your GDPR requirements. It connects to your JDBC compliant database and constructs a database model from which you can define
- anonymization rules
- data deletion rules for sub-setting data
- rules for creating synthetic data
- erase rules for complying with Erasure requests
- Subject Access Request rules
g9 Anonymizer is an Eclipse plugin that generates JDBC application code. The runnable application opens a database connection and executes the specified SQL queries. Foreign key definitions are used to propagate data anonymizations across related tables. The anonymyzation can be repeated and be performed on multiple databases to ensure data consistency.
It builds a JAR file containing all rules including the Javadoc and source code. The JAR file can be independently run against a test database or it can be integrated into other programs for performing GDPR tasks.