topic Re: Encrypting Data in Qlik replicate in Qlik Replicate

Encrypting Data in Qlik replicate

gayatri235 — Sat, 11 May 2024 15:46:15 GMT

Hi Team,

We need to encrypt PII columns from the source and also need to decrypt them if needed.

Any ideas how can we do it .

Sources : Oracle, SQL Server

Target: Postgresql

Regards,

Gayatri,

Re: Encrypting Data in Qlik replicate

Jon_Donker — Mon, 13 May 2024 05:10:22 GMT

Had a think about it. I'm not sure if there is a common column encryption method between the source(s) and destination (after a few minutes of casual googling) that you can encrypt the PII data on the source and use the key at destination to decrypt it.

Can you lock down your sources and destinations to particular users? Encryption of data in transit should be handled by the ODBC driver and if you encrypt/lockdown the data directory of qlik replicate; that should take care of the data at rest if the changes get backed up.

Re: Encrypting Data in Qlik replicate

DesmondWOO — Mon, 13 May 2024 10:14:50 GMT

Hi @gayatri235 ,

Please check whether HASH function addresses your requirements.

Regards,
Desmond

Re: Encrypting Data in Qlik replicate

Kent_Feng — Wed, 15 May 2024 23:49:37 GMT

Hi @gayatri235

Both Oracle and SQL Server supports column level encryption, however it only can be decrypted within the source database as you need an encryption key to do the job but the key won't be able to work elsewhere and also the encryption algorithm would be different in different DB system.

Replicate doesn't have an internal encryption mechanism. As @DesmondWOO recommended, you can use the hash function which will convert the column to random characters. However please be noted that this is a 'one way encryption' which can't be decrypted afterwards.

Thanks

Kent