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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading encrypted password using tcontextload

Hi,
I have saved database connection params into properties file using tcontextdump. The password param has the password type (not string), so it is masked with **** in the file.
I tried to load these params using tcontextload component and got an error saying "wrong user or password", it seems that it is due to the fact the password is encrypted. I tested with password as string and it is working.
Does it mean that if i want to use tcontextload from a properties file, the password should in clear text ?
Thank you for your help
Best Regards
Labels (2)
3 Replies
Anonymous
Not applicable
Author

Unfortunately the password decryption only takes place in case of the Job loads the context properties as internal file - means it does not work in the implicit context load. You can of course create a routine to achieve the same.
Anonymous
Not applicable
Author

Thank you jlolling,
So for example, when i have a group context with database connection parameters, i have to dump context this way:
1) tcontextdump---->tjavarow (using encrypt routine with if statement on the password parameter)---->tfileproperties
And load the context this way:
2)tfileproperties ---->tjavarow (using decrypt routine with if statement on the password parameter)---->tcontextload
Is this the best way to encrypt the password ?
Thank you for your advice
Best Regards
Anonymous
Not applicable
Author

Hi Jlolling,
I also wanted to know why one should encrypt password using tcontextdump  as specified here==>  https://help.talend.com/search/all?query=Prevent+passwords+from+displaying+in+clear+text+in+the+cons... knowing the fact that it is impossible to recover the encrypted password using tcontextload  ?
Regards