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

   ./sbin/start-server.sh
   

2. Start DBeaver

3. Open Driver Manager

   

4. Create a new driver type for IoTDB

   

5. Download iotdb-jdbc， from source1 or source2，choose the corresponding jar file，download the suffix jar-with-dependencies.jar file.

6. Add the downloaded jar file， then select Find Class.

   

7. Edit the driver Settings

   

8. Open New DataBase Connection and select iotdb

   

9. Edit JDBC Connection Settings

JDBC URL: jdbc:iotdb://127.0.0.1:6667/
Username: root
Password: root

10. Test Connection

11. Enjoy IoTDB with DBeaver