Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Password option for Environmental variables

Hi

We have a large number of tables to connect to and are using environmental variables as much as possible to reduce the amount of work needed for config changes, however for the password to a database if we use an environmental variable the value is in plain text.

Would it be possible to add a new type to the environmental variables that doesn't show the
value ie password field type?

Thanks
Hamish

8 Community Answers

Matillion Agent  

Ed Thompson —

Hi Hamish,

We hope to introduce a password manager which will allow you to manage passwords across a project, and then reference the password by name in the components. At that point, using a variable for the password’s name will be fine, and its value will be retrieved when the job runs.

Because of this plan, it is unlikely we will introduce a password-style variable type.

I’ll post again once we know when it will be available.

Regards


David Murphy —

Hi Ed

Has there been any update on this functionality of using environmental variables from the Password Store?

Regards,
David


Matillion Agent  

Ian Funnell —

Hi David,

Matillion now does have the Password Manager which Ed was referring to last year.

If you’re not taking advantage of this functionality already, it could be what you are looking for?

Best regards,
Ian


Johan Forssell —

Is it possible to acces the passwords and usernames from batch- and pythonscripts?


Johan Forssell —

.. and i mean bash not batch


Matillion Agent  

Ian Funnell —

Hi Johan,

Currently this isn’t possible unfortunately, although we do have a change request (internal reference EMD-3076) to add this functionality.

Many thanks for the suggestion.

Best regards,
Ian


Johan Forssell —

To bad its not possible but its good news to hear that you are working on it. So my only way going forward is to enter my credentials in plain text either in the script or save them as a variable?


Matillion Agent  

Ian Funnell —

Hi Johan,

For Bash and Python scripts that’s the case, yes: you will need to embed them in the script, either as a string literal or using a Matillion Environment Variable. It’s better to use an environment variable because then it can automatically have different values in dev/test/production etc.

I’ll update this thread once additional options have become available.

Best regards,
Ian

Post Your Community Answer

To add an answer please login