Highlighted
Respected Contributor.. Respected Contributor..
Respected Contributor..
177 views

(SM) Support Tip : How to purge sensitive data from DB while collecting db dump

How to purge customer sensitive data from DB while collecting db dump

 What is the tool?

 This tool is designed to purge customer sensitive and transaction data (business files). With tool, we have the default out-of-box (oob) business files, and can select more oob files or customized files which contain the sensitive data for customer. After purging those business data, customer then make a DB dump from this DB with full schema but no any business data for support troubleshooting or RnD assessment. 

How to use the tool?

 In a copy of production DB, connect SM with the DB, import the attached unload, in SM command box, input bzpurge unloads (attached below), follow the wizard to use default business files, add other oob files or customized files to business file list, and purge all the data from the selected business files.

 1)  Go to System Navigator > Tailoring, click “Database Manager”

1.jpg

 

 2)  Go to more choices menu, click “Import/Load”

2.jpg

 3)  Locate the unl file for purge tool

3.jpg

4)  In SM command box, input “bzpurge”, and click Enter key

 4.jpg

 5)  Follow the wizard step by step

5.jpg

6. Select additional SM tables you want to purge sensitive data to right side (please send me the additional table list for me to double check)

6.jpg

 7)  Select your added SM tables you want to purge sensitive data to right side

7.jpg

😎  Confirm the final list of SM tables you want to purge sensitive data

8.jpg

9)  Confirm it is a copy of PROD database, not the PROD database.

9.jpg

10) Wait for the finished message.

10.jpg

 

Other OOB files are recommended to keep in system, Other customer files can be purged

Note: Keep at least one SM operator with System Administrator user role for RnD to login SM Windows client to do upgrade assessment (sensitive fields like name, address, email should be removed of course).

 Please ensure the tool is used on the DB backup and not on actual production DB.

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.