[resolved] Hide credentials from a database component

[Anonymous]

I am wondering if there exists any option to hide credentials from the database component and from its source?
In the attached picture the password is not shown, however we can see it from the code view. Probably there is no option to encrypt it, right?

[Anonymous · Accepted solution]

Hi,
You can write the db connection information in a property file such as .txt, define these db parameter with context variable, and use tContextLoad component to load these value at the beginning of job.
Have a look at user component doc and learn this tContextLoad.
Best regards
Sabrina

[Anonymous]

Thank you Sabrina I will give it a try, however the password in the file is plain text too..

[Anonymous]

Hi,
What's your expected result of password part? Could you please elaborate your case with an example with the expected result, screenshot will be appreciated.
Best regards
Sabrina

[Anonymous]

My expectation is to hide the password from the component and from the source code. Password is hidden with asterisk on the component, however if you look at the code view, password is visible.

[Anonymous]

Hi,
So far, in talend, the password cannot be completely hidden. We just use context variable "password type" to show password, however, when you export job script, Default.properties still show the password.
Best regards
Sabrina

[Anonymous]

The job needs to parse the information to the (remote) system, so it needs to be unencrypted at some point.
I have used this component from the Talendforge Exchange.
http://www.powerupbi.com/talend/pwdStore.html
It actually creates an extra layer between the password and the job. Passwords are stored in the Pwstore, but the password for the Pwstore is still in the job.

[Anonymous]

You are right saukema.. Thank you both for your help..