Qlik Replicate encrypt AES256 transform function

[vlasov]

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.

[shashi_holla · Accepted solution]

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]

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

[lyka]

Hi @Sergey 

I suggest submitting a feature request in our Ideation Board:

To get started please see our article: "Getting Started with Ideas": https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Getting-Started-with-Ideas/ba-p/1684011

Thanks

Lyka

[vlasov]

Hi Lyka,

Thank you for the suggestion. I was not able access the link you've shared.

Regards,

Sergey

[lyka]

Hello,

Sorry about that - please try this link: https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Thanks

Lyka