Configuring a DSN-less Connection

Some client applications provide support for connecting to a data source using a connector without a Data Source Name (DSN). To configure a DSN-less connection, you can use a connection string or the Simba Spark ODBC Driver Configuration tool that is installed with the Simba Apache Spark ODBC Connector. Settings in a connection string apply only when you connect to Spark using that particular string, while settings in the connector configuration tool apply to every connection that uses the Simba Apache Spark ODBC Connector.

The following section explains how to use the connector configuration tool. For information about using connection strings, see Using a Connection String.

Note:

  • Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.
  • The drop-down lists in the connector configuration tool only display one option at a time. Use the scroll arrows on the right side of the drop-down list to view and select other options.

To configure a DSN-less connection using the connector configuration tool:

  1. Choose one:
    • If you are using Windows 7 or earlier, click Start Windows Start button > All Programs > Simba Apache Spark ODBC Connector 2.8 > Driver Configuration.
    • Or, if you are using Windows 8 or later, click the arrow button at the bottom of the Start screen, and then click Simba Apache Spark ODBC Connector 2.8 > Driver Configuration.

    Note:

    Make sure to select the Driver Configuration Tool that has the same bitness as the client application that you are using to connect to Spark.

  2. If you are prompted for administrator permission to make modifications to the machine, click OK.

    3. Note:

    You must have administrator access to the machine to run this application because it makes changes to the registry.

  3. From the Spark Server Type drop-down list, select the appropriate server type for the version of Spark that you are running:
    • If you are running Shark 0.8.1 or earlier, then select SharkServer.
    • If you are running Shark 0.9, Spark 1.1 or later, then select SparkThriftServer.
  4. Specify whether the connector uses the DataStax AOSS service when connecting to Spark:
    • To connect to Spark without using the DataStax AOSS service, from the Service Discovery Mode drop-down list, select No Service Discovery.
    • Or, to discover Spark services via the DataStax AOSS service, do the following:
      1. From the Service Discovery Mode drop-down list, select AOSS.
      2. If the AOSS endpoints require different authentication and SSL settings than the Spark service that you are connecting to, click Service Discovery Options and configure the options in the AOSS Options dialog box as needed. For more information, see Configuring AOSS Options.
  5. In the Authentication area, configure authentication as needed. For more information, see Configuring Authentication.

    6. Note:

    Shark Server does not support authentication. Most default configurations of Spark Thrift Server require User Name authentication. To verify the authentication mechanism that you need to use for your connection, check the configuration of your Hadoop / Spark distribution. For more information, see Authentication Mechanisms.

  6. Optionally, if the operations against Spark are to be done on behalf of a user that is different than the authenticated user for the connection, then in the Delegation UID field, type the name of the user to be delegated.

    7. Note:

    This option is applicable only when connecting to a Spark Thrift Server instance that supports this feature.

  7. From the Thrift Transport drop-down list, select the transport protocol to use in the Thrift layer.

    8. Note:

    For information about how to determine which Thrift transport protocols your Spark server supports, see Authentication Mechanisms.

  8. If the Thrift Transport option is set to HTTP, then to configure HTTP options such as custom headers, click HTTP Options. For more information, see Configuring HTTP Options.
  9. To configure the connector to connect to Spark through a proxy server, click Proxy Options. For more information, see Configuring a Proxy Connection.
  10. To configure client-server verification over SSL, click SSL Options. For more information, see Configuring SSL Verification.

    11. Note:

    If you selected User Name or Windows Azure HDInsight Emulator as the authentication mechanism, SSL is not available.

  11. To configure advanced options, click Advanced Options. For more information, see Configuring Advanced Options.
  12. To configure server-side properties, click Advanced Options and then click Server Side Properties. For more information, see Configuring Server-Side Properties.
  13. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  14. To save your settings and close the Simba Spark ODBC Driver Configuration tool, click OK.

Related topics