After setting the CLASSPATH, the connection information needs to be passed in the form of a connection URL. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

Note:
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.
jdbc:datadirect:impala://servername:port;DatabaseName=database_name;
[property=value[;...]];

No authentication

This string includes the properties used to connect without an authentication method.

jdbc:datadirect:impala://servername:port;DatabaseName=database_name;
AuthenticationMethod=none;[property=value[;...]];

For more information on these properties and values, see No authentication.

User ID/password authentication

This string includes the properties used to connect with the user ID/password authentication via LDAP.

jdbc:datadirect:impala://servername:port;DatabaseName=database_name;
User=user_name;Password=password;[property=value[;...]];
Note: The user credentials are configured in the LDAP server.

For more information on these properties and values, see User ID/password authentication.

Kerberos authentication

This string includes the properties used to connect with Kerberos authentication.

jdbc:datadirect:impala://servername:port;DatabaseName=database_name;
AuthenticationMethod=kerberos;ServicePrincipleName=serviceprincipalname;
[property=value[;...]];

For more information on these properties and values, see Kerberos authentication.

Proxy server authentication

This string includes the properties you may need to connect through a proxy server with the user ID/password authentication via LDAP.

jdbc:datadirect:impala://servername:port;DatabaseName=database_name;
ProxyHost=proxy_host;ProxyPassword=proxy_password;
ProxyPort=proxy_port;ProxyUser=proxy_user;
User=user_name;Password=password;
[property=value[;...]];