topic Re: Encrypt DataBase Connectivity Passwords in Talend in Talend Studio

Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Fri, 03 Apr 2015 01:58:46 GMT

Hi,
I am very new to Talend. I want to hide the Password characters assigned to different context variables in tjava component. The tmssqlconnection component uses these context variables to connect to the SQL database. I tried with the PAsswordStore procedure from the following link with no success.
Please help.
Thanks in advance.
Brad.

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Fri, 03 Apr 2015 04:37:21 GMT

Hi,
Could you please take a look at document about TalendHelpCenter:How to setup encryption of the passwords in Talend Studio? to see if it is what you are looking for?
Best regards
Sabrina

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Fri, 03 Apr 2015 09:24:36 GMT

Yes Sabrina,
that is what I am trying to do. However, is there a way that we encrypt and decrypt the password in Talend using AES algorithm. I understood the decryption part in Talend. However, I still wonder how I encrypt the password in Talend. Please help.
Regards,
Brad

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Fri, 03 Apr 2015 11:12:02 GMT

Hi,
Can you use encryption routine in job? Or You are looking for something embedded into Talend?
Best regards
Sabrina

Re: Encrypt DataBase Connectivity Passwords in Talend

_AnonymousUser — Fri, 03 Apr 2015 14:40:18 GMT

If it is used in the job.....will it bring down the level of security? I am not sure. Please suggest whichever is more secure.
Regards,
Brad

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Fri, 03 Apr 2015 17:08:59 GMT

Hi,
In an automated environment, I need to pass the KEY for decrypting the password into the Talend job. So the Talend job has both the decryption code and the KEY for decrypting. So that is not secured enough. Is there a way we don't have to pass a KEY for decryption and at the same time no password is displayed in plain text in the talend job.
Or, may be we can encrypt the whole talend job i.e, the .jar file and before execution the job picks up it's decryption KEY from a specified location on the fly. All this needs to happen in an automated environment. No human intervention should be required. Will that be possible?
This is very important as most corporates will have to run Talend jobs in an automated environment with the the best possible security features. That will make Talend super powerful. Please suggest if there is any way to incorporate these features.
Thanks once again for your constant support.
Regards,
Brad

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Tue, 07 Apr 2015 14:35:40 GMT

Hi,
Any idea how we can make the Talend jobs more secure? Please advice.
Regards,
Brad

Re: Encrypt DataBase Connectivity Passwords in Talend

Anonymous — Tue, 07 Apr 2015 19:35:43 GMT

Put all your context variables in a .properties file and have the job load the values using a tContextLoad. Then use PGP to encyrpt the context file and have the job use the PGP component to decrypt at runtime before the context load occurs.