Location Connection for Azure Data Lake Storage

Protocol for connecting HVR to the Azure DLS server.

• Azure Data Lake Storage Gen2 (HTTPS): HVR will connect to Azure DLS Gen2 using HTTPS.
• Azure Data Lake Storage Gen2 (HTTP): HVR will connect to Azure DLS Gen2 using HTTP.
• Azure Data Lake Storage Gen1default: HVR will connect to Azure DLS Gen1.

Hostname or IP-address of the server on which the Azure DLS is running.

Name of the Azure DLS Gen2 storage account.

Name of the container available within the Azure DLS Gen2 storage ACCOUNT .

For Azure DLS Gen1, this is the directory path where the files are replicated to or captured from.

Authentication method for connecting HVR to Azure Data Lake Storage (ADLS) Gen2 server.

Available options for ADLS Gen2 are:

• Shared Key
• Service-to-service
• User Name and Password
• MSI
• Refresh token
  

When PROTOCOL is set to Azure Data Lake Storage Gen2 (HTTP), only Shared Key is available as the authentication method.

Available options for ADLS Gen1 are:

• Service-to-service
• MSI
• Refresh token

Access key of the Azure storage account.

URL used for obtaining the bearer token with credential token.

Username for the OAuth 2.0 authentication.

Client ID used to obtain Microsoft Entra ID (formerly Azure Active Directory) access token.

Secret key of the CLIENT ID.

Directory path to the text file containing the refresh token.

URL for the REST endpoint of the token service exposed to localhost by the identity extension in the Azure VM.

Port number for the REST endpoint of the token service exposed to localhost by the identity extension in the Azure VM. The default value for this field is 50342.

Type of the Hive server.

Available options are:

• Hive Server 1: HVR will connect to Hive Server 1 instance.
• Hive Server 2default: HVR will connect to Hive Server 2 instance.

Mode for connecting HVR to Hive Server 2.

This field is enabled only if HIVE SERVER TYPE is set to 2.

Available options are:

• Nonedefault: HVR connects to Hive Server 2 without using the ZooKeeper service.
• ZooKeeper: HVR discovers Hive Server 2 services using the ZooKeeper service.

Namespace on ZooKeeper under which Hive Server 2 nodes are added.

Authentication method for connecting HVR to Hive Server 2.

This field is enabled only if HIVE SERVER TYPE is set to 2.

Available options are:

• No Authenticationdefault
• User Name
• User Name and Password
• Kerberos
  
• Windows Azure HDInsight Service

Username for connecting HVR to the database (defined in Database_Name).

Kerberos service principal name of the Hive server. This is the service name part of Kerberos principal of the Hive server. For example, if the principal is hive/example.host@EXAMPLE.REALM then "hive" should be specified here.

Fully Qualified Domain Name (FQDN) of the Hive server host. This is the host part of Kerberos principal of the Hive server. For example, if the principal is "hive/example.host@EXAMPLE.REALM" then "example.host" should be specified here.

The value for this field may be set to _HOST to use the Hive server hostname as the domain name for Kerberos authentication.

If SERVICE DISCOVERY MODE is set to None, then the driver uses the value specified in the Host connection attribute.
If SERVICE DISCOVERY MODE is set to ZooKeeper, then the driver uses the Hive Server 2 host name returned by the ZooKeeper.

Realm of the Hive Server 2 host.

It is not required to specify any value in this field if the realm of the Hive Server 2 host is defined as the default realm in Kerberos configuration.

THRIFT TRANSPORT

Transport protocol to use in the Thrift layer.

This field is enabled only if HIVE SERVER TYPE is set to Hive Server 2.

Available options are:

• BINARY (This option can be used only if AUTHENTICATION METHOD is set to No Authentication or User Name and Password.)
• SASL (This option can be used only if AUTHENTICATION METHOD is set to User Name or User Name and Password or Kerberos.)
• HTTP (This option can be used only if AUTHENTICATION METHOD is set to No Authentication or User Name and Password or Kerberos or Windows Azure HDInsight Service.)

For information about determining which Thrift transport protocols your Hive server supports, refer to HiveServer2 Overview and Setting Up HiveServer2 sections in Hive documentation.

The partial URL corresponding to the Hive server.

Directory path where the .pem file containing the server's public SSL certificate signed by a trusted CA is located.

Defining this property will enable (one way) SSL, which means, HVR will authenticate the Hive server by validating the SSL certificate shared by the Hive server.

Directory path where the .pem file containing the client's SSL public certificate is located.

Directory path where the .pem file containing the client's SSL private key is located.

Password of the client's SSL private key specified in CLIENT PRIVATE KEY.

Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system.

Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system.