S3 client side encryption with tDBOutputBulkExec

[Anonymous]

Hi all,

I 'd like to apply client side encryption taking data form Oracle to S3 and then use copy to insert data in Redshift.

In advancing setting of  tDBOutputBulkExec there is an option "Encrypt", when selected appears a text box where you have to put to key. (The value "AES" is just a value example )

The strange thing is that if I see the job's code generated seems that enabling the option "Encryption" generate a new variable never initialized in code.

Anyboby knows how is the right way to use client side encryption to insert data in redshift via S3? I've search a lot but I haven't found any valid documentation...

[manodwhb]

@jakovdt , have you look at below link.

https://help.talend.com/reader/1QU27dRAgeVTpWb4Bt3FMg/JGERpVM65IGqMtWnkijU5w

Select this check box to generate and upload the data file to Amazon S3 using client-side encryption. In the Encryption key field displayed, specify the encryption key used to encrypt the file. Note that only a base64 encoded AES 128-bit or AES 256-bit envelope key is supported. For more information, see Loading Encrypted Data Files from Amazon S3.

By default, this check box is cleared and the data file will be uploaded to Amazon S3 using server-side encryption.

For more information about the client-side and server-side encryption, see Protecting Data Using Encryption

[Anonymous]

Hi,

thanks for you reply. I saw that link but to be honest I'm still wondering how can I do client side encryption with that bulk load component... because if I select option Encrypt a compilation error appears in code tab..

Have you a configuration example for showing?

Thanks.

J