# Configuring a DataBase Connection to Hive

## About this task

This example uses version 3.6 of Azure HDInsight.

## Procedure

1. In the Repository view, extend the Metadata drop-down menu.
2. Click Db Connections, and then right-click Create Connection .
3. Give a name to your connection.

   ![](https://help.qlik.com/talend/en-US/components/7.3/Resources/images/create_hive_connection.JPG.png)
4. Click Next.
5. Set up the connection configuration similarly to the following table:

   ![](https://help.qlik.com/talend/en-US/components/7.3/Resources/images/create_hive_connection_2.JPG.png)
   | DB Type | Select Hive. |
   | --- | --- |
   | Hadoop Cluster | Select None. |
   | Distribution | Select Horton Works.<br><br>HDInsight is leveraging Horton Works distribution on the backend. This<br>will allow you to use Horton Works libraries to connect to<br>HDInsighs. |
   | DB Type | Select Hive. |
   | Version | Select Hortonworks Data Platform V2.6.0.3-8<br>[Built in]. |
   | Hive Model | Select Standalone. |
   | Login<br><br><br>Password<br><br><br>Server | Fill in the fields as required. |
   | Port | Input 443.<br><br>You will be able to communicate through the proxy port since the<br>HDInsight cluster sits behind a proxy by default. |
   | DataBase | Leave default. |
   | Additional JDBC Setting | Input transportMode=http;ssl=true;httpPath=/hive2, where:<br><br><ul> <li> <kbd>transportMode=http</kbd> sets the transport mode to HTTP instead of the default Hive JDBC transport mode.</li> <li> <kbd>SSL=true</kbd> enables SSL.</li> <li> <kbd>httpPath=/hive2</kbd> sets the HTTP endpoint.</li> </ul> |
6. Click Test Connection to ensure the Talend Studio connects successfully to the cluster.