Finance | Project Operations, Human Resources, ...

Data encryption/manipulating after database refresh D365fo

(1) Share

Report

Posted on by Hussamdeeb

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,

I have the same question (0)

All responses (4)

Answers (0)

Daniel Cai 935 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Adria Ariste User Group Leader on at

Like (0)

Report

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!

Was this reply helpful? Yes No