You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by ha...@apache.org on 2021/05/17 04:00:36 UTC
[iotdb] 01/01: Add DBeaver-IoTDB user guide
This is an automated email from the ASF dual-hosted git repository.
haonan pushed a commit to branch dbeaver
in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 1ff718c70a1d370f86cdb4a3dae6e61ba155045a
Author: HTHou <hh...@outlook.com>
AuthorDate: Mon May 17 11:59:41 2021 +0800
Add DBeaver-IoTDB user guide
---
docs/UserGuide/Ecosystem Integration/DBeaver.md | 71 ++++++++++++++++++++++
docs/zh/UserGuide/Ecosystem Integration/DBeaver.md | 71 ++++++++++++++++++++++
2 files changed, 142 insertions(+)
diff --git a/docs/UserGuide/Ecosystem Integration/DBeaver.md b/docs/UserGuide/Ecosystem Integration/DBeaver.md
new file mode 100644
index 0000000..60dfb2a
--- /dev/null
+++ b/docs/UserGuide/Ecosystem Integration/DBeaver.md
@@ -0,0 +1,71 @@
+<!--
+
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+
+-->
+
+## 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
+
+ ```shell
+ ./sbin/start-server.sh
+ ```
+2. Start DBeaver
+3. Open Driver Manager
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2010.56.22%20AM.png?raw=true)
+4. Create a new driver type for IoTDB
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2010.56.51%20AM.png?raw=true)
+5. Add libs listed below (can be found in CLI) and clict `Find Class`
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.00.57%20AM.png?raw=true)
+6. Edit the driver Settings
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.03.03%20AM.png?raw=true)
+7. Open New DataBase Connection and select iotdb
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.05.44%20AM.png?raw=true)
+8. Edit JDBC Connection Settings
+
+ ```
+ JDBC URL: jdbc:iotdb://127.0.0.1:6667/
+ Username: root
+ Password: root
+ ```
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.07.09%20AM.png?raw=true)
+9. Test Connection
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.07.31%20AM.png?raw=true)
+10. Enjoy IoTDB with DBeaver
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.08.33%20AM.png?raw=true)
+
+
+
+
diff --git a/docs/zh/UserGuide/Ecosystem Integration/DBeaver.md b/docs/zh/UserGuide/Ecosystem Integration/DBeaver.md
new file mode 100644
index 0000000..717e6db
--- /dev/null
+++ b/docs/zh/UserGuide/Ecosystem Integration/DBeaver.md
@@ -0,0 +1,71 @@
+<!--
+
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+
+-->
+
+## DBeaver
+
+DBeaver是一个SQL客户端和数据库管理工具。DBeaver可以使用IoTDB的JDBC驱动与IoTDB进行交互。
+
+### DBeaver安装
+
+* DBeaver 下载地址: https://dbeaver.io/download/
+
+### IoTDB 安装
+
+* 下载IoTDB二进制版本
+ * IoTDB 下载地址: https://iotdb.apache.org/Download/
+ * 版本 >= 0.13.0
+* 或者从源代码中编译
+ * 参考 https://github.com/apache/iotdb
+
+### 连接IoTDB与DBeaver
+
+1. 启动 IoTDB 服务
+
+ ```shell
+ ./sbin/start-server.sh
+ ```
+2. 启动 DBeaver
+3. 打开 Driver Manager
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2010.56.22%20AM.png?raw=true)
+4. 为IoTDB新建一个驱动类型
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2010.56.51%20AM.png?raw=true)
+5. 添加下图中的这些库 (可以在CLI文件夹下找到),点击 `Find Class`
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.00.57%20AM.png?raw=true)
+6. 编辑驱动设置
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.03.03%20AM.png?raw=true)
+7. 新建 DataBase Connection, 选择 iotdb
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.05.44%20AM.png?raw=true)
+8. 编辑JDBC连接设置
+
+ ```
+ JDBC URL: jdbc:iotdb://127.0.0.1:6667/
+ Username: root
+ Password: root
+ ```
+ ![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.07.09%20AM.png?raw=true)
+9. 测试连接
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.07.31%20AM.png?raw=true)
+10. 可以开始通过DBeaver使用IoTDB
+![](https://github.com/apache/iotdb-bin-resources/blob/main/docs/UserGuide/Ecosystem%20Integration/DBeaver/Screen%20Shot%202021-05-17%20at%2011.08.33%20AM.png?raw=true)
+
+
+
+