Configure the ImageNow ODBC Datasource - Configure the ImageNow ODBC Datasource - Perceptive Content - SSL Security with an Oracle Database - Perceptive-Content/SSL-Security-with-an-Oracle-Database/Foundation-24.1/SSL-Security-with-an-Oracle-Database/Set-Up-SSL-Encryption/Configure-the-ImageNow-ODBC-Datasource - Foundation 24.1

To configure the ImageNow ODBC Datasource, complete the following steps appropriate to your situation.

To configure ImageNow ODBC Datasource using ODBC Data Source Administrator (Windows), complete the following steps.
1. Place the client server wallet in your key store directory for ImageNow Server. Create a key store directory on your client server if one does not exist.EXAMPLE: C:\inserver6\bin64\dbconnector\keystore\ewallet.p12
2. On the General tab of the ODBC System DSN for ImageNow (ImageNow 6 Oracle Wire Protocol Driver), edit the following settings:
  - Host: Hostname or IP address of the Oracle DB Server
  - Port Number: The SSL Port number that was configured on the database server. The default is 2484.
  - SID: Oracle Service Name
3. On the Security tab, edit the following settings:
  - Authentication Method: 1 – Encrypt Password
  - Encryption Method: 3-SSL3
  - Select Validate Server Certificate.
  - Trust Store: C:\inserver6\bin64\dbconnector\keystore\ewallet.p12
  - Trust Store Password: (password to access the wallet)
  - Key Store: C:\inserver6\bin64\dbconnector\keystore\ewallet.p12
  - Key Store Password: (password to access the wallet in the Key Store directory)
  - Host Name In Certificate: The Common Name entered when creating the database server user certificate.
  Note: The server name must match the CN of the database server user certificate.
4. Click Test Connect. In the Logon to Oracle Wire Protocol dialog, enter your User Name and Password and click OK. Connection Established! is displayed in the Test Connect dialog box.
To configure ImageNow ODBC Datasource using Command line (UNIX), complete the following steps.
1. Place the client server wallet in your key store directory for the ImageNow Server. Create a key store directory on your client server if one does not exist. EXAMPLE: /opt/inserver/odbc/keystore/ewallet.p12
2. Open the /opt/inserver/etc/odbc.ini file and add the following security parameters to the Oracle Wire Protocol section.
  - loginTimeout: 15
  - authenticationmethod: 1
  - encryptionmethod: 3
  - keystore: /opt/inserver/odbc/keystore/ewallet.p12
  - keystorepassword: <password>
  - truststore: /opt/inserver/odbc/keystore/ewallet.p12
  - truststorepassword: <password>
  - ValidateServerCertificate: 1
  - HostNameInCertificate: The Common Name entered when creating the database server user certificate.
  Note: The server name must match the CN of the database server certificate
3. Run the following INTool command to test the connection. intool --cmd get-db-version