Purging all the transactional data from the database.
As part of the GDPR process we are currently looking into anonymizing data on all our test environments. This mainly includes any personal information that could be used to identify contacts like name, date of birth, address, phones and emails.
Whilst developing a custom script to anonymize the data I came across an issue of purging the transaction data where a lot of confidential information is stored in audit logs.
Sadly the PHP Connect does not support deletion from the transactions table. I had a look at Data Lifecycle Policy feature but unfortunately the tool does not solve my problem. The pre existing rules for purging transactions are set to delete data older than 6 months and they can not be modified. I am also unable to create a new rule for transactions.