topic [resolved] DB connection with encrypted context variables in Talend Studio

[resolved] DB connection with encrypted context variables

Fernandez — Mon, 29 Dec 2014 10:10:14 GMT

Hi,
I created a connexion to a MSSql DB in the repository from context variables.
The user and psw are encrypted so I want to use a routine for uncrypting.
I dont't know where to call this routine because the fields are disabled in the connection windows and in the tMSSqlRow component:

Has somebody any idea ?

Re: [resolved] DB connection with encrypted context variables

Anonymous — Tue, 30 Dec 2014 10:20:04 GMT

In the context variable the password is not encrypted. The encryption takes place if you set the password in the job directly.

Re: [resolved] DB connection with encrypted context variables

Anonymous — Tue, 30 Dec 2014 15:24:46 GMT

Hi,

What's the build version you are using?
Have you already checked KB article about: TalendHelpCenter:How to setup encryption of the passwords in Talend Studio?
Best regards
Sabrina

Re: [resolved] DB connection with encrypted context variables

Anonymous — Wed, 31 Dec 2014 10:25:04 GMT

Hi afernandez35,

Any update for your issue?

Best regards
Sabrina

Re: [resolved] DB connection with encrypted context variables

Fernandez — Wed, 07 Jan 2015 16:26:05 GMT

Hi,
No solution for the moment...
If I retrieve the encrypted user / password in the context files, how to uncrypting these if I create my SQL connection in the repository ?
In the suggested article, the Property Type is "Built-In" and I want to use "Repository" as Property Type...
Regards,
Antoine

Re: [resolved] DB connection with encrypted context variables

Anonymous — Thu, 08 Jan 2015 19:15:31 GMT

if you just use context file to store your user/password, you can just use context.db_password in your routine.
If you just want to change user and password for this connection, you can either go back to context to change it or change property type from "Repository" to "Build in".

Re: [resolved] DB connection with encrypted context variables

Fernandez — Fri, 09 Jan 2015 15:30:57 GMT

It's OK when using property type "Build In"