Set Kettle DB Connection password from Environment Variable

Question

How do I set a database connection's password to use an environment variable. I cannot add these to the kettle.properties file (security policy). When I click control-space on OSX, nothing happens. If I try and paste the string ${PASSWORD} directly into the password field, it does not allow it, due to the presumably non-alphanumeric '$' char.

The other fields as shown below work fine.

The EDIT Connection dialog below shows the field in red, which is what I want to achieve logically.

Using PDI Community 8.2, on Mac OSX Mojave.

score 2 · Answer 1 · answered Mar 27 '19 at 03:28

I found one solution. Instead of creating the DB connection in Table Input Step with Edit or New, I used the Wizard option, which allowed me to paste ${SOURCE_DB_PASSWORD} variable into the password field.

The characters were obfuscated, so it's impossible to tell if you have the correct value, but it worked.

score 1 · Answer 2 · answered Mar 27 '19 at 08:18

1

CTRL+V doesn’t work, you need to right-click and choose paste.

answered Mar 27 '19 at 08:18

nsousa

4,448
1
10
15

score 0 · Answer 3 · answered Mar 27 '19 at 17:58

0

You can encrypt the password and save it on kettle.properties, in spoon directory execute:

Encr.bat -kettle yourpassword

Paste the full result with "Encrypted" in the properties file, restart spoon and test the connection.

answered Mar 27 '19 at 17:58

Kauann H. de Oliveira

81
8

As per my original post, I cannot use the kettle.properties file for passwords. – NullPumpkinException Mar 27 '19 at 21:01
even encrypted password? – Kauann H. de Oliveira Apr 01 '19 at 16:39
Yes, All passwords are stored in a single Vault server and injected into each artefact (API, service, ETL job, etc) as required via ENV variables to EC2 instances, lambdas, etc in secured Kubernetes cluster. – NullPumpkinException Apr 02 '19 at 00:06

score 0 · Answer 4 · answered Apr 03 '19 at 08:22

0

In OSX, I believe you need to use the shortcut shift + cmd + space to access the environment variables.

You might need to use the 'get variables'-step to define the variables from kettle.properties.

answered Apr 03 '19 at 08:22

Reitenator

1,075
13
13

score 0 · Answer 5 · answered Aug 23 '21 at 17:25

0

Just type ${Variable_Name} as you are defining for other environment variable. If open your .ktr file in Notepad++ you can see the value is your Variable_Name instead of Encrypted password. It worked for me :)

enter image description here

answered Aug 23 '21 at 17:25

Mukesh Katkam

1

Set Kettle DB Connection password from Environment Variable

5 Answers5