Encrypt or Decrypt a Column of Data

[Anonymous]

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.

[TRF]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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