DBeaver

DBeaver is an SQL client and database management tool. It can interact with IoTDB using IoTDB's JDBC driver.

1. Install DBeaver

• Download DBeaver: https://dbeaver.io/download/

2. Install IoTDB

• Method 1: Download IoTDB binary release
  • Download: https://iotdb.apache.org/Download/
  • Version requirement: ≥ 2.0.1
• Method 2: Build from source
  • Source code: https://github.com/apache/iotdb
  • Follow compilation instructions in README.md or README_ZH.md

3. Connect IoTDB to DBeaver

1. Start the IoTDB service.

   ./sbin/start-server.sh

2. Launch 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/?sql_dialect=table
Username: root
Password: root

10. Test Connection

    

11. You can now use IoTDB via DBeaver.