Data Masking in Qlik Replicate

[suvbin]

Do we have any option to mask the pii data in the sap logs or while replicating where can we do any kind of transformations. Request your help here with some detail explanation. Appreciate your help.

Thanks.

[Kushal_Chawda]

In Qlik you can mask the PII information using combination of section access and masking fields in script using autonumberhash256 function.  But if you need to mast the data using specific algorithms then Qlik will not be the right choice and you may need to rely on underlying database solutions to implement the same.

[suvbin]

Thank you Kush for the reply. So you mean in the script means, json file that the task generates ? Sorry but , can you please explain elobrately.

[suvbin]

i think  the "autonumberhash256" function is available in Qlik view or Qlik Sense. I didn't see in Qlik Replicate. Request your help here , if i missed anything here. And please let me know the process of how to mask the pii data. Thanks in advance. 

[suvbin]

Any update on this please.

[suvbin]

Any updates on this please. as to how to handle the data masking in Qlik replicate.

[Bill_Steinagle]

Hello,

Thank you for your post to the Qlik QDI Forums. The Replicate log data with the new version 2021.11 and above when we enable the VERBOSE level of logging the Data being captured for log purposes is not encrypted and the log key to decrypt the data is now in the Task directory. Without this new encryption process when we would turn on the VERBOSE logging to capture the SQL and Data debugging issues it was not encrypted (masked). During processing of the Replicate Task and Tables the data is not displayed without the lower level logging enabled which is not encrypted with the new versions of the Tool. Hope this information is helpful and please do let us know.

Thanks!

Bill

[lyka · Accepted solution]

Hello,

You can use the hash transformation or create user defined transformation to mask data:

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Custom...

hope this helps!

Thanks

Lyka