General technical aspect of the right of erasure

Unica Collaborate provides the gdpr_purge.bat/sh utility. Unica Collaborate users may use this utility to generate delete statements for customers' records that are required to be erased from the Unica Collaborate system. These delete statements are generated for the Unica Collaborate system tables. Customer records that are required to be erased are provided in an input file and the output is the generated delete statements. Collaborate tables section includes the Unica Collabroate system tables in which customer data may reside (for which delete statements are generated) .
Note:
  • In version 12.1.0.4, the GDPR tool generates Audience_name.sql file. The SQL file is generated in GDPR home example, <COLLABORATE_HOME>/tools/GDPR/Customer_0.sql.
  • If more than one audience is defined in Collaborate and customer wants to generate delete SQL for all audiences, then no action is required.
  • For Unix environments, use dos2unix command before executing GDPR scripts.

If customer wants to generate delete SQL for selective audiences, for example, if total audiences defined is three, but customer generates delete SQL only for two of those audiences, then the way to do this is add all three audiences to gdpr.properties, but keep the .csv file empty for the audience so that delete SQL is not required to be generated.