What are the required driver parameters for connecting to an SSL‑enabled Data Virtualization Manager (DVM) server using the DVM JDBC driver?

Answer

• EncryptionMethod - This parameter needs to be set to SSL.
• ServerCertificateStrategy - The below two values can be used:
  • This parameter needs to be set to Validate when providing a keystore that validates server certificates
  • This parameter needs to be set to Trust when providing a keystore when server requires client authentication
• KeyStore/KeyStorePassword - This parameter specifies a keystore which contains client certificate and private key and is used in cases when server requires client authentication.
• TrustStore/TrustStorePassword - This parameter specifies a keystore which contains trusted CA-certificate(s) used to validate server certificate.

Below is an example of a connection string when using server authentication:

jdbc:rs:dv://rs99.rocketsoftware.com:port;DatabaseType=DVS;user=xxx;password=xxx;
EncryptionMethod=SSL;TrustStore=C:\\SSL\\xx.jks;TrustStorePassword=xxx;ServerCertificateStrategy=Validate

Below is an example of a connection string when using client authentication:

jdbc:rs:dv://rs99.rocketsoftware.com:port;DatabaseType=DVS;user=xxx;password=xxx;
EncryptionMethod=SSL;KeyStore=C:\\xxx.jks;KeyStorePassword=xxx;ServerCertificateStrategy=Trust