How to achieve decode functionality in Talend?

[Anonymous]

Hi All,

I have column SSN in one of my table in MySQL database. The SSN number are stored in encrypted form. 

So I want to extract that SSN into target file in decoded way?

Is there any possible component or alternative work around to achieve in Talend? I am using latest Talend open studio.

Regards
SB

[Anonymous]

I forgot to mention encryption of SSN is done in PHP language which is using [color=#660e7a][font=Times New Roman, serif]RIJNDAEL_128 algorithm??[/font][/color]


[color=#660e7a][font=Times New Roman, serif] [/font][/color]

[Anonymous]

Can we invoke or write a PHP by which I can Decrypt the column?
Please urgent help is required  on this issue.

[Anonymous]

This might help you
http://stackoverflow.com/questions/10136585/rijndael-encryption-with-java