skip to main content
Configuring Security for OpenAccess SDK : Configuring OpenAccess SDK security : Configuring SSL : Configuring SSL data encryption
 
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;User ID= myUID ;Password= myPWD ;Server Data Source = mySDSN ;Encrypted=1
3. For SSL Server Authentication, add the ServiceSSLKeyStore and ServiceSSLKeyStorePasswordFile service attributes. See Example 1 and Example 2.
In this section: 
* Example 1: SSL-enabled service using a DSA private key and defaultcipher suites
* Example 2: SSL-enabled service using a RSA private key and aspecific cipher suite
* Example 3: SSL-enabled service using an EC private key and defaultcipher suites