password decryption from .item files?

[Anonymous]

I'm currently trying to load contexts from job exports' .item files, but have some problems with the password encryption.

My test job has the password "jelszo", which is encrypted as "xlwfPYy+C+k=" in the .item file. But how could i get "xlwfPYy+C+k=" decrypted?

tContextLoad doesn't do the decryption, it just gives back the encrypted password; the only solution i found on this forum, PasswordEncryptUtil.decryptPassword("xlwfPYy+C+k=") doesn't work either (in fact, PasswordEncryptUtil.encryptPassword("jelszo") gives back "fe4fa1e083f07ef9", so it looks like a totally different encryption method).

Do you have any advice, or is it simply not possible? I mean, Talend surely decrypt these somehow, but if it's a method only the Studio / the Administration Center can use, then it's a dead end.

Many Thanks,

Balazs

[Anonymous]

Hello,

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

Have you tried to decypt the passwords using the routines to see if it come out the expexted result?

Best regards

Sabrina

[Anonymous · Accepted solution]

Thanks for the suggestion. With some tLibraryLoads (org.talend.utils.jar, commons-codec-1.10.jar and org.talend.daikon_0.2.0.RELEASE.jar), it's almost simple:

org.talend.utils.security.CryptoHelper.getDefault().decrypt("xlwfPYy+C+k=") gives back "jelszo" as it should.

[MZein]

Hi

Could you please give me an explaination to your solution as I have the same problem and need to solve it quickly. I tried your solution but it gives me an error (org.talend.utils can not be resolved to a variable) so I thaink the problem is how to import this library

Looking forward to your suggestion

Regards

[Anonymous]

Hello @MZein

Are your database passwords as stored in the .item files encrypted? There is a community article about:https://community.talend.com/t5/Design-and-Development/Data-encryption-in-Talend-7-2-1/ta-p/200397 

Best regards

Sabrina