Configuring AOSS Options

If you have configured the connector to discover Spark services via the DataStax AOSS service, and your AOSS endpoints require different authentication and SSL settings than the Spark service that you are connecting to, then you must also configure the connector to provide the necessary AOSS credentials.

The following instructions describe how to configure advanced options in a DSN and in the connector configuration tool. You can specify the connection settings described below in a DSN, in a connection string, or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

To configure AOSS options:

  1. Choose one:
    • To access AOSS options for a DSN, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Service Discovery Options.
    • Or, to access advanced options for a DSN-less connection, open the Simba Spark ODBC Driver Configuration tool, and then click Service Discovery Options.
  2. To configure authentication, do the following:
    1. From the Status Endpoint Authentication drop-down list, select User Name and Password.
    2. In the User Name field, type the user name that you use to access the AOSS endpoints.
    3. In the Password field, type the password corresponding to the user name you typed above.
    4. To encrypt your credentials, click Password Options and then select one of the following:
      • If the credentials are used only by the current Windows user, select Current User Only.
      • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.

      To confirm your choice and close the Password Options dialog box, click OK.

  3. To configure SSL encryption and identity verification, click SSL Options and then do the following:
    1. Select the Enable SSL check box.
    2. To allow authentication using self-signed certificates that have not been added to the list of trusted certificates, select the Allow Self-signed Server Certificate check box.
    3. To allow the common name of a CA-issued SSL certificate to not match the host name of the AOSS endpoint, select the Allow Common Name Host Name Mismatch check box.
    4. To specify the CA certificates that you want to use to verify the AOSS endpoint, do one of the following:
      • To verify the endpoint using the trusted CA certificates from a specific .pem file, specify the full path to the file in the Trusted Certificates field and clear the Use System Trust Store check box.
      • Or, to use the trusted CA certificates .pem file that is installed with the connector, leave the Trusted Certificates field empty, and clear the Use System Trust Store check box.
      • Or, to use the Windows trust store, select the Use System Trust Store check box.
      • Important:

        Important:

        • If you are using the Windows trust store, make sure to import the trusted CA certificates into the trust store.
        • If the trusted CA supports certificate revocation, select the Check Certificate Revocation check box.
    5. From the Minimum TLS Version drop-down list, select the minimum version of TLS to use when connecting to the endpoint.
    6. To save your SSL settings and close the SSL Options dialog box, click OK.
  4. To save your AOSS settings and close the AOSS Options dialog box, click OK.