DBeaver-IoTDB

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-IoTDB - 图1 4. Create a new driver type for IoTDB

DBeaver-IoTDB - 图2 5. Download SourcesDBeaver-IoTDB - 图3 (opens new window)，unzip it and compile jdbc driver by the following command

1. mvn clean package -pl jdbc -am -DskipTests -P get-jar-with-dependencies 6. Find and add a lib named apache-iotdb-jdbc-{version}-jar-with-dependencies.jar, which should be under jdbc/target/, then select Find Class.

DBeaver-IoTDB - 图4 7. Edit the driver Settings

DBeaver-IoTDB - 图5 8. Open New DataBase Connection and select iotdb

DBeaver-IoTDB - 图6 9. Edit JDBC Connection Settings

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

DBeaver-IoTDB - 图7

  1. Test Connection

DBeaver-IoTDB - 图8

  1. Enjoy IoTDB with DBeaver

DBeaver-IoTDB - 图9