MASKING in Delphix

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

hi,

I want to know how can we use masking feature in Delphix, please provide me any link to study how masking work in Delphix vdb.

Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
Hi Nikhil,
This can all be found in our main product docs - here is the direct link to our masking information: https://docs.delphix.com/docs/delphix-masking/masking-engine.

Something else that may be helpful is from our main website: https://www.delphix.com/platform/masking

Hope that helps!
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Thanks Jaclyn...actually I want to know one thing if we do masking for 50GB data, so how much time Delphix takes for masking around 50GB data.
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 2,996 Points 2k badge 2x thumb
Hello Nikhil,
                 Masking performance depends on multiple factors related to masking environment including primary key existence; network performance of VDB between the virtualization engine and target server residing VDB; type of data trying to mask; masking engine resources (cpu; memory) etc.

To start with masking, I will recommend creating masking job with one stream and one thread, to set the baseline performance, and continue afterward with increasing the value incrementally, if needed.

Personally, I noticed few minutes to mask around 50 GB of data. Once you run the job, you will notice "rows/minute" rate, which will be helpful to identify masking job performance.

Hope this helps

Thanks
Photo of Hims

Hims, Employee

  • 2,306 Points 2k badge 2x thumb
Hi Nikhil,
1) 50 Gb is a small-medium database which Delphix users mask with ease. 
2) Metric for masking is done in rows/min; Generic rule of thumb is 1Mil rows/min/job. Empirical time would be a few hours ( Rows to mask in the 50 GB database depends on the type of data in it ).
Photo of Nikhil Jain

Nikhil Jain

  • 494 Points 250 badge 2x thumb
Hi, Thanks for respond...so one last question can we mask schema level data, or like we refresh whole database so in masking also we have to mask whole database in Delphix
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 2,996 Points 2k badge 2x thumb
Hello Nikhil,
                  In Delphix Masking, you can pick and choose which schema, tables and columns in the database you would like to mask.

On a very high level, here is a sequence of steps:

1. Create connector to database (for each schema)
2. Create rule set (pick tables to mask)
3. Choose Inventory (pick columns to mask and apply masking algorithms)

You can follow the links for more details, mentioned by Jaclyn in the first reply.

Thanks