Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vlasov
Contributor
Contributor

Qlik Replicate encrypt AES256 transform function

There is a company security requirement to keep confidential information encrypted in all new systems.

The legacy source DB has a column with the confidential data. It is not encrypted due its legacy nature. But it must be encrypted in all new systems. As we are working on replicating this table using Qlik Replicate we'd like to have a transformation function that will allow us apply AES256 encryption for this column during replication transformation. The volume of changes in this table is relatively low and performance is not a significant concern.

There are a few option to extend SQLite to support encryption https://stackoverflow.com/questions/5669905/sqlite-with-encryption-password-protection and add it to Replicate as UDF. But we don't have capacity to build and support it in our team.

 

1 Solution

Accepted Solutions
shashi_holla
Support
Support

Hi @vlasov 

You can use the hash_sha_256 transformation on the columns to encrypt the data as documented in the user guide:

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/C...

Thank you,

View solution in original post

2 Replies
shashi_holla
Support
Support

Hi @vlasov 

You can use the hash_sha_256 transformation on the columns to encrypt the data as documented in the user guide:

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/C...

Thank you,

vlasov
Contributor
Contributor
Author

Hi @shashi_holla 

Thank you for your input. The encryption and hashing have different use cases. Th hashing is a one way encoding. So we can't get the original value from it. hash_sha_256 is a hashing function.

 

Regards,

Sergey