Access Tabix UI with Belden Horizon Data Manager

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 docid\ md6nfaz8rrs1p jwpaim create a clickhouse user see the create user option in docid\ md6nfaz8rrs1p jwpaim associate the created tabix user with a topic (company / project) see the add acl option in docid\ md6nfaz8rrs1p jwpaim log into tabix to initially enter tabix ui from the belden horizon data manager admin console, s ee the open tabix option in docid\ md6nfaz8rrs1p jwpaim you can click the https conn button to automatically fill in the title and url 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 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/ \[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 https //clickhouse com/docs/en/sql reference for details \[3] run current sql \[4] view sql query results example sql query on tabix