Delphix Community Platform

Hello Everyone,

I am working on a data anonymization project using Delphix Continuous Compliance to mask Oracle database tables I have encountered a particular use case involving a composite data column that includes a full name, address, and phone number. The order of this composite data is crucial and is dependent on another column labeled "type."

Could you kindly recommend the most suitable algorithm or steps to effectively mask this complex data structure?

Thank you for your assistance.

Hi Yassine,

Reading through your requirement, the multi-column algorithm framework is worth looking to see if it meets your use case (Link #1).  In (Link #2) there are opportunities to author your own plugin but is more of an advanced task typically handled by technical services @Tino Pironti.  If you haven't found a solution yet, it may be worth speaking with your AE / SE or CSM and inquire about this further.  Hope this helps!

Multi Column Condition (Algorithm frameworks)

Introduction (Authoring extensible plugins)

------------------------------
Robert Henning
Lead Member of Technical Staff
AthenaHealth
------------------------------

When you say "order of that data" do you mean vertically (sequence of rows) or vertically one column containing a value which is a composite of 3 types of information ?
If vertically then framework MultiColumnCondition is the solution > the logical column  key read the condition value to decide how to mask another column.
If horizontally frameworks SegmentedMapping or RegexDecompose are your best option to mask the pieces of the concatenated value using separate algorithms.
By authoring a custom multi-column algorithm based on our free available Java based software development kit you can do truly anything. Authoring such a multi-column framework might be challenging but you can get assistance from Professional Services.