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

   ./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

   

   Driver Name: IoTDB
   Driver Type: Generic
   URL Template: jdbc:iotdb://{host}:{port}/
   Default Port: 6667
   Default User: root
   

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

12. DBeaver tree structure display