Delphix Products

  • 1.  MASKING in Delphix

    Posted 09-07-2017 11:13:00 AM

    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.



  • 2.  RE: MASKING in Delphix
    Best Answer

    Posted 09-07-2017 02:57:00 PM
    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">https://docs.delphix.com/docs/delphix-masking/masking-engine">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!


  • 3.  RE: MASKING in Delphix

    Posted 09-08-2017 09:39:00 AM
    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.


  • 4.  RE: MASKING in Delphix
    Best Answer

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


  • 5.  RE: MASKING in Delphix
    Best Answer

    Posted 09-08-2017 02:43:00 PM
    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 ).




  • 6.  RE: MASKING in Delphix

    Posted 09-11-2017 12:02:00 PM
    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


  • 7.  RE: MASKING in Delphix
    Best Answer

    Posted 09-11-2017 12:09:00 PM
    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