This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 42ba42cba7ef [docs](BI & IDE) add DBeaver and DataGrip connect Doris
doc (#505)
42ba42cba7ef is described below
commit 42ba42cba7ef98c1bb5173cb07ad5a42f3adc4bf
Author: zy-kkk <[email protected]>
AuthorDate: Tue Apr 2 15:27:34 2024 +0800
[docs](BI & IDE) add DBeaver and DataGrip connect Doris doc (#505)
---
.../{bi-integration => bi}/apache-superset.md | 2 +-
docs/ecosystem/bi/datagrip.md | 89 +++++++++++++++
docs/ecosystem/bi/dbeaver.md | 122 ++++++++++++++++++++
.../docusaurus-plugin-content-docs/current.json | 4 +
.../ecosystem/bi-integration/apache-superset.md | 58 ----------
.../ecosystem/bi}/apache-superset.md | 0
.../current/ecosystem/bi/datagrip.md | 89 +++++++++++++++
.../current/ecosystem/bi/dbeaver.md | 127 +++++++++++++++++++++
.../version-2.0.json | 4 +
.../ecosystem/{ => bi}/apache-superset.md | 0
.../version-2.0/ecosystem/bi/datagrip.md | 89 +++++++++++++++
.../version-2.0/ecosystem/bi/dbeaver.md | 127 +++++++++++++++++++++
.../version-2.1.json | 4 +
.../ecosystem/bi-integration/apache-superset.md | 58 ----------
.../ecosystem/bi}/apache-superset.md | 0
.../version-2.1/ecosystem/bi/datagrip.md | 89 +++++++++++++++
.../version-2.1/ecosystem/bi/dbeaver.md | 127 +++++++++++++++++++++
sidebars.json | 10 +-
static/images/datagrip1.png | Bin 0 -> 230855 bytes
static/images/datagrip2.png | Bin 0 -> 189679 bytes
static/images/datagrip3.png | Bin 0 -> 192801 bytes
static/images/datagrip4.png | Bin 0 -> 265627 bytes
static/images/datagrip5.png | Bin 0 -> 64529 bytes
static/images/dbeaver1.png | Bin 0 -> 80879 bytes
static/images/dbeaver2.png | Bin 0 -> 165711 bytes
static/images/dbeaver3.png | Bin 0 -> 392716 bytes
static/images/dbeaver4.png | Bin 0 -> 230780 bytes
static/images/dbeaver5.png | Bin 0 -> 234243 bytes
static/images/dbeaver6.png | Bin 0 -> 394581 bytes
static/images/dbeaver7.png | Bin 0 -> 123712 bytes
.../ecosystem/{ => bi}/apache-superset.md | 2 +-
.../version-2.0/ecosystem/bi/datagrip.md | 89 +++++++++++++++
versioned_docs/version-2.0/ecosystem/bi/dbeaver.md | 122 ++++++++++++++++++++
.../{bi-integration => bi}/apache-superset.md | 2 +-
.../version-2.1/ecosystem/bi/datagrip.md | 89 +++++++++++++++
versioned_docs/version-2.1/ecosystem/bi/dbeaver.md | 122 ++++++++++++++++++++
versioned_sidebars/version-2.0-sidebars.json | 12 +-
versioned_sidebars/version-2.1-sidebars.json | 10 +-
38 files changed, 1324 insertions(+), 123 deletions(-)
diff --git a/docs/ecosystem/bi-integration/apache-superset.md
b/docs/ecosystem/bi/apache-superset.md
similarity index 98%
rename from docs/ecosystem/bi-integration/apache-superset.md
rename to docs/ecosystem/bi/apache-superset.md
index 0ada613da752..6c172c17ec1c 100644
--- a/docs/ecosystem/bi-integration/apache-superset.md
+++ b/docs/ecosystem/bi/apache-superset.md
@@ -1,6 +1,6 @@
---
{
-"title": "Apache Superset Integrate",
+"title": "Apache Superset",
"language": "en"
}
---
diff --git a/docs/ecosystem/bi/datagrip.md b/docs/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..f92c70a9bdb3
--- /dev/null
+++ b/docs/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DataGrip is a powerful cross-platform database tool for relational and NoSQL
databases from JetBrains.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DataGrip's MySQL data source to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+DataGrip installed
+You can visit www.jetbrains.com/datagrip/ to download and install DataGrip
+
+## Add data source
+
+:::info Note
+Currently verified using DataGrip version 2023.3.4
+:::
+
+1. Start DataGrip
+2. Click the plus sign (**+**) icon in the upper left corner of the DataGrip
window and select the MySQL data source
+
+ 
+
+3. Configure Doris connection
+
+ On the General tab of the Data Sources and Drivers window, configure the
following connection information:
+
+ - Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - User: User name used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DataGrip The database table is also a database table in
the connected catalog. In this way, you can use DataGrip's MySQL data source to
create multiple Doris [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. If DBeaver returns the following pop-up window, the test
connection is successful. Then click OK in the lower right corner to complete
the connection configuration.
+
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DataGrip.
+
+ 
+
+## Function support
+
+Basically supports most visual viewing operations, as well as SQL console
writing SQL operations Doris does not support or has not been verified various
operations such as creating database tables, schema changes, and adding,
deleting, and modifying data.
diff --git a/docs/ecosystem/bi/dbeaver.md b/docs/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..2ecbc2fae3a7
--- /dev/null
+++ b/docs/ecosystem/bi/dbeaver.md
@@ -0,0 +1,122 @@
+---
+{
+ "title": "DBeaver",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DBeaver is a cross-platform database tool for developers, database
administrators, analysts and anyone who works with data.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DBeaver's MySQL driver to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+Dbeaver installed
+You can visit https://dbeaver.io to download and install DBeaver
+
+## Add data source
+
+:::info Note
+Currently verified using DBeaver version 24.0.0
+:::
+
+1. Start DBeaver
+
+2. Click the plus sign (**+**) icon in the upper left corner of the DBeaver
window, or select **Database > New Database Connection** in the menu bar to
open the **Connect to a database** interface.
+
+ 
+
+ 
+
+3. Select the MySQL driver
+
+ In the **Select your database** window, select **MySQL**.
+
+ 
+
+4. Configure Doris connection
+
+ In the **main** tab of the **Connection Settings** window, configure the
following connection information:
+
+ - Server Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - Username: The username used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DBeaver The database tables are also database tables in
the connected catalog, so you can use DBeaver's MySQL driver to create multiple
Doris data sources to m [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+ 
+ - external catalog
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. DBeaver returns to the following dialog box to confirm the
configuration of the connection information. Click OK to confirm that the
configured connection information is correct. Then click Finish in the lower
right corner to complete the connection configuration.
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DBeaver.
+ 
+
+## Function support
+- fully support
+ - Visual viewing class
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - Operation class
+ - SQL editor
+ - SQL console
+- basic support
+
+ The basic support part means that you can click to view without error, but
due to protocol compatibility issues, there may be incomplete display.
+
+ - Visual viewing class
+ - dash board
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- not support
+
+ The unsupported part means that when using DBeaver to manage Doris, errors
may be reported when performing certain visual operations, or some visual
operations are not verified.
+ Such as visual creation of database tables, schema change, addition,
deletion and modification of data, etc.
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
b/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
index da0e28f675b6..032bbb094fc3 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
@@ -103,6 +103,10 @@
"message": "生态扩展",
"description": "The label for category Ecosystem in sidebar docs"
},
+ "sidebar.docs.category.BI and Database IDE": {
+ "message": "BI 与数据库 IDE",
+ "description": "The label for category BI and Database IDE in sidebar docs"
+ },
"sidebar.docs.category.Doris Manager": {
"message": "Doris Manager",
"description": "The label for category Doris Manager in sidebar docs"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi-integration/apache-superset.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi-integration/apache-superset.md
deleted file mode 100644
index 58200c7d561b..000000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi-integration/apache-superset.md
+++ /dev/null
@@ -1,58 +0,0 @@
----
-{
-"title": "Apache Superset 集成",
-"language": "zh-CN"
-}
----
-
-<!--
-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.
--->
-
-
-## 介绍
-Apache Superset
是一个开源的数据挖掘平台，支持丰富的数据源连接，多种可视化方式，并能够对用户实现细粒度的权限控制。该工具主要特点是可自助分析、自定义仪表盘、分析结果可视化（导出）、用户/角色权限控制，还集成了一个
SQL 编辑器，可以进行 SQL 编辑查询等。
-
-在 Apache Superset 3.1 版本中正式支持了 Apache Doris 的内部数据和外部数据进行查询和可视化处理。
-## 前置条件
-确保您已完成如下工具安装：
-1. 在 Apache Superset 服务器上安装 Apache Doris 的 Python 客户端。
- ```
- pip install pydoris
- ```
-2. 安装 Apache Superset 3.1 及其以上的版本。具体参见[安装 Superset 从 PyPI
库](https://superset.apache.org/docs/installation/installing-superset-from-pypi)或者[通过
Docker 容器的方式安装](https://hub.docker.com/r/apache/superset)
-
-## 添加数据源
-当你在 Apache Superset 中创建数据源时需要注意以下两点：
-- 在 SUPPORTED DATABASES 里选择 Apache Doris 作为数据源。
-- 在 SQLALCHEMY URI 里，按如下 Doris SQLAlchemy URI 格式填写 URI：
-
- ```doris://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>```
-- URI 参数说明如下：
- - User：用于登录 Doris 集群的用户名，如 admin。
- - Password：用于登录 Doris 集群的用户密码。
- - Host：Doris 集群的 FE 主机 IP 地址。
- - Port：Doris 集群的 FE 查询端口，如 9030。
- - Catalog：Doris 集群中的目标 Catalog。Internal Catalog 和 External Catalog 均支持。
- - Database：Doris 集群中的目标数据库。内部数据库和外部数据库均支持。
-
-
-:::tip
-1. 当你使用最新的 Docker 镜像部署 Superset 时，如果发现找不到 Apache Doris 数据源，这个可能是因为 Superset
Docker Image默认只包含基本的数据源构建，需要手动将 pydoris 包安装进来，您可以参考 [superset docker教程]
(https://hub.docker.com/r/apache/superset)中的 How to extend this image 步骤进行
Apache Superset 的部署。
-2. 推荐使用 Apache Doris 2.0.4 及以上版本。
-:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/apache-superset.md
similarity index 100%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/apache-superset.md
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/datagrip.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..1bd938748faf
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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.
+-->
+
+## 介绍
+
+DataGrip 是 JetBrains 出品的适用于关系数据库和 NoSQL 数据库的强大跨平台数据库工具。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DataGrip 的 MySQL 数据源连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 DataGrip
+可以访问 www.jetbrains.com/datagrip/ 下载安装 DataGrip
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DataGrip 2023.3.4 版本
+:::
+
+1. 启动 DataGrip
+2. 在 DataGrip 窗口左上角单击加号 (**+**) 图标，选择 MySQL 数据源
+
+ 
+
+3. 配置 Doris 连接
+
+ 在 Data Sources and Drivers 窗口的 General 标签页，配置以下连接信息：
+
+ - Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - User：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DataGrip 中展示的库表也为所连接 catalog 中的库表，以此可以使用 DataGrip 的 MySQL 数据源来创建多个
Doris 数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver
返回如下对弹窗则测试连接成功。然后单击右下角 OK 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DataGrip 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+基本支持大部分可视化查看操作，以及 SQL 控制台编写 SQL 操作 Doris，不支持或未经验证各种创建库表、schema change、增删改数据操作。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/dbeaver.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..17bbcff17627
--- /dev/null
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/dbeaver.md
@@ -0,0 +1,127 @@
+---
+{
+ "title": "DBeaver",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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 是一款跨平台数据库工具，适用于开发人员、数据库管理员、分析师和所有处理数据的人。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DBeaver 的 MySQL 驱动器连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 Dbeaver
+可以访问 https://dbeaver.io 下载安装 DBeaver
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DBeaver 24.0.0 版本
+:::
+
+1. 启动 DBeaver
+2. 在 DBeaver 窗口左上角单击加号 (**+**) 图标，或者在菜单栏选择 **Database > New Database
Connection**，打开 **Connect to a database** 界面。
+
+ 
+
+ 
+
+3. 选择 MySQL 驱动器
+
+ 在 **Select your database** 窗口，选择 **MySQL** 。
+
+ 
+
+4. 配置 Doris 连接
+
+ 在 **Connection Settings** 窗口的 **main** 标签页，配置以下连接信息：
+
+ - Server Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - Username：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DBeaver 中展示的库表也为所连接 catalog 中的库表，因此可以使用 DBeaver 的 MySQL 驱动器来创建多个 Doris
数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver 返回如下对话框，确认配置连接信息。单击
OK 即确认配置连接信息无误。然后单击右下角 Finish 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DBeaver 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+- 完全支持
+ - 可视化查看类
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - 操作类
+ - SQL 编辑器
+ - SQL 控制台
+- 基本支持
+
+ 基本支持的部分意为可以点击查看不会报错，但由于存在协议兼容问题，可能存在显示不全
+
+ - 可视化查看类
+ - 仪表盘
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- 不支持
+
+ 不支持部分意为使用 DBeaver 管理 Doris 进行某些可视化操作时可能会报错，或者某些可视化操作未经验证
+ 如可视化创建库表、schema change、增删改数据等
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0.json
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0.json
index 9592934d8d59..ced60723001d 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0.json
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0.json
@@ -131,6 +131,10 @@
"message": "生态扩展",
"description": "The label for category Ecosystem in sidebar docs"
},
+ "sidebar.docs.category.BI and Database IDE": {
+ "message": "BI 与数据库 IDE",
+ "description": "The label for category BI and Database IDE in sidebar
docs"
+ },
"sidebar.docs.category.Admin Manual": {
"message": "管理指南",
"description": "The label for category Admin Manual in sidebar docs"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/apache-superset.md
similarity index 100%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/apache-superset.md
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/datagrip.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..1bd938748faf
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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.
+-->
+
+## 介绍
+
+DataGrip 是 JetBrains 出品的适用于关系数据库和 NoSQL 数据库的强大跨平台数据库工具。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DataGrip 的 MySQL 数据源连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 DataGrip
+可以访问 www.jetbrains.com/datagrip/ 下载安装 DataGrip
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DataGrip 2023.3.4 版本
+:::
+
+1. 启动 DataGrip
+2. 在 DataGrip 窗口左上角单击加号 (**+**) 图标，选择 MySQL 数据源
+
+ 
+
+3. 配置 Doris 连接
+
+ 在 Data Sources and Drivers 窗口的 General 标签页，配置以下连接信息：
+
+ - Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - User：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DataGrip 中展示的库表也为所连接 catalog 中的库表，以此可以使用 DataGrip 的 MySQL 数据源来创建多个
Doris 数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver
返回如下对弹窗则测试连接成功。然后单击右下角 OK 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DataGrip 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+基本支持大部分可视化查看操作，以及 SQL 控制台编写 SQL 操作 Doris，不支持或未经验证各种创建库表、schema change、增删改数据操作。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/dbeaver.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..17bbcff17627
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/bi/dbeaver.md
@@ -0,0 +1,127 @@
+---
+{
+ "title": "DBeaver",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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 是一款跨平台数据库工具，适用于开发人员、数据库管理员、分析师和所有处理数据的人。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DBeaver 的 MySQL 驱动器连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 Dbeaver
+可以访问 https://dbeaver.io 下载安装 DBeaver
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DBeaver 24.0.0 版本
+:::
+
+1. 启动 DBeaver
+2. 在 DBeaver 窗口左上角单击加号 (**+**) 图标，或者在菜单栏选择 **Database > New Database
Connection**，打开 **Connect to a database** 界面。
+
+ 
+
+ 
+
+3. 选择 MySQL 驱动器
+
+ 在 **Select your database** 窗口，选择 **MySQL** 。
+
+ 
+
+4. 配置 Doris 连接
+
+ 在 **Connection Settings** 窗口的 **main** 标签页，配置以下连接信息：
+
+ - Server Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - Username：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DBeaver 中展示的库表也为所连接 catalog 中的库表，因此可以使用 DBeaver 的 MySQL 驱动器来创建多个 Doris
数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver 返回如下对话框，确认配置连接信息。单击
OK 即确认配置连接信息无误。然后单击右下角 Finish 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DBeaver 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+- 完全支持
+ - 可视化查看类
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - 操作类
+ - SQL 编辑器
+ - SQL 控制台
+- 基本支持
+
+ 基本支持的部分意为可以点击查看不会报错，但由于存在协议兼容问题，可能存在显示不全
+
+ - 可视化查看类
+ - 仪表盘
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- 不支持
+
+ 不支持部分意为使用 DBeaver 管理 Doris 进行某些可视化操作时可能会报错，或者某些可视化操作未经验证
+ 如可视化创建库表、schema change、增删改数据等
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1.json
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1.json
index 5e6502d23667..b18040457054 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1.json
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1.json
@@ -103,6 +103,10 @@
"message": "生态扩展",
"description": "The label for category Ecosystem in sidebar docs"
},
+ "sidebar.docs.category.BI and Database IDE": {
+ "message": "BI 与数据库 IDE",
+ "description": "The label for category BI and Database IDE in sidebar docs"
+ },
"sidebar.docs.category.Doris Manager": {
"message": "Doris Manager",
"description": "The label for category Doris Manager in sidebar docs"
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi-integration/apache-superset.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi-integration/apache-superset.md
deleted file mode 100644
index 58200c7d561b..000000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi-integration/apache-superset.md
+++ /dev/null
@@ -1,58 +0,0 @@
----
-{
-"title": "Apache Superset 集成",
-"language": "zh-CN"
-}
----
-
-<!--
-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.
--->
-
-
-## 介绍
-Apache Superset
是一个开源的数据挖掘平台，支持丰富的数据源连接，多种可视化方式，并能够对用户实现细粒度的权限控制。该工具主要特点是可自助分析、自定义仪表盘、分析结果可视化（导出）、用户/角色权限控制，还集成了一个
SQL 编辑器，可以进行 SQL 编辑查询等。
-
-在 Apache Superset 3.1 版本中正式支持了 Apache Doris 的内部数据和外部数据进行查询和可视化处理。
-## 前置条件
-确保您已完成如下工具安装：
-1. 在 Apache Superset 服务器上安装 Apache Doris 的 Python 客户端。
- ```
- pip install pydoris
- ```
-2. 安装 Apache Superset 3.1 及其以上的版本。具体参见[安装 Superset 从 PyPI
库](https://superset.apache.org/docs/installation/installing-superset-from-pypi)或者[通过
Docker 容器的方式安装](https://hub.docker.com/r/apache/superset)
-
-## 添加数据源
-当你在 Apache Superset 中创建数据源时需要注意以下两点：
-- 在 SUPPORTED DATABASES 里选择 Apache Doris 作为数据源。
-- 在 SQLALCHEMY URI 里，按如下 Doris SQLAlchemy URI 格式填写 URI：
-
- ```doris://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>```
-- URI 参数说明如下：
- - User：用于登录 Doris 集群的用户名，如 admin。
- - Password：用于登录 Doris 集群的用户密码。
- - Host：Doris 集群的 FE 主机 IP 地址。
- - Port：Doris 集群的 FE 查询端口，如 9030。
- - Catalog：Doris 集群中的目标 Catalog。Internal Catalog 和 External Catalog 均支持。
- - Database：Doris 集群中的目标数据库。内部数据库和外部数据库均支持。
-
-
-:::tip
-1. 当你使用最新的 Docker 镜像部署 Superset 时，如果发现找不到 Apache Doris 数据源，这个可能是因为 Superset
Docker Image默认只包含基本的数据源构建，需要手动将 pydoris 包安装进来，您可以参考 [superset docker教程]
(https://hub.docker.com/r/apache/superset)中的 How to extend this image 步骤进行
Apache Superset 的部署。
-2. 推荐使用 Apache Doris 2.0.4 及以上版本。
-:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/apache-superset.md
similarity index 100%
rename from
i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/ecosystem/apache-superset.md
rename to
i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/apache-superset.md
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/datagrip.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..1bd938748faf
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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.
+-->
+
+## 介绍
+
+DataGrip 是 JetBrains 出品的适用于关系数据库和 NoSQL 数据库的强大跨平台数据库工具。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DataGrip 的 MySQL 数据源连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 DataGrip
+可以访问 www.jetbrains.com/datagrip/ 下载安装 DataGrip
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DataGrip 2023.3.4 版本
+:::
+
+1. 启动 DataGrip
+2. 在 DataGrip 窗口左上角单击加号 (**+**) 图标，选择 MySQL 数据源
+
+ 
+
+3. 配置 Doris 连接
+
+ 在 Data Sources and Drivers 窗口的 General 标签页，配置以下连接信息：
+
+ - Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - User：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DataGrip 中展示的库表也为所连接 catalog 中的库表，以此可以使用 DataGrip 的 MySQL 数据源来创建多个
Doris 数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver
返回如下对弹窗则测试连接成功。然后单击右下角 OK 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DataGrip 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+基本支持大部分可视化查看操作，以及 SQL 控制台编写 SQL 操作 Doris，不支持或未经验证各种创建库表、schema change、增删改数据操作。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/dbeaver.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..17bbcff17627
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/ecosystem/bi/dbeaver.md
@@ -0,0 +1,127 @@
+---
+{
+ "title": "DBeaver",
+ "language": "zh-CN"
+}
+---
+
+<!--
+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 是一款跨平台数据库工具，适用于开发人员、数据库管理员、分析师和所有处理数据的人。
+
+Apache Doris 高度兼容 MySQL 协议，可以使用 DBeaver 的 MySQL 驱动器连接 Apache Doris，并查询
internal catalog 和 external catalog 中的数据。
+
+## 前置条件
+
+已安装 Dbeaver
+可以访问 https://dbeaver.io 下载安装 DBeaver
+
+## 添加数据源
+
+:::info 备注
+当前验证使用 DBeaver 24.0.0 版本
+:::
+
+1. 启动 DBeaver
+2. 在 DBeaver 窗口左上角单击加号 (**+**) 图标，或者在菜单栏选择 **Database > New Database
Connection**，打开 **Connect to a database** 界面。
+
+ 
+
+ 
+
+3. 选择 MySQL 驱动器
+
+ 在 **Select your database** 窗口，选择 **MySQL** 。
+
+ 
+
+4. 配置 Doris 连接
+
+ 在 **Connection Settings** 窗口的 **main** 标签页，配置以下连接信息：
+
+ - Server Host：Doris 集群的 FE 主机 IP 地址。
+ - Port：Doris 集群的 FE 查询端口，如 9030。
+ - Database：Doris 集群中的目标数据库。
+ - Username：用于登录 Doris 集群的用户名，如 admin。
+ - Password：用于登录 Doris 集群的用户密码。
+
+ :::tip
+ Database 可以用于区别 internal catalog 和 external catalog，如仅填写 Database
名称，则当前数据源默认连接 internal catalog，如填写格式为 catalog.db，则当前数据源默认连接 Database 中所填写的
catalog，DBeaver 中展示的库表也为所连接 catalog 中的库表，因此可以使用 DBeaver 的 MySQL 驱动器来创建多个 Doris
数据源来管理 Doris 中不同的 Catalog。
+ :::
+
+ :::info 备注
+ 通过 catalog.db 的 Database 形式来管理连接 Doris 的 external catalog 需要 Doris 版本在
2.1.0 及以上
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. 测试数据源连接
+
+ 在填写完连接信息后，单击左下角 Test Connection 验证数据库连接信息的准确性。DBeaver 返回如下对话框，确认配置连接信息。单击
OK 即确认配置连接信息无误。然后单击右下角 Finish 完成连接配置。
+
+ 
+
+6. 连接数据库
+
+ 数据库连接建立以后，可以在左侧的数据库连接导航看到已创建的数据源连接，并且可以通过 DBeaver 连接并管理数据库。
+
+ 
+
+## 功能支持
+
+- 完全支持
+ - 可视化查看类
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - 操作类
+ - SQL 编辑器
+ - SQL 控制台
+- 基本支持
+
+ 基本支持的部分意为可以点击查看不会报错，但由于存在协议兼容问题，可能存在显示不全
+
+ - 可视化查看类
+ - 仪表盘
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- 不支持
+
+ 不支持部分意为使用 DBeaver 管理 Doris 进行某些可视化操作时可能会报错，或者某些可视化操作未经验证
+ 如可视化创建库表、schema change、增删改数据等
diff --git a/sidebars.json b/sidebars.json
index 5e29a45696a0..0cbd9b50ef64 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -295,7 +295,15 @@
"ecosystem/cloudcanal",
"ecosystem/hive-bitmap-udf",
"ecosystem/dbt-doris-adapter",
- "ecosystem/bi-integration/apache-superset",
+ {
+ "type": "category",
+ "label": "BI and Database IDE",
+ "items": [
+ "ecosystem/bi/apache-superset",
+ "ecosystem/bi/dbeaver",
+ "ecosystem/bi/datagrip"
+ ]
+ },
{
"type": "category",
"label": "UDF",
diff --git a/static/images/datagrip1.png b/static/images/datagrip1.png
new file mode 100644
index 000000000000..baa24ea69d4f
Binary files /dev/null and b/static/images/datagrip1.png differ
diff --git a/static/images/datagrip2.png b/static/images/datagrip2.png
new file mode 100644
index 000000000000..d70c3bb287e4
Binary files /dev/null and b/static/images/datagrip2.png differ
diff --git a/static/images/datagrip3.png b/static/images/datagrip3.png
new file mode 100644
index 000000000000..677ab6e8031f
Binary files /dev/null and b/static/images/datagrip3.png differ
diff --git a/static/images/datagrip4.png b/static/images/datagrip4.png
new file mode 100644
index 000000000000..9e59594dee6e
Binary files /dev/null and b/static/images/datagrip4.png differ
diff --git a/static/images/datagrip5.png b/static/images/datagrip5.png
new file mode 100644
index 000000000000..b7e693c9679f
Binary files /dev/null and b/static/images/datagrip5.png differ
diff --git a/static/images/dbeaver1.png b/static/images/dbeaver1.png
new file mode 100644
index 000000000000..71353c08558f
Binary files /dev/null and b/static/images/dbeaver1.png differ
diff --git a/static/images/dbeaver2.png b/static/images/dbeaver2.png
new file mode 100644
index 000000000000..60dbc8f14342
Binary files /dev/null and b/static/images/dbeaver2.png differ
diff --git a/static/images/dbeaver3.png b/static/images/dbeaver3.png
new file mode 100644
index 000000000000..8024d6841dd3
Binary files /dev/null and b/static/images/dbeaver3.png differ
diff --git a/static/images/dbeaver4.png b/static/images/dbeaver4.png
new file mode 100644
index 000000000000..2327503adc7e
Binary files /dev/null and b/static/images/dbeaver4.png differ
diff --git a/static/images/dbeaver5.png b/static/images/dbeaver5.png
new file mode 100644
index 000000000000..026701d26022
Binary files /dev/null and b/static/images/dbeaver5.png differ
diff --git a/static/images/dbeaver6.png b/static/images/dbeaver6.png
new file mode 100644
index 000000000000..7e26f14b61c5
Binary files /dev/null and b/static/images/dbeaver6.png differ
diff --git a/static/images/dbeaver7.png b/static/images/dbeaver7.png
new file mode 100644
index 000000000000..66c4cc0aae5f
Binary files /dev/null and b/static/images/dbeaver7.png differ
diff --git a/versioned_docs/version-2.0/ecosystem/apache-superset.md
b/versioned_docs/version-2.0/ecosystem/bi/apache-superset.md
similarity index 98%
rename from versioned_docs/version-2.0/ecosystem/apache-superset.md
rename to versioned_docs/version-2.0/ecosystem/bi/apache-superset.md
index 0ada613da752..6c172c17ec1c 100644
--- a/versioned_docs/version-2.0/ecosystem/apache-superset.md
+++ b/versioned_docs/version-2.0/ecosystem/bi/apache-superset.md
@@ -1,6 +1,6 @@
---
{
-"title": "Apache Superset Integrate",
+"title": "Apache Superset",
"language": "en"
}
---
diff --git a/versioned_docs/version-2.0/ecosystem/bi/datagrip.md
b/versioned_docs/version-2.0/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..f92c70a9bdb3
--- /dev/null
+++ b/versioned_docs/version-2.0/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DataGrip is a powerful cross-platform database tool for relational and NoSQL
databases from JetBrains.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DataGrip's MySQL data source to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+DataGrip installed
+You can visit www.jetbrains.com/datagrip/ to download and install DataGrip
+
+## Add data source
+
+:::info Note
+Currently verified using DataGrip version 2023.3.4
+:::
+
+1. Start DataGrip
+2. Click the plus sign (**+**) icon in the upper left corner of the DataGrip
window and select the MySQL data source
+
+ 
+
+3. Configure Doris connection
+
+ On the General tab of the Data Sources and Drivers window, configure the
following connection information:
+
+ - Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - User: User name used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DataGrip The database table is also a database table in
the connected catalog. In this way, you can use DataGrip's MySQL data source to
create multiple Doris [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. If DBeaver returns the following pop-up window, the test
connection is successful. Then click OK in the lower right corner to complete
the connection configuration.
+
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DataGrip.
+
+ 
+
+## Function support
+
+Basically supports most visual viewing operations, as well as SQL console
writing SQL operations Doris does not support or has not been verified various
operations such as creating database tables, schema changes, and adding,
deleting, and modifying data.
diff --git a/versioned_docs/version-2.0/ecosystem/bi/dbeaver.md
b/versioned_docs/version-2.0/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..2ecbc2fae3a7
--- /dev/null
+++ b/versioned_docs/version-2.0/ecosystem/bi/dbeaver.md
@@ -0,0 +1,122 @@
+---
+{
+ "title": "DBeaver",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DBeaver is a cross-platform database tool for developers, database
administrators, analysts and anyone who works with data.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DBeaver's MySQL driver to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+Dbeaver installed
+You can visit https://dbeaver.io to download and install DBeaver
+
+## Add data source
+
+:::info Note
+Currently verified using DBeaver version 24.0.0
+:::
+
+1. Start DBeaver
+
+2. Click the plus sign (**+**) icon in the upper left corner of the DBeaver
window, or select **Database > New Database Connection** in the menu bar to
open the **Connect to a database** interface.
+
+ 
+
+ 
+
+3. Select the MySQL driver
+
+ In the **Select your database** window, select **MySQL**.
+
+ 
+
+4. Configure Doris connection
+
+ In the **main** tab of the **Connection Settings** window, configure the
following connection information:
+
+ - Server Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - Username: The username used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DBeaver The database tables are also database tables in
the connected catalog, so you can use DBeaver's MySQL driver to create multiple
Doris data sources to m [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+ 
+ - external catalog
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. DBeaver returns to the following dialog box to confirm the
configuration of the connection information. Click OK to confirm that the
configured connection information is correct. Then click Finish in the lower
right corner to complete the connection configuration.
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DBeaver.
+ 
+
+## Function support
+- fully support
+ - Visual viewing class
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - Operation class
+ - SQL editor
+ - SQL console
+- basic support
+
+ The basic support part means that you can click to view without error, but
due to protocol compatibility issues, there may be incomplete display.
+
+ - Visual viewing class
+ - dash board
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- not support
+
+ The unsupported part means that when using DBeaver to manage Doris, errors
may be reported when performing certain visual operations, or some visual
operations are not verified.
+ Such as visual creation of database tables, schema change, addition,
deletion and modification of data, etc.
diff --git
a/versioned_docs/version-2.1/ecosystem/bi-integration/apache-superset.md
b/versioned_docs/version-2.1/ecosystem/bi/apache-superset.md
similarity index 98%
rename from
versioned_docs/version-2.1/ecosystem/bi-integration/apache-superset.md
rename to versioned_docs/version-2.1/ecosystem/bi/apache-superset.md
index 0ada613da752..6c172c17ec1c 100644
--- a/versioned_docs/version-2.1/ecosystem/bi-integration/apache-superset.md
+++ b/versioned_docs/version-2.1/ecosystem/bi/apache-superset.md
@@ -1,6 +1,6 @@
---
{
-"title": "Apache Superset Integrate",
+"title": "Apache Superset",
"language": "en"
}
---
diff --git a/versioned_docs/version-2.1/ecosystem/bi/datagrip.md
b/versioned_docs/version-2.1/ecosystem/bi/datagrip.md
new file mode 100644
index 000000000000..f92c70a9bdb3
--- /dev/null
+++ b/versioned_docs/version-2.1/ecosystem/bi/datagrip.md
@@ -0,0 +1,89 @@
+---
+{
+ "title": "DataGrip",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DataGrip is a powerful cross-platform database tool for relational and NoSQL
databases from JetBrains.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DataGrip's MySQL data source to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+DataGrip installed
+You can visit www.jetbrains.com/datagrip/ to download and install DataGrip
+
+## Add data source
+
+:::info Note
+Currently verified using DataGrip version 2023.3.4
+:::
+
+1. Start DataGrip
+2. Click the plus sign (**+**) icon in the upper left corner of the DataGrip
window and select the MySQL data source
+
+ 
+
+3. Configure Doris connection
+
+ On the General tab of the Data Sources and Drivers window, configure the
following connection information:
+
+ - Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - User: User name used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DataGrip The database table is also a database table in
the connected catalog. In this way, you can use DataGrip's MySQL data source to
create multiple Doris [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+
+ 
+
+ - external catalog
+
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. If DBeaver returns the following pop-up window, the test
connection is successful. Then click OK in the lower right corner to complete
the connection configuration.
+
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DataGrip.
+
+ 
+
+## Function support
+
+Basically supports most visual viewing operations, as well as SQL console
writing SQL operations Doris does not support or has not been verified various
operations such as creating database tables, schema changes, and adding,
deleting, and modifying data.
diff --git a/versioned_docs/version-2.1/ecosystem/bi/dbeaver.md
b/versioned_docs/version-2.1/ecosystem/bi/dbeaver.md
new file mode 100644
index 000000000000..2ecbc2fae3a7
--- /dev/null
+++ b/versioned_docs/version-2.1/ecosystem/bi/dbeaver.md
@@ -0,0 +1,122 @@
+---
+{
+ "title": "DBeaver",
+ "language": "en"
+}
+---
+
+<!--
+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.
+-->
+
+## introduce
+
+DBeaver is a cross-platform database tool for developers, database
administrators, analysts and anyone who works with data.
+
+Apache Doris is highly compatible with the MySQL protocol. You can use
DBeaver's MySQL driver to connect to Apache Doris and query data in the
internal catalog and external catalog.
+
+## Preconditions
+
+Dbeaver installed
+You can visit https://dbeaver.io to download and install DBeaver
+
+## Add data source
+
+:::info Note
+Currently verified using DBeaver version 24.0.0
+:::
+
+1. Start DBeaver
+
+2. Click the plus sign (**+**) icon in the upper left corner of the DBeaver
window, or select **Database > New Database Connection** in the menu bar to
open the **Connect to a database** interface.
+
+ 
+
+ 
+
+3. Select the MySQL driver
+
+ In the **Select your database** window, select **MySQL**.
+
+ 
+
+4. Configure Doris connection
+
+ In the **main** tab of the **Connection Settings** window, configure the
following connection information:
+
+ - Server Host: FE host IP address of the Doris cluster.
+ - Port: FE query port of Doris cluster, such as 9030.
+ - Database: The target database in the Doris cluster.
+ - Username: The username used to log in to the Doris cluster, such as admin.
+ - Password: User password used to log in to the Doris cluster.
+
+ :::tip
+ Database can be used to distinguish between internal catalog and external
catalog. If only the Database name is filled in, the current data source will
be connected to the internal catalog by default. If the format is catalog.db,
the current data source will be connected to the catalog filled in Database by
default, as shown in DBeaver The database tables are also database tables in
the connected catalog, so you can use DBeaver's MySQL driver to create multiple
Doris data sources to m [...]
+ :::
+
+ :::info Note
+ Managing the external catalog connected to Doris through the Database form
of catalog.db requires Doris version 2.1.0 and above.
+ :::
+
+ - internal catalog
+ 
+ - external catalog
+ 
+
+5. Test data source connection
+
+ After filling in the connection information, click Test Connection in the
lower left corner to verify the accuracy of the database connection
information. DBeaver returns to the following dialog box to confirm the
configuration of the connection information. Click OK to confirm that the
configured connection information is correct. Then click Finish in the lower
right corner to complete the connection configuration.
+ 
+
+6. Connect to database
+
+ After the database connection is established, you can see the created data
source connection in the database connection navigation on the left, and you
can connect and manage the database through DBeaver.
+ 
+
+## Function support
+- fully support
+ - Visual viewing class
+ - Databases
+ - Tables
+ - Views
+ - Users
+ - Administer
+ - Session Manager
+ - System Info
+ - Session Variables
+ - Global Variables
+ - Engines
+ - Charsets
+ - User Priviages
+ - Plugin
+ - Operation class
+ - SQL editor
+ - SQL console
+- basic support
+
+ The basic support part means that you can click to view without error, but
due to protocol compatibility issues, there may be incomplete display.
+
+ - Visual viewing class
+ - dash board
+ - Users/user/properties
+ - Session Status
+ - Global Status
+- not support
+
+ The unsupported part means that when using DBeaver to manage Doris, errors
may be reported when performing certain visual operations, or some visual
operations are not verified.
+ Such as visual creation of database tables, schema change, addition,
deletion and modification of data, etc.
diff --git a/versioned_sidebars/version-2.0-sidebars.json
b/versioned_sidebars/version-2.0-sidebars.json
index f00c17dbe793..87f22494b518 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -481,9 +481,17 @@
"ecosystem/logstash",
"ecosystem/beats",
"ecosystem/cloudcanal",
- "ecosystem/apache-superset",
"ecosystem/doris-streamloader",
- "ecosystem/hive-bitmap-udf"
+ "ecosystem/hive-bitmap-udf",
+ {
+ "type": "category",
+ "label": "BI and Database IDE",
+ "items": [
+ "ecosystem/bi/apache-superset",
+ "ecosystem/bi/dbeaver",
+ "ecosystem/bi/datagrip"
+ ]
+ }
]
},
{
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index 1c70636f03a6..3dd5d8c49bb7 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -293,7 +293,15 @@
"ecosystem/cloudcanal",
"ecosystem/hive-bitmap-udf",
"ecosystem/dbt-doris-adapter",
- "ecosystem/bi-integration/apache-superset",
+ {
+ "type": "category",
+ "label": "BI and Database IDE",
+ "items": [
+ "ecosystem/bi/apache-superset",
+ "ecosystem/bi/dbeaver",
+ "ecosystem/bi/datagrip"
+ ]
+ },
{
"type": "category",
"label": "UDF",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
