audit database - support for SSL

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On Agents (SiteMinder)
• CA Single Sign On Federation (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• SITEMINDER

Issue/Introduction

We're running a Policy Server and we'd like to know if we can configure ODBC
connection in SSL with Audit Store on Oracle 12c ?

Environment

Policy Server 12.8SP2

Resolution

Yes you can.

As our Policy Server uses the DataDirect (from Progress) driver, the
configuration should follow their documentation.

As such, here's the link for that documentation.

  SSL Encryption
  https://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/odbc%2Fssl-encryption.html%23

The parameter to set SSLin system_odbc.ini can be found in that
section :

  SSL Encryption

    Summary of Data Encryption Related Options
    
  https://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/odbc%2Fssl-encryption.html%23

Further reading :

  README
  http://media.datadirect.com/download/docs/odbc64/readme/unixread.htm

  HOW DO THE DATADIRECT CONNECT FOR ODBC DRIVER USES THE SSL LIBRARY
  https://knowledgebase.progress.com/articles/Article/How-Do-the-DataDirect-Connect-for-ODBC-Driver-uses-the-SSL-library