Does anyone have experience of masking sensitive data in a sandbox?

Our organisation holds lots of sensitive data, specifically in the User object.

We also use multiple sandboxes for development, and as a security step, would like to mask (de-sensitise) selected fields once we have refreshed our sandboxes from production. This refresh task would likely take place at regular intervals.

Also we are providing these sandboxes access to some external vendors, inoder for them to restrict from contacting users.

Other than Dataloader/Informatica ( since its taking manual effort), what would be the alternative way of masking the data.

Appreciate the response.

Thanks, Pavan

  • 1
    DBAmp, you can create a stored procedure that would do the work for you and just run it after every refresh. – gNerb Feb 28 '18 at 16:28

There are a couple of solutions to this:

  • Homegrown - Use the SandboxPostCopyInterface and write your own apex class that implements method runApexClass(context). This can kick off a batch class to do the anonymization.

  • Vendor appexchange solution like OwnBackup

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.