---
title: Access Tabix UI with Belden Horizon Data Manager
slug: bhdm/access-tabix-ui-with-belden-horizon-data-manager
createdAt: 2023-03-09T18:13:50.000Z
---

Tabix can be used to retrieve and display PLC data from a Belden Horizon Data Manager. You can then execute SQL queries onto the PLC data. 

# Before You Begin

- Ensure that the Clickhouse port 8543 \[`HTTPS`] is enabled. See the *Change port status state* option in    [Clickhouse](docId\:MD6NfAz8rrs1p_JWPaIm-).
- Create a Clickhouse User. See the *Create User* option in [Clickhouse](docId\:MD6NfAz8rrs1p_JWPaIm-).
- Associate the created Tabix User with a Topic (Company / Project). See the *Add ACL* option in  [Clickhouse](docId\:MD6NfAz8rrs1p_JWPaIm-).

# Log into Tabix

To initially enter Tabix UI from the Belden Horizon Data Manager Admin Console, see the *Open Tabix* option in [Clickhouse](docId\:MD6NfAz8rrs1p_JWPaIm-). You can click the `HTTPS_CONN` button to automatically fill in the *Title* and *URL*.

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/B8p0kQUgGEJ1TwfcotN4f_image.png" size="80" width="1502" height="669" caption="Logging into Tabix" position="center" showCaption="true"}

- **Title**: By default, this is `HTTPS_CONN`.
- **URL**: `https://` followed by the IP address / domain name of the Belden Horizon Data Manager instance, followed by `:8543` .
- **User**: This is the Clickhouse username that was created from earlier and associated with a Topic.
- **Password**: This is the Clickhouse user's respective password that was created from earlier.
- **Mode**: Keep it as `Normal mode`.

Once you are successfully logged in, all the `Database Name`(s) that were created from an association between a *Clickhouse* user and *Topics (Company/Project)* will be available.



::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/Kmo86ZaMZfsIR4Ypp6y-T_image.png" size="80" width="981" height="367" caption="Database names same" position="center" showCaption="true"}

## Using Tabix

From there, you can view additional data and execute SQL queries in Tabix. For more information about Tabix, see [https://tabix.io/doc/](https://tabix.io/doc/).

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/8oHACJq1_3hRXexRa3Xiq_image.png" size="80" width="1920" height="866" caption="Tabix UI" position="center" showCaption="true"}

\[1] **Access default sql query drop down menu:** Right click on one of the five tables below the Database name.

\[2] **Enter SQL query: **See **[Clickhouse SQL Reference](https://clickhouse.com/docs/en/sql-reference)** for details

\[3] **Run current SQL**

\[4] **View SQL query results**

## Example SQL Query on Tabix

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/2Z-7cvTI2jCPeetPU0Bk__image.png" size="80" width="1836" height="807" caption="Example Tabix UI" position="center" showCaption="true"}