Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Sooraj1
Contributor II
Contributor II

AWS KMS Encryption Decryption in talend

Hi, I have a use case where we are receiving the AWS KMS encrypted file in s3 and this file i have to decrypt in talend for data load. Has any one ever worked around it ?

 

Thanks

Labels (3)
13 Replies
Sooraj1
Contributor II
Contributor II
Author

Tried running using 

context.kms_value

 

But still same error.  

quentin-vigne
Partner - Creator II
Partner - Creator II

From your earlier screenshot I see you are passing 5 values in your tJavaRow component 

What does your file contains ? If it contains various rows it's only going to use the last value of your file as encryption key 

 

You need to treat each file individually especially if each one of them has it's own encryption key, because you're risking using the wrong encryption key to decrypt the file

It looks like you're on the right way for you job, if you want just use 1 file for the moment and try to add tLogRow to monitor the variable passing by and make sur it's the right value.

- Quentin

Sooraj1
Contributor II
Contributor II
Author

Hi Quentin,

 

i am using only one file to decrypt the csv file using the key file (which supposed to have the key), you are right i am getting 5 rows from that file. i am also not sure why we are getting 5 rows in the key file. i am attaching the screenshot of the key file data :

 

Sooraj1_0-1744014236183.png

 

Sooraj1
Contributor II
Contributor II
Author

It seems like the key file is also encrypted which need to be converted to plaintext first and then used for decrypting the CSV file, Any idea how we can implement it in talend job?