Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

cancel
Showing results for 
Search instead for 
Did you mean: 
vlasov
Contributor II
Contributor II

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

5 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 II
Contributor II
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

lyka
Support
Support

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
Contributor II
Contributor II
Author

Hi Lyka,

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

 

Regards,

Sergey

lyka
Support
Support

Hello,

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

Thanks

Lyka