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/open in new window

IoTDB Installation

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

Connect IoTDB and DBeaver

1. Start IoTDB server

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

4. Create a new driver type for IoTDB

5. Download Sourcesopen in new window，unzip it and compile jdbc driver by the following command

1. mvn clean package -pl iotdb-client/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.

7. Edit the driver Settings

8. Open New DataBase Connection and select iotdb

9. Edit JDBC Connection Settings

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

1. Test Connection

1. Enjoy IoTDB with DBeaver