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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-01-18 06:47 AM

How to achieve decode functionality in Talend?

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

Labels (2)
Labels
285 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2017-01-18 07:13 AM
Author

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]
285 Views
0 Likes
Anonymous
Not applicable
‎2017-01-18 07:16 AM
Author

Can we invoke or write a PHP by which I can Decrypt the column?
Please urgent help is required  on this issue.
285 Views
0 Likes
Anonymous
Not applicable
‎2017-01-18 08:37 AM
Author

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