API/Python/Open-Source Solutions

Expand all | Collapse all

scripting languages for delphix users

Jump to Best Answer
  • 1.  scripting languages for delphix users

    Posted 02-07-2017 05:05:00 PM
    Hi
    Can Delphix user validate pattern caught by profiling regular expression programming the logic with scripting languages?
    Thank you very much.
    Luigi


  • 2.  RE: scripting languages for delphix users
    Best Answer

    Posted 02-08-2017 04:00:00 PM
    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


  • 3.  RE: scripting languages for delphix users
    Best Answer

    Posted 02-08-2017 04:05:00 PM
    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?


  • 4.  RE: scripting languages for delphix users

    Posted 02-08-2017 04:23:00 PM

    Yes.

    For example with regular expression we can match a pattern similar to fiscal code.

    But at least in italy we know there is an algorithm that apply some rule to derive the  last charater in the code from previous characters. It will be useful if we can a create workflow  that at the first step launch from command line delphix to match all possible recurrences of fiscal code and then terminate it and then follow a second step that take inputs from the preceding output and refines the result by applying validation algorythm.


    Something similar to control delphix by programming script such as python or javascript


    Luigi



  • 5.  RE: scripting languages for delphix users
    Best Answer

    Posted 02-09-2017 09:22:00 AM
    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.


  • 6.  RE: scripting languages for delphix users

    Posted 02-09-2017 09:44:00 AM

    Thank you for the reply.

    Since i have to profile big data i would like to be secured that data i'm going to mask are effectively what i was going  to match by the profiler.

    Luigi




  • 7.  RE: scripting languages for delphix users
    Best Answer

    Posted 02-09-2017 09:52:00 AM
    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.