topic Re: S3 client side encryption with tDBOutputBulkExec in Talend Studio

S3 client side encryption with tDBOutputBulkExec

Anonymous — Sat, 16 Nov 2024 03:03:30 GMT

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...

Re: S3 client side encryption with tDBOutputBulkExec

manodwhb — Sat, 07 Mar 2020 10:39:11 GMT

@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

Re: S3 client side encryption with tDBOutputBulkExec

Anonymous — Mon, 09 Mar 2020 16:38:00 GMT

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.