Enabling Masking on the DB2 Table CUSTOMER

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 the data store CUSTOMER at the class (NAME and SURNAME) level.

To mask at the data-element level, double-click the desired data store from the Main Window, right-click the desired data element, and then click Data Changer Data Element Properties. Click Change, click Yes to activate the Changer option, and finally click Apply to activate your setting.

  1. In data masking, click the ALL Machine ID./Companies list.
  2. Expand the All Machine ID./Companies node.
  3. Double-click the DATAEXPRES machine ID.
  4. Select the row for the data store DELGT.CUSTOMER.
  5. Right-click and select Enable. The data store disappears from the list.
  6. Verify CUSTOMER is set as the Input Unload data store name and specify URADAR.DEMOT.MASK.new_library_name as the Output Unload data store name. For example: URADAR.DEMOT.MASK.DB2CUST.
  7. Click OK.
  8. Click the Enabled tab.
    Note: You can also choose to enable all data stores that have assigned classes with masking routines by choosing Tools > Enable All Data Stores.
  9. Select the data store DELGT.CUSTOMER, right-click, and then click Open Selected Data Store.
  10. Expand the row for the SURNAME node.
  11. Click the SURNAME class, right-click, and then click Enable.
  12. Expand the row for the NAME node.
  13. Click the NAME class, right-click, and then click Enable.
  14. Continue to the next section.
Parent topic: DB2 Data Stores Session