000032673 - Obfuscation script for RSA Archer

Document created by RSA Customer Support Employee on Aug 4, 2016Last modified by RSA Customer Support on Jan 17, 2020
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000032673
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x, 6x
IssueMany clients need to be able to provide a database backup either to RSA Archer or to be able to move a database backup between environments. 

Due to security policies that may be in place, data that exists in one environment cannot exist in another.

Use the attached Obfuscation script based on your version to scramble record content. This will make it unreadable. 

Contact Archer Support if you don't find a script related to your current Archer version,
ResolutionUse one of the attached Obfuscation scripts to scramble data and make data unreadable.
  1. Take a SQL Backup of Archer Instance database prior to using Obfuscation script.
  2. Temporarily restore the SQL database to a new location.  
  3. For the temporarily restored database, set the Recovery Model to Simple so the transaction logs won't fill up.
  4. Run the Obfuscation script will run against the temporarily restored database.
  5. Perform a SQL Backup of the obfuscated database to send to Support or move to another Archer environment.
  6. DO NOT run script against a live Production environment as the data will be unreadable and a SQL Restore will be needed.