Skip to main content
Solved

Anonymize the data

  • Jul 13, 2021 1:40 PM UTC
  • 4 replies
  • 171 views

Ann Degroat
Hero (Employee)
Forum|alt.badge.img+13

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.

Best answer by Lee Pinchbeck

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

View original
This topic has been closed for replies.

4 replies

JuniSihombing
Hero (Customer)
Forum|alt.badge.img+11
  • Hero (Customer)
  • Nov 30, 2021 12:40 PM UTC

Hi @Ann Degroat,

have you got any update about this topic?

 

~Juni


Ann Degroat
Hero (Employee)
Forum|alt.badge.img+13
  • Author
  • Hero (Employee)
  • Nov 30, 2021 2:47 PM UTC

I have not @Phil Lamerton 


Phil Lamerton
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • Nov 30, 2021 3:36 PM UTC

@Lee Pinchbeck 


Lee Pinchbeck
Ultimate Hero
Forum|alt.badge.img+24
  • Ultimate Hero
  • Answer
  • Dec 2, 2021 4:39 PM UTC

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