DBeaver

DBeaver is a SQL client software application and a database administration tool. It can use the JDBC application programming interface (API) to interact with IoTDB via the JDBC driver.

DBeaver Installation

  • From DBeaver site: <https://dbeaver.io/download/>

IoTDB Installation

  • Download binary version
  • From IoTDB site: <https://iotdb.apache.org/Download/>
  • Version >= 0.13.0
  • Or compile from source code
  • See <https://github.com/apache/iotdb>

Connect IoTDB and DBeaver

  1. Start IoTDB server

1. ./sbin/start-server.sh 2. Start DBeaver 3. Open Driver Manager

DBeaver - 图1 4. Create a new driver type for IoTDB

DBeaver - 图2 5. Download iotdb-jdbc， from source1 or source2，choose the corresponding jar file，download the suffix jar-with-dependencies.jar file. DBeaver - 图3 6. Add the downloaded jar file， then select Find Class.

DBeaver - 图4 7. Edit the driver Settings

DBeaver - 图5

1. Driver Name: IoTDB 2. Driver Type: Generic 3. URL Template: jdbc:iotdb://{host}:{port}/ 4. Default Port: 6667 5. Default User: root 8. Open New DataBase Connection and select iotdb

DBeaver - 图6 9. Edit JDBC Connection Settings

1. JDBC URL: jdbc:iotdb://127.0.0.1:6667/
2. Username: root
3. Password: root

DBeaver - 图7

  1. Test Connection

DBeaver - 图8

  1. Enjoy IoTDB with DBeaver

DBeaver - 图9

  1. DBeaver tree structure display

DBeaver - 图10