Creating a hash lookup policy

You can use the privacy policy editor to create a hash lookup policy in a data access plan.

You can add a policy to a data access plan that includes a selection policy.

Before you can create a hash lookup policy, you must define a lookup data source for the target platform selected for the policy.

To create a hash lookup policy:

  1. Expand a Data Access Plans folder for a logical data model package in the Data Project Explorer.
  2. Double-click the data access plan to include the policy.
    The data access plan editor opens.
  3. Click Data Privacy.
    The privacy policy editor opens.
  4. From the Policies area, do the following:
    1. Select a Platform that will process the policy.
    2. From the Policy list, expand Generic Lookup Privacy Policies and then click Hash Lookup.
  5. From the Attributes list, select the attribute to mask with the policy.
  6. Click Apply.
    The Add Policy wizard opens.
  7. Complete the steps of the wizard.
    • You must select a data source connection and enter a DB alias associated with the lookup table. You must also select the lookup table schema and name.
    • You must map columns in the lookup table to attributes in the source entity that will be masked.
    • You must select an attribute that will provide the values to be hashed.
    • You can specify characters that will be trimmed from the source value before it is hashed.
    • You can enter a seed value to vary the calculation performed by the hashing algorithm.
    • You must select a column in the lookup table that contains values to match against the search value from the source attribute.