Data Obfuscation

Discussions concerning general integration topics.

Moderator: Phil Barton

Post Reply
sollila_LT
Posts: 3
Joined: Thu Oct 07, 2021 4:19 pm

Data Obfuscation

Post by sollila_LT »

As part of our development process, we regularly restore a backup of our production environment to our development environment. We've been asked by the audit team to obfuscate some of the data points after the restore. We've tried to identify and overwrite the fields directly in the database, but these changes aren't reflected when opening the order in the client. Saving the order seems to revert the changed data back to its original values. Could I be modifying the wrong tables? Is this supported at all? Is there a another recommended approach to this?
BobRichards
Posts: 1376
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Data Obfuscation

Post by BobRichards »

You cannot do what you want by modifying pfm tables. They are primarily for reports and table search indexes.

For the most part, the order object holds the working copy of all its data. It is serialized to/from the appropriate order version to the pf.OrderHistory table. As the order is saved and stored in the pf.OrderHistory table, it automatically updates the pfm tables. This architecture was chosen since it is faster than serializing the order from multiple SQL tables and to prevent customers from manually editing state tables and creating unstable orders (this was a problem before we took this strategy).
Bob Richards, Senior Software Developer, SoftPro
Post Reply