How to read and write encrypted values on Postgresql with Talend Data Integration

Anonymous — Wed, 28 Feb 2018 10:33:26 GMT

Hi there,

I'm new at Talend Data Integration and now I'm facing the challenge to read and write data from a Postgresql DB which is encrypted with the database encryption function pgp_sym_encrypt.

How can I read and wirte values from this DB?

Thank you for your support.

Best regards,

Ricardo

Re: How to read and write encrypted values on Postgresql with Talend Data Integration

Anonymous — Wed, 28 Feb 2018 15:09:36 GMT

So I solved it by myself! It was easier than I expected... (such a noob)

To read decrypted you just have to change the select query, for example:

SELECT pgp_sym_decrypt( [DB].[SCHEMA].[TABLE].[FIELD],[ENCRYPTION_KEY]) as [FIELD_NAME],
FROM [DB].[SCHEMA].[TABLE];

[DB].[SCHEMA].[TABLE]

To insert is a little bit "trickier" but also quite simple... In your tPostgresqlOutput, go to "Advanced settings" and use Additional columns and replace the ones you want to encrypt with the expression "pgp_sym_encrypt( ? ,[ENCRYPTION_KEY])"

Sorry for the simple question.

Best regards,

Ricardo

topic Re: How to read and write encrypted values on Postgresql with Talend Data Integration in Talend Studio

How to read and write encrypted values on Postgresql with Talend Data Integration

Re: How to read and write encrypted values on Postgresql with Talend Data Integration