topic Re: Qlik Replicate encrypt AES256 transform function in Qlik Replicate

Qlik Replicate encrypt AES256 transform function

vlasov — Wed, 16 Mar 2022 19:14:19 GMT

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.

Re: Qlik Replicate encrypt AES256 transform function

shashi_holla — Mon, 25 Jul 2022 17:46:24 GMT

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/Customize%20Tasks/tasks_expressOther.htm

Thank you,

Re: Qlik Replicate encrypt AES256 transform function

vlasov — Thu, 18 Aug 2022 19:51:54 GMT

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

Re: Qlik Replicate encrypt AES256 transform function

lyka — Mon, 22 Aug 2022 19:13:06 GMT

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

Re: Qlik Replicate encrypt AES256 transform function

vlasov — Mon, 22 Aug 2022 19:52:50 GMT

Hi Lyka,

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

Regards,

Sergey

Re: Qlik Replicate encrypt AES256 transform function

lyka — Mon, 22 Aug 2022 20:24:31 GMT

Hello,

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

Thanks

Lyka