Has anyone used the Redgate Data Masker tool with GP? Maybe you have a suite of “Masking Rules” you might be willing to share?
We have a request to anonymize GP data in our lower DEV & QA environments. SOP and RM master tables, historical tables, all still have to link up properly in GP, but with realistic test data such as first & last names, addresses, email addresses.
I am curious as to what others may consier PII (Personal Identifiable Information) and how they anonymized the data. I am not looking to mask the SQL data, (aka SQL 2016 feature) but actually take a backup of Production data and restore it to a lower environment, modified and anonymized.
Sounds like a fun project!
—————————— David Morinello Senior Dynamics GP Systems Architect Ascend Learning, LLC Leawood KS ——————————
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for peopleĀ that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!