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

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

book

Article ID: 258437

calendar_today

Updated On:

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.

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=KlcBHMmgDPV12BHg1KYTgA==

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