Configuring SSL data encryption

OpenAccess SDK supports SSL for data encryption for data transfers between an OpenAccess SDK Client and an OpenAccess SDK Server.

1. Enable SSL encryption on the OpenAccess SDK Server. Set the ServiceSSLEnabled service attribute to True.

2. Enable SSL encryption on the OpenAccess SDK Client:

   • JDBC Client: Using a connection URL, specify a value of 1 for the encrypted connection property. For example:

     jdbc:openaccess:ssl://myhost:19986;ServerDataSource=mySDSN;encrypted=1
     

   • ODBC Client: Using the ODBC Administrator, on the Security tab, select the Encrypted (SSL) check box. Alternatively, you can use the Encrypted connection string attribute. For example:

     DSN=oaSDK810_example;SDSN= mySDSN;HST=myhost;PRT=19986;UID=myUID;PWD=myPWD;Encrypted=1
     

   • ADO Client: On the DataDirect SSIS OLE DB Provider for OpenAccess SDK setup dialog box, select the Encrypted (SSL) check box on the Security tab. Alternatively, you can use the Encrypted connection attribute in the provider string. For example:

     DSN=oaSDK810_example;Host=myhost;Port=19986;UserID=myUID;Password=myPWD;
       ServerDataSource=mySDSN;Encrypted=1
     

3. For SSL Server Authentication, add the ServiceSSLKeyStore and ServiceSSLKeyStorePasswordFile service attributes. See Example 1 and Example 2.