Page History

...

• 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 passwordsWallet®.

• 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.

...

• The wallet does not necessarily have to be created on the machine where JOC Cockpit is located. The wallet preferably consists of a number of keystore and truststore files that can be copied from a remote machine to the server that hosts JOC Cockpit.

• Typical commands to create a wallet include for example:
  
  

  Code Block
  title Example how to set up a wallet linenumbers true
  # create the wallet in an arbitrary location mkstore -wrl /home/js7/wallet -create # add credentials to the wallet; specify key, user account and password for database access mkstore -wrl /home/js7/wallet/ -createCredential js7 some_account some_password # check that the key has been added to the wallet mkstore -wrl /home/js7/wallet/ -listCredential

Anchor
jdbc jdbc

Oracle JDBC Driver

...