APIPythonOpen-Source Solutions

Expand all | Collapse all

How to handle multiple schemas masking of same database

  • 1.  How to handle multiple schemas masking of same database

    Posted 10-06-2017 03:57:00 PM

    We have operational data store where database is structured with multiple schemas. Means, there is no master or global schemas where all tables can be browsed. To implement masking, multiple connections to be made with different schemas and multiple masking jobs to be built for same database.

    But, product doesn't allow to map multiple masking jobs while creating VDB from dSource. Is anyone come across this situation and solution to handle?


    #Masking


  • 2.  RE: How to handle multiple schemas masking of same database

    Posted 10-06-2017 04:04:00 PM
    Hi Santosh,
    Delphix Masking works on schema based architecture essentially for a security required minimum needed access standpoint.
    Usual ways to handle this:
    1. Add  a synonym or object owner who is having access to all required schemas.
    2. If we have multiple jobs, Delphix users usually call a script via a hook which will call multiple masking jobs.

    --Hims


  • 3.  RE: How to handle multiple schemas masking of same database
    Best Answer

    Posted 10-06-2017 04:10:00 PM
    Hi Santosh, you need to configure the "Configure Clone" hook script of your new masked vdb you're provisioning. In this script you should call all masking jobs minus one. The last job can be selected from the combo box of the provisioning wizard form. If you are interesteed I can send you a sample script to invoke via RESTful job start command. Regards. Gianpiero


  • 4.  RE: How to handle multiple schemas masking of same database

    Posted 10-06-2017 04:15:00 PM
    Wow !! some working solutions. That would be great if you have samples to share and attach here.


  • 5.  RE: How to handle multiple schemas masking of same database
    Best Answer

    Posted 10-09-2017 07:20:00 AM
    Hi Santosh,

    this is the REST API doc: https://docs.delphix.com/docs/delphix-masking/delphix-masking-quick-start-guide/masking-api-calls-to...


    You could use curl or any other programming language to interact with ordinary rest API


    Best Regards.
    Gianpiero



  • 6.  RE: How to handle multiple schemas masking of same database

    Posted 10-31-2017 06:58:00 PM

    Hi Gianpiero,

    So far, I was busy with profiling data and mapping masking rules. Reached a stage where I need to start putting some code together.

    It would be great help if you have any sample script that you have coded.

    Thanks,

    Santosh



  • 7.  RE: How to handle multiple schemas masking of same database

    Posted 10-31-2017 07:11:00 PM
    Ok. Tomorrow I'll be back to you with some scripts. Regards


  • 8.  RE: How to handle multiple schemas masking of same database

    Posted 11-02-2017 12:43:00 PM
    Sorry for my late reply. Send me an email gianpieropiccolo at gmail.com and I'll send you back my shell script.
    Regards.
    Gianpiero


  • 9.  RE: How to handle multiple schemas masking of same database

    Posted 11-02-2017 12:55:00 PM
    If you do not need automatic refresh or provisioning of your masked vdb, you could mask manually a first vdb (let's call it vdb1) with your masking jobs and for the last job you could provision a masked vdb as a child of vdb1.


  • 10.  RE: How to handle multiple schemas masking of same database

    Posted 11-02-2017 01:31:00 PM

    True, this approach can work for manual. the whole idea is to bring delphix as self service for development and testing communities. Earlier, I thought 1-2 databases have multiple schemas, but I was wrong and there are many to handle. So, automation is the need for us.



  • 11.  RE: How to handle multiple schemas masking of same database

    Posted 11-02-2017 01:33:00 PM
    Ok, I'm waiting for your email to send back to you the shell script