Skip to main content

DBeaver

Connecting DBeaver to the Timbr Knowledge Graph​

  1. Download and install DBeaver:

  2. Download the Timbr JDBC jar:

  3. Open DBeaver and click on the power plug icon to create a new connection.

power plug

Setting up the Connection​

  1. In the pop-up window, locate and click on Hive, then click Next.

hive

  1. In the next window, under the General section:

    • Change "Connect by" from Host to URL
    • Enter the following JDBC URL:
      jdbc:hive2://<hostname>:<port>/<ontology_name>;transportMode=http;httpPath=/timbr-server
    • For SSL, use:
      jdbc:hive2://<hostname>:<port>/<ontology_name>;transportMode=http;ssl=true;httpPath=/timbr-server

    Replace <hostname>, <port>, and <ontology_name> with your Timbr instance details.

  2. Under the Authentication section:

    • Username: = token (the actual word, not your personal token)
    • Password: = <your_personal_token> (e.g., tk_123456789…..)

  3. Click on Driver Settings to add the JDBC jar you downloaded earlier:

jdbc

  • In the Edit driver that opens, click on the Libraries tab.

libraries

  • Select the existing artifacts and delete them by clicking on Delete.

delete

  • Click Add File and select the Hive JDBC jar you downloaded at the beginning and click OK.

add
jar

  1. Click Test Connection. If successful, click Finish to complete the setup.

test

** In case you receive an error message please repeat the steps and address the error according to the message.

Using DBeaver with Timbr​

  1. DBeaver will load all schemas. Expand the timbr schema to see tables and concepts.

schema

  1. Double-click any concept or table to view its details (columns, keys, indexes, references).

details

  1. To query the data:
    • Click on SQL in the menu above

query

  • Enter your query in the new tab

query tab

  • Click the Execute Triangle to run the query

execute

  1. When using the dtimbr schema:
    • You'll see not only the properties of the original concept but also its relationships with other concepts as regular columns
    • These relationship columns can be queried like any other column

dtimbr