You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Purging all the transactional data from the database.

Received Response
edited Jul 3, 2021 8:08PM in General Technical Discussions 1 comment



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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!