---
title: Define DataHub Connections
slug: solutions/define-datahub-connections
docTags: 
createdAt: 2025-03-12T18:04:33.532Z
---

To establish your first database connection in Litmus Excel Add-ins, you must configure the DataHub connection, check the firewall settings, and confirm successful communication with your database.

# Before You Begin

- You know the IPv4 address of your Litmus Edge device or of your external Database server. 
- Your firewall allows connections through port 8086, and the database supports InfluxDB v1 with read privileges for the database.
- You have installed the Litmus Excel Add-ins extension. See [Install Litmus Excel Add-ins](docId\:GZDhBJ1xZZNDDThYOCuuu) for details.

# Step 1: Navigate to DataHub Connections

1. Open a new Excel file with *Litmus Excel Add-ins *enabled. See [Step 4: Verify Litmus Excel Add-in Activation in Excel](docId\:GZDhBJ1xZZNDDThYOCuuu) to learn more.
2. Click on **Manage DataHub Connections**.

   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/qDGAsHkvh0BExWlNteuPC_image.png" size="82" width="921" height="372" position="center" showCaption="false"}
3. The *Litmus DataHub Connections* window pops up. You can take the following actions from this page:
   - **Add a New Connection: **See *Step 2 (Next Step)* below for detailed steps.
   - **Learn more: **This *Add-in* only supports connections using *InfluxDB v1*. You can access the **InfluxDB Documentation **through this link.
     - **Note: **Skip verification when the *Advanced Threat Protection* dialog box appears. 

       ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/Bd-N7zyEX9JRc0_lvslIc_image.png" size="60" width="690" height="804" position="center" showCaption="false"}

:::hint{type="warning"}
**Important: **When trying to define a query, if no connections are defined, a message will appear indicating that no data sources are available.

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/nXXYmzKyxK7eFgC4U5frX_image.png" size="60" width="1010" height="901" position="center" showCaption="false"}
:::

# Step 2: Add a New Connection

1. Click on **Add** to create a new DataHub connection.

   ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/BkWDCTrc4SeQWeCDwJlpe_image.png" size="60" width="689" height="495" position="center" showCaption="false"}
2. Enter the following details:
   - **Litmus DataHub Server IPv4**: Enter the following: 
     - The API for *InfluxDB v1 *only supports **IPv4** addresses. 
     - To access our internal *tsdata *database, use the **IPv4** address of your edge device.
     - For this guide, we use our internal **tsdata** database.
   - **Litmus DataHub Port**: Default is **8086 **(change if using an external database). See [Manage the Timeseries DB](docId\:VvS21ANbm2cYyVwabQXMr) for details.
   - **Litmus DataHub Database**: Default is **tsdata** (change if using an external database). See [Manage the Timeseries DB](docId\:VvS21ANbm2cYyVwabQXMr) for details.
   - **Litmus DataHub User**: Enter the user's name credentials for *tsdata *database. See [Add Database Users](docId\:cdJFDtIvCBs29pILayzVC) for more details.
   - **Litmus DataHub Password:** Enter the user's password credentials for *tsdata *database. See [Add Database Users](docId\:cdJFDtIvCBs29pILayzVC)  for more details.
   - **Timeout in Seconds**: The time the connection will wait before reporting an error.
   - **Connection Name**: A unique name to identify your connection.
   - If everything is configured correctly, you will see the message "*Litmus DataHub & DB reachable*" in green at the bottom. 
     - Click **Save** to store the connection.

       ::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/48AmLTsgvMxHizKbeCQjS_image.png" size="60" width="698" height="802" position="center" showCaption="false"}
3. The connection will now appear in the *Litmus DataHub Connections* list.

::Image[]{src="https://app.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/xs0djE0MyUQaQtW4Ik2cQ-20251103-094959.png" size="80" width="904" height="547" position="center" showCaption="false"}

Your first database connection is now set up and ready for use in Litmus DataHub.

:::hint{type="danger"}
### Configure Firewall Settings

Ensure that the specified port is open and not blocked by firewall rules to prevent connection issues.

If using **Litmus Edge v3.16.5 or later**, you must configure firewall rules to allow traffic on **port 8086**.

- Navigate to **System **> **Network > Firewall** and add a new rule for **port 8086**. See [Manage Firewall Rules](docId\:ytXEklA80ol5BkSdRkG0A) for details.
- If using an external database, configure the respective firewall settings. See [InfluxDB ports](https://docs.influxdata.com/influxdb/v1/administration/ports/) for more details.
:::

# Troubleshooting

The system will attempt to establish a connection with the database. If successful, you will see a confirmation message. If the connection fails, it is best to:

- Verify the IPv4 address, confirm login credentials, or ensure the database is accessible. 
  - See [Configure the Timeseries DB](docId\:HqkH8iNwjerydFcwBQPwt) for details.
- Check firewall rules. 
  - See [Manage Firewall Rules](docId\:ytXEklA80ol5BkSdRkG0A) for details.