...

• JS7 offers two levels of integration with an Oracle DBMS:
  • JS7 supports use of Oracle as the JS7 - Database.
  • JS7 offers job templates from JS7 - JITL Database Jobs that can be used to access Oracle databases, for this scenario see JS7 - How to make JITL Jobs connect to an Oracle database without using passwords.

• For both scenarios users might prefer not to provide a user account and password for authentication with the DBMS from readable files..

  • Use of passwords is considered insecure when passwords are stored in clear text in external files or in job parameters.
  • JS7 offers JS7 - Use of Credential Store with JITL Jobs as an alternative way to store and to retrieve passwords.
  • The Oracle Wallet® provides a means to connect to an Oracle database without specifying a user account and password from parameters or from readable files.

Oracle Wallet®

The Oracle Wallet® configuration is explained with the Oracle documentation:

...