Configuring SSL Verification

When connecting to data stores, by default the Windows version of the Simba Salesforce Marketing Cloud ODBC Driver uses one-way SSL authentication with peer and host verification. The connector verifies the identity of the server, and the host name specified in the server certificate must match the host name of the server that you are connecting to. To successfully connect to the server, you must either provide the appropriate trusted server certificate or disable peer verification.

Specifying a Server Certificate

The connector uses the certificates in the Windows trust store to verify the server. To add a certificate to the trust store, use the Microsoft Management Console (MMC). For more information, see "Manage Trusted Root Certificates" on Microsoft TechNet: https://technet.microsoft.com/en-us/library/cc754841(v=ws.11).aspx.

Note:

  • If the SystemTrustStore property is enabled (1), the Windows trust store is used.
  • If the SystemTrustStore property is disabled (0), the certificate is taken from the path provided in the TrustCertsPath property.

Disabling SSL Verification

If SSL verification is not required for your connection, you can disable it so that the connector can connect to the data store.

Note:

It is recommended that you keep SSL enabled if possible. SSL encryption protects data and credentials when they are transferred over the network, and provides stronger security than authentication alone.

To disable SSL verification:

  1. To access SSL options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. Clear the Use HTTPS check box.
  3. To save your settings and close the DSN Setup dialog box, click OK.