...
You can then use the #EVAL function from Odysseus Script to store the value to a local property. Important: You will need call the above code in a single query and not together with the following retrieval statement!
| Code Block |
|---|
#EVAL PASSWORD = kvRead('PasswordStore','dbpass13'); |
...
| Code Block |
|---|
DATABASESOURCE({ table='XXX', jdbc='XXX', user='XXX', password='${PASSWORD}', |
If you use the memory based data dictionary (default), the file store needs to be registered again after an Odysseus restart. The password(s) will be loaded from the store. You could also add this to Autostart.
| Code Block |
|---|
#CREATE_KV_STORE PasswordStore FileStore (filename=c:/temp/password.store) |
Of course you could use the same to store other configuration stuff, that should not be part of the query text.
Remark: This is far away from being secure, but it is better than using the password directly
...