topic Re: Encrypt or Decrypt a Column of Data in Talend Studio

Encrypt or Decrypt a Column of Data

Anonymous — Sat, 16 Nov 2024 10:26:42 GMT

I am working with Talend Data Intergation Studio 6.2
My requirement is I have a source table which has a credit card number column which is in Encrypted column of Oracle database table.
Using Talend I need to first Decrypt the data from that table column; perform some validation check and again Encrypt a Column of Data and then load the data into target table (Oracle 12).
tGPGDecrypt is about file data decryption is there any option in Talend DI for column data encrypt or Decrypt.

Re: Encrypt or Decrypt a Column of Data

TRF — Thu, 18 Aug 2016 20:50:05 GMT

Hi,
https://community.talend.com/t5/Design-and-Development/Encryption-decryption-using-Talend/td-p/89195.
Associated article may help even if it is in french.
Regards,
TRF

Re: Encrypt or Decrypt a Column of Data

Anonymous — Thu, 08 Sep 2016 19:23:01 GMT

Hi I used tDecrypt component however i am getting following error:-
Execution failed : Failed to generate code.

Re: Encrypt or Decrypt a Column of Data

Anonymous — Wed, 04 Dec 2019 04:56:23 GMT

You can use tAddCRCRow component to ecrypt the column/field wise data.

Inside the CRC component, the exiting default column in CRC, here you can define your schema and you need to select the "Use in CRC" Check Box for which column you need to create an encryption.

This encryption type has three options like, CRC8 / CRC16/ CRC32 under advanced settings.

https://stackoverflow.com/questions/2321676/data-length-vs-crc-length

This link is for CRC types difference understanding.

I have shared a sample screenshot below for reference.

If this really helps you, share kudos !

CRC.png
CRC2.png

Re: Encrypt or Decrypt a Column of Data

Anonymous — Wed, 04 Dec 2019 15:18:01 GMT

Hi,

From Talend version 7.2 onwards, you can use tDataEncrypt and tDataDecrypt components. Please refer the belwo links for details related to these components.

https://help.talend.com/reader/0o9b5oCDP162lzXURYPZbg/R1NAC2Od5m9jbwXnQCDjKw

https://help.talend.com/reader/0o9b5oCDP162lzXURYPZbg/yRA5MvCfuce8367kfMzc4Q

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved