How to Add a Masking Function to your Transformation Map in Datamaker

Products

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

Issue/Introduction

This document will outline the steps to add masking functions that are missing in Transformation Map's drop down list for a specific database. We will use the masking function FORMATENCRYPT with z/OS as an example on how to do this.

Below is some documentation for using Transformation Maps with different Test Data Manager components. 

Datamaker:

• Work with Transformation Maps: Work with Transformation Maps (broadcom.com)
• Design Transformation Maps for iSeries V7R1 (DB2/400):Design Transformation Maps for iSeries V7R1 (DB2/400) (broadcom.com)
• Filter Options for Transformation Maps: Filter Options for Transformation Maps (broadcom.com)
• Custom Filter Functions for Transformation Maps: Custom Filter Functions for Transformation Maps (broadcom.com)

Mainframe:

• Create File Transformation Maps: Create File Transformation Maps - Masking (broadcom.com)
• Create Transformation Maps: Create Transformation Maps for DB2 Masking (broadcom.com)

Fast Data Masker:

• Use Transformation Map Files: Use Transformation Map Files (broadcom.com)

There is much more information on Transformation Maps and how to create and use them in our online documentation here: CA Test Data Manager 4.10 (broadcom.com)

Environment

CA Test Data Manager (TDM)- Datamaker

Resolution

It is possible to add masking functions that are missing in Transformation Map's drop down list for a specific database by doing the following:

 

1. From within Datamaker, click on the 'Tools' option in the toolbar. 

2. Choose the 'Maintain Data Functions' option from the drop down list. 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxGAAW" alt="Tools Maintain Data Functions.PNG" width="327" height="248">

3. In the top, right-hand corner, click the green plus (+) mark icon to add a new function. 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxEAAW" alt="plus option to add new function.PNG" width="346" height="78">

4. Your new row will appear at the bottom of the list. Enter in the Database, Datatype, Function, and Description. 

- For example: Database = z/OS, Datatype = Character, Function = FORMATENCRYPT, Description = Consistently change the current value preserving format and keeping unique values 

5. You may need to create a second row for the same masking option if the Datatype is different. In this example, we are adding a second row for Dataype 'Character' to show this.

- For example: Database = z/OS, Datatype = Numeric, Function = FORMATENCRYPT, Description = Consistently change the current value preserving format and keeping unique values

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxCAAW" alt="db options.PNG" width="168" height="149">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxBAAW" alt="data type option.PNG" width="154" height="95">

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxDAAW" alt="new functions with title.PNG" width="1257" height="70">

6. In the top, right-hand corner, click the 'Save' icon.

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AJxFAAW" alt="save new function.PNG" width="333" height="53">

You have now successfully added new masking functions to your Transformation Map options.

Additional Information

If you experience any issues, please open a support case by going to home - Support Portal - Broadcom support portal or calling CA Customer Care at one of these numbers Contact Support - Support Portal - Broadcom support portal