In general, you can submit "Request for Enhancement" ticket. Support will ask clarifying questions. There's chances the idea has already been submitted and other customers are looking for it too. Also alert your Customer Success Manager so they can follow up internally.
For Partial Masking, how would you want it to work? I'm trying to understand your use case.
In a standard workflow, you won't have access to the unmasked copy. In that case, how could you tell which one hasn't changed? My point is that without the unmasked copy, you would never know that one of them wasn't shuffled. In a list of 100k, how would you know? Also, assuming that other PII fields in the same row have been masked, is the one field that wasn't shuffled actually a problem?
I recommend submitting a support case for this. Get justifications from your business partners. Relay your concern to your Customer Success Manager.
Sr. Database Architect
Original Message:
Sent: 09-12-2023 09:27:24 AM
From: Karteek Muthyala
Subject: Masking digits
Thank you Kevin
Yes, I will use the custom SQL, but just wonder if Delphix support any new feature for partial masking.
And for this "Without a copy of the unmasked data, how can you pick out the values that didn't change?", Yes I comapare both unmaksed and masked data,
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-12-2023 08:53:38 AM
From: Kevin Bott
Subject: Masking digits
I have tried SL and Secure shuffle, but its not masking as per the customer requirement. After masking job execution, I can see still some rows are not masking, and keeping the original value.
KBA4088 states that:
The shuffle is random and will be different from execution to execution.
It does not mention a guarantee that values will change.
Without a copy of the unmasked data, how can you pick out the values that didn't change?
------------------------------
Kevin Bott
Sr. Database Architect
Northwestern Mutual Life Insurance Company
Original Message:
Sent: 09-12-2023 01:54:25 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
Thank you sandro, I will use this option once my engine get upgraded. But I have ADF Delphix masking engine, and I can see the new feature in that, but am not able to establish a connection for SQL servers on this ADF delphix engine. Once I upgrade our on-premise delphxi engine, will try that option. Between I have couple of other questions on clients asks.
1) The client requirement is similar to digits, they have some text in rows. After masking the row 1 should be masked by row 2 or others. And row 2 should masked with row1 or others. is it possible in Delphix new feature?
ex:
| Before Mask | After Mask |
| Meinke | Ma'Roof |
| Harwood | Meinke |
| Vergie | Harwood |
| Ma'Roof | Skidmore |
| Skidmore | Vergie |
Note: I have tried SL and Secure shuffle, but its not masking as per the customer requirement. After masking job execution, I can see still some rows are not masking, and keeping the original value.
2) Client have 20000 records, where he want to mask only 15000 records and rest all ( selected rows) should not mask. Is it possible?
I mean does delphix support this Partial masking?
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-11-2023 08:32:18 AM
From: Sandro Latini
Subject: Masking digits
Hi Karteek,
I would recommend to upgrade the Masking engine to any version after 6.0.15.0 so that you can use the new Segment mapping algorithm. Otherwise, if you have an engine using a newer version, you can test the same set of data there to see if upgrading resolves the issue.
------------------------------
Sandro Latini
Senior Principal Support Engineer
Delphix
Original Message:
Sent: 09-11-2023 06:05:17 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
The logic with Character Mapping only working when we have a consecutive numbers like 0,1,2,3. But when we have a digits like 1,2 and 9, the same login AL is not working. and its giving error message. I want to mask the 1,2 and 9 with same numbers. like ,1 should be masked 2 or 9. 2 should be mask with 1 or 9 , and 9 should be mask with 1 or 2. Kindly suggest.
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-07-2023 03:16:44 AM
From: Sandro Latini
Subject: Masking digits
Hi Karteek,
That is great news! Thank you for sharing the solution.
------------------------------
Sandro Latini
Senior Principal Support Engineer
Delphix
Original Message:
Sent: 09-07-2023 01:26:41 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
Today I tried in different method in character Mapping AL , the issue has been sorted out. and masking working as I expected.
Thank you All. Please look at the image.
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-07-2023 12:47:39 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
We are using 6.0.12.1. Give me some example?
Ana am unable to open the given link from the other thread. https://maskingdocs.delphix.com/Authoring_Extensible_Plugins
- 
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-06-2023 06:00:08 AM
From: Sandro Latini
Subject: Masking digits
Hi Karteek,
What is the version of the engine? The screenshot shows a Segmented mapping Legacy. Segmented mapping v2 has been introduced with Masking version 6.0.15.0.
The minimum length of the Segment is 2 in the old Segment mapping algorithm, whereas it's 1 in the new algorithm.
------------------------------
Sandro Latini
Senior Principal Support Engineer
Delphix
Original Message:
Sent: 09-05-2023 09:58:16 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
No, let me show you the image, 
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-05-2023 09:05:01 AM
From: Sandro Latini
Subject: Masking digits
Hi Karteek,
Did you try to map a single digit to another single digit only, like in my example above? For example, 0 to 3, 1 to 2, 2 to 0, 3 to 4 and 4 to 1.
Please let me know if that helps.
------------------------------
Sandro Latini
Senior Principal Support Engineer
Delphix
Original Message:
Sent: 09-05-2023 08:35:14 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Sandro
I have verified and tried the Segment Mapping, but its not working. and keeping the duplicate values.
My ask is like, if the original values are 0,1,2,3, so that after masking, the 0 should be 1,2,3 and 1 should, be 0,2,3 and 2 should be 0,1,3 and 3 should be 0,1,2 thats it. Please suggest me the perfect solution
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
Original Message:
Sent: 09-05-2023 07:53:49 AM
From: Sandro Latini
Subject: Masking digits
Hi Karteek,
In order to clarify your requirement, do you need to map 0 to 2 and 1 to 3 etc or would you like to replace the original value to 2301?
I believe that Segment Mapping would fit your needs in either case: Segment mapping as you can either map the digit to another digit or mask it with a constant number.
If your use case is diverse, please provide further examples.
------------------------------
Sandro Latini
Senior Principal Support Engineer
Delphix
Original Message:
Sent: 09-05-2023 06:04:59 AM
From: Karteek Muthyala
Subject: Masking digits
Hi Team
I would like to mask the digits in the below format.
The original data 20000 records, but all values in table has, 0,1,2,3 only. and I want to mask those digits in below format only.
Please suggest which AL to use? I have tried secure shuffle, but all values are not masking.
Scenario 1:
Database value | 0 | 1 | 2 | 3 | |
Masked value should | 2 | 3 | 0 | 1 | |
------------------------------
Karteek Muthyala
Information Security Engineer
Wells Fargo Bank, N.A.
------------------------------