Hi I followed the procedure described by Shong on this link :- https://help.talend.com/pages/viewpage.action?pageId=28671224&focusedCommentId=31065832#comment-3106... Now i have doubt regarding default value of context variable,is it the actual password or something else? please light on the issue if anyone have gone through it. Apart from this when i am trying to connect to oracle 10g database using procedure above described i am getting following error: Exception in component tOracleInput_1 java.sql.SQLException: ORA-01017: invalid username/password; logon denied When i manually enter password,no issue at all.I easily get connected to database and can fire any query i want.
Hi Viannou, First of all thanks for you reply and your suggestions regarding ROT13 algo and its pitfalls. It works for me Thanks a ton for that.. I have another doubt What if password contains some numeric value,in that ROT13 won't encrypt that. Can you provide me any link or demo showing how to encrypt such password in talend job.
Hi Thanks for nice explaination,So you are saying i should use ROT5 with ROT13. what i have got you are just dividing the whole alphabets or number available such 26/2=13 in case of alphabets(ROT13) and 10/2=5 in case of numbers(ROT5).You are adding 13 or 5 accordingly,that's fine. But what if password contains characters like #,@,$ and so on,in that case what to do? Would you please provide me code how can i use ROT47 if problem(@,#,$,%) cann't be solved using ROT13
rot13 is not encryption and should not be used for passwords. If you really want to encrypt your passwords, you should be looking at something like pgp or gpg. rot13 was maybe good enough 2000 years ago.