Delphix Products

Expand all | Collapse all

Add and configure table relationships

Jump to Best Answer
  • 1.  Add and configure table relationships

    Posted 10-11-2017 10:03:00 AM
    Is it possible to add or configure missing relationships in Delphix Data Masking Engine? 


    #Masking


  • 2.  RE: Add and configure table relationships
    Best Answer

    Posted 10-11-2017 12:17:00 PM
    Hello Swathy,
                        If I understand it correctly, you like to add and configure referential constraints between tables after masking job.

    If this is the case, you can use pre or post scripts while creating a masking job.

    Pre or post scripts allow you to attach a file containing SQL statements or any operation you would like to perform on the database, part of masking job.

    This will help you to automate the process.

    Thanks


  • 3.  RE: Add and configure table relationships

    Posted 10-12-2017 05:10:00 AM
    Thanks for your response Jatinder.

    Can I have any reference link for pre and post scripts to work with MySQL DB?

    Swathy


  • 4.  RE: Add and configure table relationships

    Posted 10-12-2017 12:11:00 PM
    Hello Swathy,
                        You will find prescript and postscript option while you create masking job.

    Please refer to this link, https://docs.delphix.com/docs/delphix-masking/masking-engine-user-guide/masking-engine-overview/mask...">https://docs.delphix.com/docs/delphix-masking/masking-engine-user-guide/masking-engine-overview/masking-your-data">https://docs.delphix.com/docs/delphix-masking/masking-engine-user-guide/masking-engine-overview/mask...

    In above link, you will find create masking job dialog box, which has both options available.

    Thanks



  • 5.  RE: Add and configure table relationships

    Posted 10-13-2017 09:15:00 AM
    Thank you Jatinder!