gilta03

Tech Tip: How to Add a Masking Function to your Transformation Map in Datamaker

Discussion created by gilta03 Champion on May 15, 2017
Latest reply on May 2, 2018 by Shrini_TSYS

This document can also be viewed at https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1999697.html 

 

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

 

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

Outcomes