How to run pre SQL or post SQL in a TDM Portal masking job

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Could you please guide us on how to run the Pre and Post SQL's scripts in TDM portal? In FDM we have POSTSQLCODEFILE and PRESQLCODEFILE masking options, however these options are not found in the TDM Portal.

Environment

Release : 4.10

Resolution

We automatically generate the SQL scripts, that can be used to disable triggers and FK constraints when we scan the tables. See the screenshot below.

We have added the ability to run Pre and Post scripts from TDM Portal. This enhancement is included in TDMWeb-4.10.176.0 or greater.

Additional Information

TDM Patches are available for download at https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649