Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Data encryption/manipulating after database refresh D365fo

(1) ShareShare
ReportReport
Posted on by 7

Hi,

After copying the data from Prod environment to test environment, some users get more access for testing purposes, but i don't want them to see the actual data , i want them to see data only which meaningless

so if i have customers in the database i want it to be mixed up or salaries to be changed,

any idea how that can be done ? does Microsoft has something like that ? or does anyone has any custom SQL code to apply on the database ?

Thanks,

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Data encryption/manipulating after database refresh D365fo

    We (KingswaySoft) offer a Data Anonymizer component that runs within SSIS pipeline and it can take any data, anonymize it before writing to a different system. This is part of our SSIS Productivity Pack product offering, which you can use along with our Dynamics toolkit (which has been mentioned in this thread). 

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at
    RE: Data encryption/manipulating after database refresh D365fo

    This can be achieved with scrubbing data with SQL scripts. You have to write your own SQL scripts to manipulate the data. We are doing like this in our environments.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Data encryption/manipulating after database refresh D365fo

    You can do that by developing an SQL script that changes the data that you want to change. Then run this script after db refresh, before enabling users in the system.

  • Suggested answer
    Adria Ariste Profile Picture
    Adria Ariste User Group Leader on at
    RE: Data encryption/manipulating after database refresh D365fo

    There's no 365 tool to obfuscate data after a DB refresh, the process only cleans the standard elements that are not copied after a refresh.

    If you really need this you'll have to do the extra work. Check Azure SQL Dynamics data masking (you'd need to export and import data which I don't know if it's worth the time) or some tools like Kingswaysoft and SSIS. Maybe it's easier to do the testing with the Contoso DB and add some random data from the customizations you have (if there's not a lot of them). But anyway, I think something like this requires to invest some time whatever is the solution you choose.

    Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans