Configuring DataStax AOSS Service Discovery on a Non-Windows Machine

You can configure the Simba Apache Spark ODBC Connector to discover Spark services through DataStax AOSS. If 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 and settings.

You can set the connection properties described below in a connection string, in a DSN (in the odbc.ini file), or as a connector-wide setting (in the simba.sparkodbc.ini file). 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 DataStax AOSS service discovery on a non-Windows machine:

  1. Set the ServiceDiscoveryMode property to AOSS.
  2. Set the Host property to a comma-separated list of AOSS endpoints. Use the following format, where [AOSS_Endpoint] is the IP address or host name of the AOSS endpoint, and [AOSS_Port] is the number of the TCP port that the AOSS endpoint uses to listen for client connections:

    3. [AOSS_Endpoint1]:[AOSS_Port1],[AOSS_Endpoint2]:[AOSS_Port2]

  3. If the AOSS endpoints require different authentication settings than the Spark service that you are connecting to, then you must also configure the connector to provide the necessary AOSS credentials:
    1. Set the AOSS_AuthMech property to 3.
    2. Set the AOSS_UID property to the user name that you use to access the AOSS endpoints.
    3. Set the AOSS_PWD property to the password corresponding to the user name you specified above.
  4. If the AOSS endpoints require different SSL settings than the Spark service that you are connecting to, then you must also configure the connector to use the appropriate SSL settings:
    1. Set the AOSS_SSL property to 1.
    2. To allow authentication using self-signed certificates that have not been added to the list of trusted certificates, set the AOSS_AllowSelfSignedServerCert property to 1.
    3. To allow the common name of a CA-issued SSL certificate to not match the host name of the AOSS endpoint, set the AOSS_AllowHostNameCNMismatch property to 1.
    4. To specify the CA certificates that you want to use to verify the server, do one of the following:
      • To configure the connector to load SSL certificates from a specific .pem file when verifying the server, set the AOSS_TrustedCerts property to the full path of the .pem file.
      • Or, to use the trusted CA certificates .pem file that is installed with the connector, do not specify a value for the AOSS_TrustedCerts property.
    5. To specify the minimum version of TLS to use, set the AOSS_Min_TLS property to the minimum version of TLS. Supported options include 1.0 for TLS 1.0, 1.1 for TLS 1.1, and 1.2 for TLS 1.2.