Procedure: High Level

This section describes the high level procedure to execute the Unica Campaign GDPR utility.

Before you begin

The input csv file containing customer records that are required to be deleted must be created.

About this task

Guidelines for creating input csv file:

  • String values containing special characters like space, comma, and so on, in customer data should be enclosed in double quotes (“)to the input Customer.csv file.
  • AudienceID should be the column name of the input Customer.csv file. In case of composite Audience level, the audience id should be comma separated.
  • The input CSV file that contains customer information to be deleted from the Unica Campaign system tables can be generated through Unica Campaign using the select and snapshot process box , output only the AudienceID field into the CSV file.

Configure gdpr.properties: Specify Audience information, Audience Level history tables information, input records file (that is required to be erased from the Unica Campaign system), and so on. In case, no additional audience level is used in Unica Campaign, please mark as a comment the section that mentions the properties for additional audience level. Else, copy and paste the section on Additional audience level for all additional audience levels used in the Unica Campaign system. Then, modify the section according to each audience level.

Procedure

  1. Run gdpr_purge.bat / sh
  2. Review the SQL Output generated by the GDPR tool.
  3. Take a backup of the Unica Campaign System tables.
  4. Execute SQL Output by DBA on Unica Campaign system tables for all the partitions configured.
  5. Verify that the desired customer information is deleted.