SOS PLSQL Database Job should support use of a Credential Store

Current Situation

• The JITL Job JobSchedulerPLSQLJobJSAdapterClass provides parameters for database access: db_user, db_password, db_url.
• Values for these parameters are specified as plain text.

Desired Behavior

It should be possible to read the values for user, password url and any other parameters from a keepass credential store.

There are the following parameters needed to specify the key store.

• The file name of the keystore: Mandatory
• The file name of the keyfile: Optional if missing the filename like credential_store_file but with .key as extension will be used
• The password for the key store: Optional. Only needed when the keyfile has a password.
• The path for in the keystore: Optional to make the cs:// value shorter.

There are two sources for the parameters. When both are given, the values from the query parameters overrides the explicit parameters

1. as query parameters in the value e.g. cs://....?file=value%password=value
2. as explicit parameters in the job or order

• • credential_store_file: The name of the keepass credential store file
  • credential_store_key_file: The name of the keepass credential store file.
  • credential_store_password: The password for the keepass credential store file or empty
  • credential_store_entry_path: The default path for the entries

• Exampel for a job that make use of query parameters
  • db_user = cs://some/path/entry@user?credential_store_file=credentials.kdbx
  • db_password = cs://some/path/entry@password?credential_store_file=credentials.kdbx
  • db_url = cs://some/path/entry@url?credential_store_file=credentials.kdbx

• The job will support use of files with SQL scripts.