First of all we don't mask randomly, we always focus on deterministic masking, a critically important difference.
You can mask a TAX code and use Name, DOB, ... values to compose the Tax ID as long as those columns are in the same table, the approach to achieve that is called a multi-column algorithm. OutOftheBox there are only a view MC (multi-column) frameworks .. but using the freely available masking SDK you can create such a framework. Further this allows you to mask in ONE step the First/LastName, DOB, ... and use the masked results to compose the TaxID, this is done using CHAINING, means one algorithm can call unlimited other algorithms.
You could also use a post-script but in that case you would process the entire table twice (once for masking and once for post-script) therefore the MC approach is more efficient.
Delphix PS offers an masking SDK plugin for names called "NAMES" that has capability to preserve gender (dedicated gender detection based on value and/or using a gender column).
Based on your name I could imagine you are Italian? Are you looking for a logic to mask CodiceFiscale ? We have a solution in plugin SSN that contains SSN/Tax logics from some countries.
Delphix offers SDK trainings to assist customers getting up-to-speed with plugin development, if you wish to get a PS plugin/get a SDK training please get in touch with your Sales/CustomerSuccess partner to arrange a session to discuss.
------------------------------
Tino Pironti
Masking SME
Technical Manager
Delphix
------------------------------
Original Message:
Sent: 02-06-2025 04:09:28 AM
From: Simone Bianchi
Subject: Custom masking algorithm based on the value of other masked data
Hello everyone,
Is it possible to create a masking algorithm that transform an element based on already masked data?
Let's say that I have in the database the following data:
- Name
- Surname
- Date of Birth
- Place of birth
- Gender
- Tax ID Code
Name, Surname, Date of Birth and Place of Birth can be masked randomically through out-of-the-box Delphix algorithm, but TAX ID Code should be transformed based on the values of masked name, surname, date of birth, place of birth, gender.
Is it something doable with Delphix? Should I use post script or there is there something else?
Also, if the database doesn't have gender column, is there some plugin from Delphix to understand gender from the name column?
Kind regards,
------------------------------
Simone Bianchi
------------------------------