Is there an option available to Pseudonymize the columns of the data uploaded using File Extractor?
Page 1 / 1
Hello,
There's no such option - you'll have to pseudonymize data by yourself using some hashing functions in excel, SQL or Python.
Python: https://www.reddit.com/r/learnpython/comments/70933y/how_to_pseudonymize_a_data_set/
https://www.geeksforgeeks.org/sha-in-python/
Vertica SQL: (Celonis backend SQL flavour - 10.1.x): https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/SHA512.htm
By default, Celonis uses SHA1/2 (or if desired, SHA 512) for pseudonymization purposes. Important: pseudonymization <> encryption! :)
Best Regards,
Mateusz Dudek
Hello,
There's no such option - you'll have to pseudonymize data by yourself using some hashing functions in excel, SQL or Python.
Python: https://www.reddit.com/r/learnpython/comments/70933y/how_to_pseudonymize_a_data_set/
https://www.geeksforgeeks.org/sha-in-python/
Vertica SQL: (Celonis backend SQL flavour - 10.1.x): https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/SHA512.htm
By default, Celonis uses SHA1/2 (or if desired, SHA 512) for pseudonymization purposes. Important: pseudonymization <> encryption! :)
Best Regards,
Mateusz Dudek
Thank you so much!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.