Sample Session

Creating a Masking Class

You can create new classes to be used for masking purposes, or you can use a predefined class. In this exercise you will create a masking class named ZIPCODE.

1. In Data Builder, open the Work with Classes window (click or access it through Environment > Work with Classes).
2. Click New.
3. In the Name field, specify ZIPCODE as the name of the class you want to create.
4. In the Full description field, specify ZIPCODE as the description of the class.
   Note: The description will be visible as a label when you assign the class to data elements within data stores.
5. Specify UDCZIP5 in the Data Masking Routine box.
   Note: This masking routine is provided during product installation.

   You can mask at the class level or at the data-element level. In this tutorial, we will be masking at the class level.

6. Select the Super Class Privacy.
7. Select the data type Alpha.
8. Leave the remainder of the fields at their default values. Click Apply.

   The class ZIPCODE is now listed at the bottom of List of Classes.

9. Click OK.
10. Continue to the next section.

Associating a Masking Class to Data Elements

In this exercise you will be manually associating the ZIPCODE class you just created with columns in tables CUSTOMER and EMPLOYEE.

1. Open the Work with Data Elements window (click or access it through Environment > Work with Data Elements).
   Note: If a message appears indicating that the default confirmation options have not been set, click Yes to set them; click Apply, and then OK in the Options window. However, this should not occur if you followed the previous steps in the tutorial Using Data Express.

   You can also access the Work with Data Elements window from the main window by selecting the file name, right-clicking to view the context menu, and then by clicking Work with Data Elements of the Selected Data Store.

2. Click the Apply Filter button to display all data stores:
   Note: To narrow down the list of data elements displayed, use the filter fields (Machine ID, Company name, and Application ID), and then click Apply Filter. To display all data elements, simply click Apply Filter.
3. Click the Classes - Assignment tab.
4. In the All Classes pane, expand the Privacy Super Class, and then select the class ZIPCODE.
5. Click the Data Store column to sort data elements by data store.
6. In the List of Data Elements, select the row for CUSTOMER.ZIP. (That is, select the row for the data storeCUSTOMER and the name ZIP.)
7. Click the Assign Class button to assign the ZIPCODE class to CUSTOMER.ZIP.

   ZIPCODE now appears in the Assigned Class column for CUSTOMER.ZIP.

8. In the List of Data Elements, select the row for EMPLOYEE.ZIP. (That is, select the row for the data store EMPLOYEE and the name ZIP.)
9. Click the Assign Class button to assign the ZIPCODE class to EMPLOYEE.ZIP.

   ZIPCODE now appears in the Assigned Class column for EMPLOYEE.ZIP.

10. Click the Close button to close the Work with Data Elements window.
11. If you are planning to go straight on to the next tutorial Simple Data Subset Extraction, you can keep Data Builder open. Otherwise, either Click File > Exit or click the button, and then click Yes.
12. Continue to the next chapter.

Starting the Data Masking Module

To start Data Masking:

Enabling Masking

Data Masking lets you to enable masking for individual data stores or all data stores, and to enable masking at the data-element level or class level.

• You can mask at the class level or at the data-element level. In this tutorial, we will be masking at the class level.

In this exercise you will activate masking for all data stores (EMPLOYEE and CUSTOMER) at the class (ZIPCODE) level.

Enable masking:

1. Click Tools>Enable All Data Stores.
   Note: Only the data stores that have assigned classes with masking routines defined will be enabled.
2. Click Yes to continue.

   The data stores are now listed in the table on the Enabled tab. For a list of data stores that do not have assigned classes, click the Disabled tab.

3. Continue to the next section.

Exporting Masking Information

In this exercise you will export your masked information so that the Extension Technology can mask your data.

Export masking information:

1. Click (Distributed Exporter) from the main window of Data Masking. The Distributed Exporter window is shown:
2. In the Machine ID list, click ALLIE.
   Note: If you have not created any additional Machine IDs, ALLIE will be selected by default.
3. In the Company list, click DXPROJ.
   Note: If you have not created any additional Company names, DXPROJ will be selected by default.
4. Click the Select Target button.
   Note: If you have already completed this tutorial once, your target database will already be listed. If this is the case, you just need to select the row for the GSDEMO database from the Target Database List and then click OK. You can then continue to step 9.
5. Click Add.
6. Enter the following details for the target (leave the remaining fields unchanged):

   Database	GSDEMO
   Type	ODBC
   User name	install
   Password	1

   Note: In this tutorial, the source and target databases are the same.
7. Click OK to close the Add Target window.

   The database you added now appears in the Select Target Database window.

8. Click OK to close the Select Target Database window.
9. In the Distributed Exporter window, in the Target schema field, specify TGT.
   Note: You must specify a Target schema name different from the Source schema name if the target database is the same as the source database.
10. In the Output directory, specify the odbc\config subfolder of your data directory. For more information, see the section Data of chapter Extension Technology Directory of Part 3. Using Extension Technology. For example: c:\Documents and Settings\All Users\Application Data\Micro Focus\Data Express 4.0\odbc\config
    Note: Files needed for the ODBC Extension and Oracle Extension must be placed in the config directory of your default data directory on Windows. In this tutorial you will be invoking the ODBC Extension from a Windows environment; therefore, you will specify this directory as your output directory.
11. Click Export.
12. Click Yes.
13. Click OK.
14. Click Close.
15. Exit Data Masking. Click File > Exit or click the button, and then click Yes.
16. Continue to the next section.

Executing Masking

By default, the Extension Technology will attempt to insert the processed data into the target database. Execute masking with Extension Technology:

1. From a MS-DOS prompt, change to the executables directory c:\Program Files\Micro Focus\Data Express 4.0\odbc.
2. 2. Type dxestart The target ODBC data store now contains masked tables TGT.EMPLOYEE and TGT.CUSTOMER.
3. The execution finished without errors, so you are prompted to view the log file. Type Y to view the file.
4. Close the text file.
5. Continue to the next section.

Verifying Results

Verify that the zip codes in the masked tables are in fact different:

1. Launch the SQL Wizard:

    ..\mfsql\bin\xwiz40n 
   		

2. Notice that the values in the Zip Code column for SRC.EMPLOYEE and SRC.CUSTOMER are different in TGT.EMPLOYEE and TGT.CUSTOMER.