Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Hi @gayatri235 ,
Please check whether HASH function addresses your requirements.
Regards,
Desmond
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