See matching posts in thread - On the Fly Mas...
This video follows on from the "File Masking - In Place" video, using the same environment to set up the target masking information and creates a source environment where the file will be masked from. The use case for this was about using file masking to find specific records in a test environment that has been masked, when you want to identify records associated with a "real" (unmasked) value. For instance perhaps you want to find credit card transaction records for a specific user. The on the fly masking allows you to separate the duties for each file location, so that the real credit card is never exposed to the users of the test environment. Video location here: https://youtu.be/JrX0J0jD6J0 (8m 49 secs)N This video runs as follows: 1) Create a connection (File - Delimited) to the target SFTP file location. 2) Ensure you have the csv file to mask available in the source directory and the target directory. 3) Create a Ruleset and select the CSV file to mask. 4) Create the File Format (a text list of column names - we only use a single column name to mask a credit card (PAN) value. 5) Edit the Ruleset to add the file format 6) Review and update the inventory by selecting a masking algorithm (minute 2:40) 7) Now create a source environment 8) Create a source Connection to the source file to mask 9) Create a Ruleset in the source environment 10) Create the "on-the-fly" masking job, choosing the correct source environment and source connector 11) Check the values in the file systems and run the masking job. 12) Check that there is a file in the right location with masked values in it. 13) Choose those values and search if them in the source database
Join @Aaron Tully , a Delphix Technical Account Manager, as he provides a brief demonstration of On-the-Fly Masking of files. Walking you through source and target and showing both the unmasked and masked data. #r vid #security #on-the-fly masking #file masking
file_masking_demo.mp4
See matching posts in thread - Tip of the Day: Using On-......Wit...
See matching posts in thread - Configure Delphix for On the ...
See matching posts in thread - Delphix Masking - Parametrization of list - On ...
See matching posts in thread - dxmc tool to create "on the ...
See matching posts in thread - Need Clarity in In Place / On the...
While working with customers I suggest the ON-THE-FLY masking method. In many cases the inbound customer file(s) may have several purposes other than masking such as being loaded into a production database, distributed to internal document servers, or other business needs. Using this method my source connector needs read only permission to access this file and masking will not alter any file(s)in the source location. ON-THE-FLY masking is where Delphix Masking reads theSource file to be masked, masks the file in memory, and writes the masked file to the Target location. Here the sensitive file(s) remain unchanged and the masked file is written to a development or less secure folder
The objectives of this run-through are to allow you to try: Fixed-width file masking : the width or length of column(s) or field(s) in the files to be masked are defined. On-the-fly masking: On-The-Fly (OTF) masking work with a source environment/connector and a target environment/connector, it is an ‘Extract Transform Load’ (etl) process
2 attachments