Solved

Anonymize the data

  • 13 July 2021
  • 4 replies
  • 122 views

Userlevel 4
Badge +12

The customer has Migrated Some Real Data in Dev Environment and is looking for a way to anonymize the data. Since this is a standard request in Eurpean Region but not for FSM, we are looking for a Script that can be used in Cloud Environment to anonymizethe Data.

icon

Best answer by Lee Pinchbeck 2 December 2021, 17:39

View original

This topic has been closed for comments

4 replies

Userlevel 3
Badge +10

Hi @Ann Degroat,

have you got any update about this topic?

 

~Juni

Userlevel 4
Badge +12

I have not @Phil Lamerton 

Userlevel 7
Badge +17

@Lee Pinchbeck 

Userlevel 7
Badge +24

Hi @Ann Degroat,

There are a scripts to anonymise the data packaged with the FSM installer. They can be found at the following default file path C:\Installs\FSM6_0_0_U13\DatabaseData\SQLServer\FSM6_Truncation.

The script as it comes will delete everything so it must first be reviewed and the elements you wish to retain commented out of the script so that they are not deleted.

If you are referring to a different type of data clean up then we would need specifics to address how to potential achieve that.

Kind regards,

Lee Pinchbeck