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 Databricks ODBC Connector 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 Databricks server.
4. In the Password field, type the password corresponding to the user name you typed above.
5. To encrypt your credentials, 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.
6. From the Thrift Transport drop-down list, select the transport protocol to use in the Thrift layer.
7. If the Databricks server is configured to use SSL, then click SSL Options to configure SSL for the connection. For more information, see Configuring SSL Verification in Windows.
8. To save your settings and close the dialog box, click OK.