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

Document ID : KB000010329
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

Background:

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

Datamaker:

Mainframe:

Fast Data Masker:

There is much more information on Transformation Maps and how to create and use them in our online documentation here: http://docops.ca.com/tdm

Environment:
CA Test Data Manager (TDM)- Datamaker
Instructions:

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. 

Tools Maintain Data Functions.PNG

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

plus option to add new function.PNG

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

db options.PNG

data type option.PNG

new functions with title.PNG

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

save new function.PNG

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 https://support.ca.com/irj/portal/newhome or calling CA Customer Care at one of these numbers http://www.ca.com/us/services-support/ca-support/contact-support.html