Add and configure table relationships

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Is it possible to add or configure missing relationships in Delphix Data Masking Engine? 
Photo of Swathy Sukumar

Swathy Sukumar

  • 886 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 2,996 Points 2k badge 2x thumb
Official Response
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
Photo of Swathy Sukumar

Swathy Sukumar

  • 886 Points 500 badge 2x thumb
Thanks for your response Jatinder.

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

Swathy
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 2,996 Points 2k badge 2x thumb
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...

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

Thanks
Photo of Swathy Sukumar

Swathy Sukumar

  • 886 Points 500 badge 2x thumb
Thank you Jatinder!