Configuring Authentication

Some Hive Server 2 instances are configured to require authentication for access. To connect to a Hive server, you must configure the Simba Apache Hive ODBC Connector 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 Hive server requires, see Authentication Mechanisms.

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:

• Using No Authentication
• Using Kerberos
• Using SAML 2.0
• Using User Name
• Using User Name And Password
• Using Windows Azure HDInsight Service
• Delegating Authentication to a Specific User

If cookie-based authentication is enabled in your Hive Server 2 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.

Related topics

• Authentication Driver Configuration Options on page 1
• Creating a Data Source Name
• Configuring a DSN-less Connection