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:
Mainframe:
Fast Data Masker:
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)
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">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