topic Re: encrypt/decrypt component-routine etc. in Talend Studio

encrypt/decrypt component-routine etc.

Anonymous — Thu, 27 Sep 2012 14:19:56 GMT

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

Re: encrypt/decrypt component-routine etc.

Anonymous — Fri, 28 Sep 2012 08:37:54 GMT

So, does anyone have some ideas?

Re: encrypt/decrypt component-routine etc.

Anonymous — Mon, 01 Oct 2012 17:49:58 GMT

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

Re: encrypt/decrypt component-routine etc.

Anonymous — Tue, 02 Oct 2012 07:45:05 GMT

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

Re: encrypt/decrypt component-routine etc.

Anonymous — Mon, 05 Nov 2012 16:08:36 GMT

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

Re: encrypt/decrypt component-routine etc.

Anonymous — Mon, 21 Dec 2015 10:05:18 GMT

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,