Configuring Authentication

Some Impala servers are configured to require authentication for access. To connect to an Impala server, you must configure the Simba Impala ODBC Driver to use the authentication mechanism that matches the access requirements of the server and provides the necessary credentials.

For information about how to determine the type of authentication your Impala server requires, see Authentication Options.

You can specify authentication settings in a DSN, in a connection string, or as connector-wide settings. Settings in the connection string take precedence over settings in the DSN, and settings in the DSN take precedence over connector-wide settings.

The following authentication methods are available:

If cookie-based authentication is enabled in your Impala database, you can specify a list of authentication cookies in the HTTPAuthCookies connection property. In this case, the connector authenticates the connection once based on the provided authentication credentials. It then uses the cookie generated by the server for each subsequent request in the same connection. For more information, see HTTPAuthCookies.

Note:

On Windows, the HTTPAuthCookies property must be set in a connection string.