Using User Name And Password

This authentication mechanism requires a user name and a password.

To configure User Name And Password authentication:

  1. Choose one:
    • To access authentication options for a DSN, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
    • Or, to access authentication options for a DSN-less connection, open the Simba Spark ODBC Driver Configuration tool.
  2. From the Mechanism drop-down list, select User Name And Password.
  3. In the User Name field, type an appropriate user name for accessing the Spark server.
  4. In the Password field, type the password corresponding to the user name you typed above.
  5. 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.

  6. From the Thrift Transport drop-down list, select the transport protocol to use in the Thrift layer.
  7. If the Spark server is configured to use SSL, then click SSL Options to configure SSL for the connection. For more information, see Configuring SSL Verification.
  8. To save your settings and close the dialog box, click OK.

Related topics