Using User Name And Password

This authentication mechanism requires a user name and a password.

To configure User Name And Password authentication:

1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
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 Impala 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. If the Impala server is configured to use SSL, then click SSL Options to configure SSL for the connection. For more information, see Configuring SSL Verification.
7. Optionally, in the Transport Buffer Size field, type the number of bytes to reserve in memory for buffering unencrypted data from the network.

Note:

In most circumstances, the default value of 1000 bytes is optimal.

8. Optionally, to use SASL to handle authentication, select the Use Simple Authentication and Security Layer (SASL) check box.

Note:

If the Transport Mode property is specified, it takes precedence over this property.

9. To save your settings and close the dialog box, click OK.

Related topics

• Configuring Authentication
• Authentication Options
• Using No Authentication
• Using Kerberos
• Using Advanced Kerberos
• Using SASL User Name
• Creating a Data Source Name
• Authentication Driver Configuration Options on page 1