OpenLink Universal Data Access (UDA) Wiki
Documentation and guidance on installing, configuring and trouble-shooting UDA
Advanced Search
Help?
Location: / Dashboard / UdaWikiWeb / UdaWikiWebIndex / ConfigureUDAFeatures / ConfigureSQLSSL

Configure SSL Data Encryption

Use the following steps to configure SSL Data Encryption.

Single-Tier (Express) Drivers


1. Log in to the machine that hosts OpenLink's Single-Tier (Express) Drivers.

2. Launch your ODBC or iODBC Data Sources Administrator.

3. Locate your OpenLink DSN.

4. Click the Configure button.

5. Scroll through the configuration screens until you find the Advanced button.

6. Click the Advanced button.

7. Locate the SSL parameter.

8. Set the SSL parameter to ON.

Single-Tier (Lite) Drivers - Mac & Windows

1. Log in to the machine that hosts OpenLink's Single-Tier (Lite Drivers).

2. Launch your ODBC or iODBC Data Sources Administrator.

3. Locate your OpenLink DSN.

4. Click the Configure button.

5. Scroll through the configuration screens until you find the "Use strong encryption of data" checkbox.

6. Check the encryption checkbox.

7. Check the "Verify Server Certificate" to verify Database Server SSL certificates against a local certificate.

8. Pass the name of the local certificate that will be used for verification purposes.

Single-Tier (Lite) Drivers - Unix


1. Login to the machine that hosts OpenLink's Single-Tier client drivers.

2. Use the Web-based iODBC Data Sources Administrator to access your DSN.

3. Locate the Connection Options field of your DSN.

4. Pass the following flags and applicable attributes in the Connection Options field:

  • -E - Turn On SSL Strong Data Encryption
  • -R - Turn On SSL Server Certificate Verification
  • -D </path/to/file> - Specify Name of Certificate Authority file to be used for SSL Certificate Verification

Multi-Tier Drivers

1. Login to the machine that hosts OpenLink's Multi-Tier client drivers.

2. Use the relevant Data Sources Administrator or Web-Based Admin Assistant to access your DSN.

3. Locate the Connection Options field of your DSN.

4. Pass the following flags and applicable attributes in the Connection Options field:

  • -E - Turn On SSL Strong Data Encryption
  • -R - Turn On SSL Server Certificate Verification
  • -D </path/to/file> - Specify Name of Certificate Authority file to be used for SSL Certificate Verification
Powered By Virtuoso