scripting languages for delphix users

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi
Can Delphix user validate pattern caught by profiling regular expression programming the logic with scripting languages?
Thank you very much.
Luigi
Photo of luigidep

luigidep

  • 622 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,096 Points 2k badge 2x thumb
Official Response
HI Luigi,
you can validate the regex using any free utility like regex buddy or online resource like http://www.regextester.com/, please ensure you use javascript interpreter for validation.

--Hims
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 2,754 Points 2k badge 2x thumb
Official Response
Hello Luigidep, 
                      Regular expressions should be something similar to you find under Settings --> Expressions. 

If I understand it correctly, you want to use some script to identify sensitive data instead of regular expression?
Photo of Karsten Stoehr

Karsten Stoehr, Employee

  • 870 Points 500 badge 2x thumb
Official Response
Sounds like you want to check your original data's quality? Do you want to check if the original data is a correct fiscal code? What if it's not a valid fiscal code? Then you don't want to mask it but pass it on as it is?
The profiler uses only regular expressions, no algorithms. A second step wouldn't help. The masking algorithm during the masking run would need to validate the original value and skip it if it's not valid - if that is what you want.
Photo of Karsten Stoehr

Karsten Stoehr, Employee

  • 870 Points 500 badge 2x thumb
Official Response
Luigi,
That's what is happening. The profiler adjusts the Inventory by assigning the proper domain and its default algorithm to those fields that have matched the regular expression.