One Star

encrypt/decrypt component-routine etc.

Hi,

I would like to know how can I crypt/decrypt some input from a delimited file let`s say. Ways to do this in talend?
(I have already find a way to do this by using the pwdStore routine, but I think it would be nice to be able to decrypt some existing data in a file; I have also tryed tScramble, but currently it has bugs)
For example, the content of the delimited file could look like:
user="hass";
port="1234";
sid="oradb";
password="©???ñ?c©+s5";
After reading this file I want to use the decrypted password value in a toraoutput component.
Thanks
5 REPLIES
One Star

Re: encrypt/decrypt component-routine etc.

So, does anyone have some ideas?
Employee

Re: encrypt/decrypt component-routine etc.

You can write a routine to encrypt and decrypt stuff where you can use the standard java encryption mechanism
One Star

Re: encrypt/decrypt component-routine etc.

Hi,
Sounds great, but I`m not so good at java coding. Could you give me an example?
(I already used such a routine written by Saburo - http://www.powerupbi.com/talend/pwdStore.html ) Altough this is very usefull, I would like to be able to decrypt some input from a specific field in a file. (with the routine mentioned above you can store duplets composed of an alias and the password in an encrypted flat file, and only then retrieve and use the crypted passwords)
Thank you for your reply
One Star

Re: encrypt/decrypt component-routine etc.

Hi Neinfrantu,
I'm facing the same issue, did you manage to find an answer on this issue?
One Star

Re: encrypt/decrypt component-routine etc.

Hi,
I've written a tutorial in french describing how to crypt data in configuration files.
6 ways are proposed.
pwdStored in tested in it.
If it can help.
Best regards,
Gaël,