This is an automated email from the ASF dual-hosted git repository.
catpineapple 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 44524a3fa11 tableau-mysql docs (#3104)
44524a3fa11 is described below
commit 44524a3fa11bacdc1a67e0a7ccf78ec6cb24f89c
Author: catpineapple <[email protected]>
AuthorDate: Mon Nov 17 17:34:45 2025 +0800
tableau-mysql docs (#3104)
## Versions
- [ ] dev
- [ ] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [ ] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/ecosystem/bi/{tableau.md => tableau-back.md} | 0
docs/ecosystem/bi/tableau.md | 137 ++++++++-------------
.../ecosystem/bi/{tableau.md => tableau-back.md} | 0
.../current/ecosystem/bi/tableau.md | 90 +++++---------
.../version-3.x/ecosystem/bi/tableau.md | 90 +++++---------
.../tableau/AaFwbMOKTo86NaxU54mcVYs1nJd.png | Bin 0 -> 270915 bytes
.../tableau/Am9IbyUo4o30DixVi2ccoZvKn8b.png | Bin 0 -> 563253 bytes
.../tableau/DN47bCp5ZovHCmxH0DAc3fBonR3.png | Bin 0 -> 51465 bytes
.../tableau/FsHmbUOKIoFT5YxWmGecLArLnjd.png | Bin 0 -> 359273 bytes
.../tableau/GPXQbcNUnobHtLx5sIocMHAwn2d.png | Bin 0 -> 158326 bytes
.../tableau/I9SCbCFzoo7TgLx6BP1cHdtRnWc.png | Bin 0 -> 434784 bytes
.../tableau/LJK9bPMptoAGjGxzoCtcY8Agnye.png | Bin 0 -> 86784 bytes
.../tableau/MNb0bjoB2ozn4kxfKx9cVj2hnhb.png | Bin 0 -> 291625 bytes
.../tableau/QSrsbadm0oEiuHxyGv3clFhTnLh.png | Bin 0 -> 239493 bytes
.../tableau/ZJuBbDBc5o2Gnyxhn7icv30xnXw.png | Bin 0 -> 170245 bytes
.../tableau/ZmRDbjws9o5Ampx4YZYcS6Umnqf.png | Bin 0 -> 171648 bytes
versioned_docs/version-3.x/ecosystem/bi/tableau.md | 137 ++++++++-------------
17 files changed, 170 insertions(+), 284 deletions(-)
diff --git a/docs/ecosystem/bi/tableau.md b/docs/ecosystem/bi/tableau-back.md
similarity index 100%
copy from docs/ecosystem/bi/tableau.md
copy to docs/ecosystem/bi/tableau-back.md
diff --git a/docs/ecosystem/bi/tableau.md b/docs/ecosystem/bi/tableau.md
index 5f3c44be389..0544463bd45 100644
--- a/docs/ecosystem/bi/tableau.md
+++ b/docs/ecosystem/bi/tableau.md
@@ -5,42 +5,30 @@
}
---
-VeloDB provides an official Tableau Doris connector. This connector accesses
data based on the MySQL JDBC Driver.
+For enabling Apache Doris access on Tableau, Tableau's official MySQL
connector can meet your needs. This connector uses the MySQL JDBC driver to
access data.
-The connector has been tested by the [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) with a
100% pass rate.
+Through the MySQL connector, Tableau can integrate Apache Doris databases and
tables as data sources. To enable this feature, follow the setup guide below:
-With this connector, Tableau can integrate Apache Doris databases and tables
as data sources. To enable this, follow the setup guide below:
-
-- Install Tableau and the Doris connector
-- Configure an Apache Doris data source in Tableau
-- Build visualizations in Tableau
+- Required setup before use
+- Configuring the Apache Doris data source in Tableau
+- Building visualizations in Tableau
- Connection and usage tips
-- Summary
-
-## Install Tableau and Doris connector
+## Installing Tableau and the JDBC driver
1. Download and install [Tableau
desktop](https://www.tableau.com/products/desktop/download).
-2. Get the
[tableau-doris](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/doris_jdbc-latest.taco)
custom connector connector (doris_jdbc-***.taco).
-3. Get [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
(version 8.3.0).
-4. Locations to place the Connector and JDBC driver
- MacOS:
- - Refer to this path: `~/Documents/My Tableau Repository/Connectors`,
place the `doris_jdbc-latest.taco` custom connector file (if the path does not
exist, create it manually as needed).
- - JDBC driver jar placement path: `~/Library/Tableau/Drivers`
- Windows:
- Assume `tableau_path` is the Tableau installation directory on Windows,
- typically defaults to: `tableau_path = C:\Program Files\Tableau`
- - Refer to this path: `%tableau_path%``\Connectors\`, place the
`doris_jdbc-latest.taco` custom connector file (if the path does not exist,
create it manually as needed).
- - JDBC driver jar placement path: `%tableau_path%\Drivers\`
+2. Obtain [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
(version 8.3.0).
+3. JDBC Driver Placement Path
+ - macOS: JDBC driver JAR file placement path: `~/Library/Tableau/Drivers`
+ - Windows: Assuming `tableau_path` is the Tableau installation directory on
the Windows operating system, generally the default is: `tableau_path =
C:\Program Files\Tableau`, then the JDBC driver JAR file placement path is:
`%tableau_path%\Drivers\`
Next, you can configure a Doris data source in Tableau and start building data
visualizations!
-## Configure a Doris data source in Tableau
-
+## Configuring a Doris Data Source in Tableau
-Now that you have installed and set up the **JDBC and Connector** drivers,
let's look at how to define a data source in Tableau that connects to the tpch
database in Doris.
+Now that you have installed and set up the **JDBC and Connector** drivers,
let's see how to define a data source in Tableau that connects to the tpch
database in Doris.
-1. Gather your connection details
+1. Gathering Your Connection Details
To connect to Apache Doris via JDBC, you need the following information:
@@ -48,90 +36,73 @@ To connect to Apache Doris via JDBC, you need the following
information:
| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
| Server | Database host
| 127.0.1.28 |
| Port | Database MySQL port
| 9030 |
-| Catalog | Doris Catalog, used when querying external tables and
data lakes, set in Advanced | internal |
| Database | Database name
| tpch |
-| Authentication | Choose database authentication method: Username /
Username and Password | Username and Password |
| Username | Username
| testuser |
| Password | Password
| Leave blank |
| Init SQL Statement | Initial SQL statement
| `select * from database.table` |
-2. Launch Tableau. (If you were already running it before placing the
connector, please restart.)
-3. From the left menu, click **More** under the **To a Server** section. In
the list of available connectors, search for **Doris JDBC by VeloDB**:
-
-
-
-4. Click **Doris by VeloDB ，the following dialog will pop up:**
+2. Start Tableau. (If you are already running it, please restart it.)
+3. From the left-hand menu, click **More** under the **To a Server** section.
Search for **mysql** in the list of available connectors.
-
+
-5. Enter the corresponding connection information as prompted in the dialog.
-6. Optional advanced configuration:
+4. Clicking **MySQL** will bring up the following dialog box:
- - You can enter preset SQL in Initial SQL to define the data source
- 
- - In Advanced, you can use Catalog to access data lake data sources; the
default value is internal,
- 
-7. After completing the above input fields, click the **Sign In** button, and
you should see a new Tableau workbook:
- 
+
-Next, you can build some visualizations in Tableau!
+5. Follow the prompts in the dialog box to enter the corresponding connection
information.
+6. After completing the above input boxes, click the **Sign In** button. You
should then see a new Tableau workbook.
+ 
-## Build visualizations in Tableau
+Next, we can build some visualizations in Tableau!
-We choose TPC-H data as the data source, refer to [this
document](../../benchmark/tpch.md) for the construction method of the Doris
TPC-H data source
+## Building Visualizations in Tableau
-Now that we have configured the Doris data source in Tableau, let's visualize
the data
+We've chosen TPC-H data as our data source. For instructions on building a
Doris TPC-H data source, refer to [this document](../../benchmark/tpch.md).
-1. Drag the customer table and orders table to the workbook. And select the
table join field Custkey for them below
+Now that we've configured the Doris data source in Tableau, let's visualize
the data.
-
+1. Drag the `customer` and `orders` tables into the workbook. Then, select the
`Custkey` field for the table association below.
+ 
+2. Drag the `nation` table into the workbook and associate it with the
`customer` table by selecting the `Nationkey` field.
+ 
+3. Now you have linked the `customer`, `orders`, and `nation` tables as data
sources, so you can use this relationship to work on data-related issues.
Select the `Sheet 1` tab at the bottom of the workbook to access the workbench.
+ 
+4. Suppose you want to know the total number of users each year. Drag
OrderDate from orders to the Columns area (a horizontal field), and then drag
customer(count) from customer to Rows. Tableau will generate the following line
chart:
+ 
-2. Drag the nation table to the workbook and select the table join field
Nationkey with the customer table
- 
-3. Now that you have associated the customer table, orders table and nation
table as a data source, you can use this relationship to handle questions about
the data. Select the `Sheet 1` tab at the bottom of the workbook to enter the
workspace.
- 
-4. Suppose you want to know the summary of the number of users per year. Drag
OrderDate from orders to the `Columns` area (horizontal field), and then drag
customer(count) from customer to `Rows`. Tableau will generate the following
line chart:
- 
-
-A simple line chart is completed, but this dataset is automatically generated
by the tpch script and default rules and is not actual data. It is not for
reference and is intended to test availability.
+A simple line chart is now complete. However, this dataset is not real data
and was automatically generated by the tpch script and default rules; it is
intended for testing usability.
5. Suppose you want to know the average order amount (USD) by region (country)
and year:
- - Click the `New Worksheet` tab to create a new sheet
- - Drag Name from the nation table to `Rows`
- - Drag OrderDate from the orders table to `Columns`
+ - Click the `New Worksheet` tab to create a new table
+ - Drag Name from the nation table into `Rows`
+ - Drag OrderDate from the orders table into `Columns`
You should see the following:
-
-6. Note: The `Abc` value is just a placeholder value, because you have not
defined aggregation logic for that mark, so you need to drag a measure onto the
table. Drag Totalprice from the orders table to the middle of the table. Note
that the default calculation is to perform a SUM on Totalprices:
- 
+6. Note: The `Abc` value is just a populated value because you haven't defined
the aggregation logic to this icon, so you need to drag the measure onto the
table. Drag Totalprice from the orders table to the middle of the table. Note
that the default calculation is a SUM on Totalprices:
+ 
7. Click `SUM` and change `Measure` to `Average`.
- 
-8. From the same dropdown menu, select `Format ` and change `Numbers` to
`Currency (Standard)`:
- 
-9. Get a table that meets expectations:
- 
+ 
+8. From the same drop-down menu, select `Format` and change `Numbers` to
`Currency (Standard)`
+ 
+9. You will get a table that meets your expectations.
+ 
-So far, Tableau has been successfully connected to Apache Doris, and data
analysis and visualization dashboard production has been achieved.
+At this point, Tableau has been successfully connected to Apache Doris,
enabling data analysis and dashboard creation.
-## Connection and usage tips
+## Connection and Usage Tips
-**Performance optimization**
+**Performance Optimization**
-- According to actual needs, reasonably create doris databases and tables,
partition and bucket by time, which can effectively reduce predicate filtering
and most data transmission
-- Appropriate data pre-aggregation can be done by creating materialized views
on the Doris side.
-- Set a reasonable refresh plan to balance the computing resource consumption
of refresh and the timeliness of dashboard data
+- Create Doris database tables appropriately based on actual needs,
partitioning and bucketing by time to effectively reduce predicate filtering
and most data transfer.
+- Appropriate data pre-aggregation can be achieved by creating materialized
views on the Doris side.
+- Set a reasonable refresh schedule to balance refresh computational resource
consumption and dashboard data timeliness.
-**Security configuration**
+**Security Configuration**
-- It is recommended to use VPC private connections to avoid security risks
introduced by public network access.
+- It is recommended to use a VPC private connection to avoid security risks
introduced by public network access.
- Configure security groups to restrict access.
-- Enable access methods such as SSL/TLS connections.
-- Refine Doris user account roles and access permissions to avoid excessive
delegation of permissions.
-
-## Summary
-
-This connector simplifies the connection setup process of generic ODBC/JDBC
driver-based connectors and provides a better compatible connector for Apache
Doris. If you encounter any problems when using the connector, please feel free
to contact us on [GitHub](https://github.com/apache/doris/issues).
-
-
+- Enable SSL/TLS connections and other access methods.
+- Fine-tune Doris user account roles and access permissions to avoid excessive
delegation of permissions.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau-back.md
similarity index 100%
copy from
i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
copy to
i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau-back.md
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
index 48f70aef41b..20ba73b5e42 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/tableau.md
@@ -5,75 +5,55 @@
}
---
-VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 MySQL JDBC Driver 实现访问数据。
+对于在 Tableau 上实现 Apache Doris 访问，Tableau 官方的 MySQL 连接器可以满足需求。 该连接器基于 MySQL JDBC
Driver 实现访问数据。
-该连接器通过 [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) 测试，通过率为
100%。
+通过 MySQL 连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-通过这个连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-
-- 安装 Tableau 和 Doris connector
+- 使用前所需的设置
- 在 Tableau 中配置 Apache Doris 数据源
- 在 Tableau 中构建可视化
- 连接和使用技巧
-- 总结
-
-## 安装 Tableau 和 Doris connector
+## 安装 Tableau 和 JDBC 驱动
1. 下载并安装 [Tableau desktop](https://www.tableau.com/products/desktop/download)。
-2. 获取
[tableau-doris](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/doris_jdbc-latest.taco)
自定义连接器 connector（doris_jdbc-***.taco）。
-3. 获取 [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
（版本为 8.3.0）。
-4. Connector 和 JDBC 驱动放置路径
- MacOS:
- - 参考此处路径：`~/Documents/My Tableau Repository/Connectors`，放置
`doris_jdbc-latest.taco` 自定义连接器文件（如果路径不存在，按需手动创建）。
- - JDBC 驱动 jar 包放置路径：`~/Library/Tableau/Drivers`
- Windows:
- 假定 `tableau_path` 为 windows 操作系统中 tableau 的安装目录，
- 一般默认为：`tableau_path = C:\Program Files\Tableau`
- - 参考此处路径：`%tableau_path%``\Connectors\`，放置 `doris_jdbc-latest.taco`
自定义连接器文件（如果路径不存在，按需手动创建）。
- - JDBC 驱动 jar 包放置路径：`%tableau_path%\Drivers\`
+2. 获取 [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
（版本为 8.3.0）。
+3. JDBC 驱动放置路径
+ - MacOS：JDBC 驱动 jar 包放置路径：`~/Library/Tableau/Drivers`
+ - Windows：假定 `tableau_path` 为 windows 操作系统中 tableau
的安装目录，一般默认为：`tableau_path = C:\Program Files\Tableau` 则，JDBC 驱动 jar
包放置路径：`%tableau_path%\Drivers\`
接下来，就可以在 Tableau 中配置一个 Doris 数据源并开始构建数据可视化！
## 在 Tableau 中配置 Doris 数据源
-
现在您已安装并设置了 **JDBC 和 Connector** 驱动程序，让我们来看一下如何在 Tableau 中定义一个连接到 Doris 中 tpch
数据库的数据源。
1. 收集您的连接详细信息
要通过 JDBC 连接到 Apache Doris，您需要以下信息：
-| 参数 | 含义
| 示例 |
-| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
-| Server | 数据库 host
| 127.0.1.28 |
-| Port | 数据库 MySQL 端口
| 9030 |
-| Catalog | Doris Catalog，查询外表和数据湖时使用，在高级配置（Advanced）中设置 |
internal |
-| Database | 数据库名
| tpch |
-| Authentication | 选择数据库访问权限方式，可选择：Username / Username and Password
| Username and Password |
-| Username | 用户名
| testuser |
-| Password | 密码
| 留空 |
+| 参数 | 含义
| 示例 |
+| -------------------- |
-------------------------------------------------------------------- |
------------------------- |
+| Server | 数据库 host
| 127.0.1.28 |
+| Port | 数据库 MySQL 端口
| 9030 |
+| Database | 数据库名
| tpch |
+| Username | 用户名
| testuser |
+| Password | 密码
| |
| Init SQL Statement | 初始化 SQL 语句
| `select * from database.table` |
-2. 启动 Tableau。（如果您在放置 connector 之前已经在运行它，请重新启动。）
-3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **Doris JDBC by
VeloDB**：
+2. 启动 Tableau。（如果您已经在运行它，请重新启动。）
+3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **mysql **
-
+
-4. 点击 **Doris by VeloDB ，将会弹出以下对话框：**
+4. 点击 **MySql **，将会弹出以下对话框：
-
+
5. 按照对话框提示输入相应的连接信息。
-6. 可选进阶配置：
-
- - 可以在 Initial SQL 中输入预置 SQL 来定义数据源
- 
- - 在 Advanced 中，可以使用 Catalog 来实现数据湖数据源的访问，默认值为 internal,
- 
-7. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
- 
+6. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
+ 
接下来，就可以在 Tableau 中构建一些可视化了！
@@ -84,34 +64,31 @@ VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 My
现在我们在 Tableau 中配置了 Doris 数据源，让我们可视化数据
1. 将 customer 表 和 orders 表拖到工作簿中。并在下方为他们选定表关联字段 Custkey
-
-
-
+ 
2. 将 nation 表拖到工作簿中 并 与 customer 表 选定表关联字段 Nationkey
- 
+ 
3. 现在您已经将 customer 表、 orders 表 和 nation 表关联为数据源，因此您可以利用此关系处理有关数据的问题。选择工作簿底部的
`Sheet 1` 选项卡，进入工作台。
- 
+ 
4. 假设您想知道每年的用户量汇总。将 OrderDate 从 orders 拖动到 `Columns` 区域（水平字段），然后将
customer(count) 从 customer 拖到 `Rows`。Tableau 将生成以下折线图：
- 
+ 
一张简单的折线图就制作完成了，但该数据集是通过 tpch 脚本和默认规则自动生成的非实际数据，不具备参考性，旨在测试可用与否。
-5. 假设您想知道按地域（国别）和年份计算的平均订单金额（美元）：
+5. 假设您想知道按地域（国别）和 年份计算的平均订单金额（美元）：
- 点击 `New Worksheet` 选项卡创建新表
- 将 Name 从 nation 表拖入 `Rows`
- 将 OrderDate 从 orders 表 拖入 `Columns`
您应该会看到以下内容：
-
6. 注意：`Abc` 值只是填充值，因为您未将聚合逻辑定义到该图标，因此需要您拖动度量到表格上。将 Totalprice 从 orders
表拖到表格中间。请注意默认的计算是对 Totalprices 进行 SUM：
- 
+ 
7. 点击 `SUM` 并将 `Measure` 更改为 `Average`。
- 
+ 
8. 从同一下拉菜单中选择 `Format ` 将 `Numbers` 更改为 `Currency (Standard)`：
- 
+ 
9. 得到一张符合预期的表格：
- 
+ 
至此，已经成功将 Tableau 连接到 Apache Doris，并实现了数据分析和可视化看板制作。
@@ -129,8 +106,3 @@ VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 My
- 配置 安全组 限制访问。
- 启用 SSL/TLS 连接等访问方式。
- 细化 Doris 用户账号角色和访问权限，避免过度下放权限。
-
-## 总结
-
-这个连接器简化了通用 ODBC/JDBC 驱动程序的连接器 连接设置流程，为 Apache Doris
提供了更好兼容的连接器。如果您在使用连接器时遇到任何问题，请随时在
[GitHub](https://github.com/apache/doris/issues) 联系我们。
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/tableau.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/tableau.md
index 48f70aef41b..3849bb2f7a7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/tableau.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/tableau.md
@@ -5,75 +5,55 @@
}
---
-VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 MySQL JDBC Driver 实现访问数据。
+对于在 Tableau 上实现 Apache Doris 访问，Tableau 官方的 MySQL 连接器可以满足需求。 该连接器基于 MySQL JDBC
Driver 实现访问数据。
-该连接器通过 [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) 测试，通过率为
100%。
+通过 MySQL 连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-通过这个连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-
-- 安装 Tableau 和 Doris connector
+- 使用前所需的设置
- 在 Tableau 中配置 Apache Doris 数据源
- 在 Tableau 中构建可视化
- 连接和使用技巧
-- 总结
-
-## 安装 Tableau 和 Doris connector
+## 安装 Tableau 和 JDBC 驱动
1. 下载并安装 [Tableau desktop](https://www.tableau.com/products/desktop/download)。
-2. 获取
[tableau-doris](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/doris_jdbc-latest.taco)
自定义连接器 connector（doris_jdbc-***.taco）。
-3. 获取 [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
（版本为 8.3.0）。
-4. Connector 和 JDBC 驱动放置路径
- MacOS:
- - 参考此处路径：`~/Documents/My Tableau Repository/Connectors`，放置
`doris_jdbc-latest.taco` 自定义连接器文件（如果路径不存在，按需手动创建）。
- - JDBC 驱动 jar 包放置路径：`~/Library/Tableau/Drivers`
- Windows:
- 假定 `tableau_path` 为 windows 操作系统中 tableau 的安装目录，
- 一般默认为：`tableau_path = C:\Program Files\Tableau`
- - 参考此处路径：`%tableau_path%``\Connectors\`，放置 `doris_jdbc-latest.taco`
自定义连接器文件（如果路径不存在，按需手动创建）。
- - JDBC 驱动 jar 包放置路径：`%tableau_path%\Drivers\`
+2. 获取 [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
（版本为 8.3.0）。
+3. JDBC 驱动放置路径
+ - MacOS：JDBC 驱动 jar 包放置路径：`~/Library/Tableau/Drivers`
+ - Windows：假定 `tableau_path` 为 windows 操作系统中 tableau
的安装目录，一般默认为：`tableau_path = C:\Program Files\Tableau` 则，JDBC 驱动 jar
包放置路径：`%tableau_path%\Drivers\`
接下来，就可以在 Tableau 中配置一个 Doris 数据源并开始构建数据可视化！
## 在 Tableau 中配置 Doris 数据源
-
现在您已安装并设置了 **JDBC 和 Connector** 驱动程序，让我们来看一下如何在 Tableau 中定义一个连接到 Doris 中 tpch
数据库的数据源。
1. 收集您的连接详细信息
要通过 JDBC 连接到 Apache Doris，您需要以下信息：
-| 参数 | 含义
| 示例 |
-| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
-| Server | 数据库 host
| 127.0.1.28 |
-| Port | 数据库 MySQL 端口
| 9030 |
-| Catalog | Doris Catalog，查询外表和数据湖时使用，在高级配置（Advanced）中设置 |
internal |
-| Database | 数据库名
| tpch |
-| Authentication | 选择数据库访问权限方式，可选择：Username / Username and Password
| Username and Password |
-| Username | 用户名
| testuser |
-| Password | 密码
| 留空 |
+| 参数 | 含义
| 示例 |
+| -------------------- |
-------------------------------------------------------------------- |
------------------------- |
+| Server | 数据库 host
| 127.0.1.28 |
+| Port | 数据库 MySQL 端口
| 9030 |
+| Database | 数据库名
| tpch |
+| Username | 用户名
| testuser |
+| Password | 密码
| |
| Init SQL Statement | 初始化 SQL 语句
| `select * from database.table` |
-2. 启动 Tableau。（如果您在放置 connector 之前已经在运行它，请重新启动。）
-3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **Doris JDBC by
VeloDB**：
+2. 启动 Tableau。（如果您已经在运行它，请重新启动。）
+3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **mysql **
-
+
-4. 点击 **Doris by VeloDB ，将会弹出以下对话框：**
+4. 点击 **MySql **，将会弹出以下对话框：
-
+
5. 按照对话框提示输入相应的连接信息。
-6. 可选进阶配置：
-
- - 可以在 Initial SQL 中输入预置 SQL 来定义数据源
- 
- - 在 Advanced 中，可以使用 Catalog 来实现数据湖数据源的访问，默认值为 internal,
- 
-7. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
- 
+6. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
+ 
接下来，就可以在 Tableau 中构建一些可视化了！
@@ -84,34 +64,31 @@ VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 My
现在我们在 Tableau 中配置了 Doris 数据源，让我们可视化数据
1. 将 customer 表 和 orders 表拖到工作簿中。并在下方为他们选定表关联字段 Custkey
-
-
-
+ 
2. 将 nation 表拖到工作簿中 并 与 customer 表 选定表关联字段 Nationkey
- 
+ 
3. 现在您已经将 customer 表、 orders 表 和 nation 表关联为数据源，因此您可以利用此关系处理有关数据的问题。选择工作簿底部的
`Sheet 1` 选项卡，进入工作台。
- 
+ 
4. 假设您想知道每年的用户量汇总。将 OrderDate 从 orders 拖动到 `Columns` 区域（水平字段），然后将
customer(count) 从 customer 拖到 `Rows`。Tableau 将生成以下折线图：
- 
+ 
一张简单的折线图就制作完成了，但该数据集是通过 tpch 脚本和默认规则自动生成的非实际数据，不具备参考性，旨在测试可用与否。
-5. 假设您想知道按地域（国别）和年份计算的平均订单金额（美元）：
+5. 假设您想知道按地域（国别）和 年份计算的平均订单金额（美元）：
- 点击 `New Worksheet` 选项卡创建新表
- 将 Name 从 nation 表拖入 `Rows`
- 将 OrderDate 从 orders 表 拖入 `Columns`
您应该会看到以下内容：
-
6. 注意：`Abc` 值只是填充值，因为您未将聚合逻辑定义到该图标，因此需要您拖动度量到表格上。将 Totalprice 从 orders
表拖到表格中间。请注意默认的计算是对 Totalprices 进行 SUM：
- 
+ 
7. 点击 `SUM` 并将 `Measure` 更改为 `Average`。
- 
+ 
8. 从同一下拉菜单中选择 `Format ` 将 `Numbers` 更改为 `Currency (Standard)`：
- 
+ 
9. 得到一张符合预期的表格：
- 
+ 
至此，已经成功将 Tableau 连接到 Apache Doris，并实现了数据分析和可视化看板制作。
@@ -129,8 +106,3 @@ VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 My
- 配置 安全组 限制访问。
- 启用 SSL/TLS 连接等访问方式。
- 细化 Doris 用户账号角色和访问权限，避免过度下放权限。
-
-## 总结
-
-这个连接器简化了通用 ODBC/JDBC 驱动程序的连接器 连接设置流程，为 Apache Doris
提供了更好兼容的连接器。如果您在使用连接器时遇到任何问题，请随时在
[GitHub](https://github.com/apache/doris/issues) 联系我们。
-
diff --git a/static/images/ecomsystem/tableau/AaFwbMOKTo86NaxU54mcVYs1nJd.png
b/static/images/ecomsystem/tableau/AaFwbMOKTo86NaxU54mcVYs1nJd.png
new file mode 100644
index 00000000000..1bb061de039
Binary files /dev/null and
b/static/images/ecomsystem/tableau/AaFwbMOKTo86NaxU54mcVYs1nJd.png differ
diff --git a/static/images/ecomsystem/tableau/Am9IbyUo4o30DixVi2ccoZvKn8b.png
b/static/images/ecomsystem/tableau/Am9IbyUo4o30DixVi2ccoZvKn8b.png
new file mode 100644
index 00000000000..9a5d8e7a40b
Binary files /dev/null and
b/static/images/ecomsystem/tableau/Am9IbyUo4o30DixVi2ccoZvKn8b.png differ
diff --git a/static/images/ecomsystem/tableau/DN47bCp5ZovHCmxH0DAc3fBonR3.png
b/static/images/ecomsystem/tableau/DN47bCp5ZovHCmxH0DAc3fBonR3.png
new file mode 100644
index 00000000000..bc64c98d8d2
Binary files /dev/null and
b/static/images/ecomsystem/tableau/DN47bCp5ZovHCmxH0DAc3fBonR3.png differ
diff --git a/static/images/ecomsystem/tableau/FsHmbUOKIoFT5YxWmGecLArLnjd.png
b/static/images/ecomsystem/tableau/FsHmbUOKIoFT5YxWmGecLArLnjd.png
new file mode 100644
index 00000000000..735c53c13df
Binary files /dev/null and
b/static/images/ecomsystem/tableau/FsHmbUOKIoFT5YxWmGecLArLnjd.png differ
diff --git a/static/images/ecomsystem/tableau/GPXQbcNUnobHtLx5sIocMHAwn2d.png
b/static/images/ecomsystem/tableau/GPXQbcNUnobHtLx5sIocMHAwn2d.png
new file mode 100644
index 00000000000..fb8c5eafcb4
Binary files /dev/null and
b/static/images/ecomsystem/tableau/GPXQbcNUnobHtLx5sIocMHAwn2d.png differ
diff --git a/static/images/ecomsystem/tableau/I9SCbCFzoo7TgLx6BP1cHdtRnWc.png
b/static/images/ecomsystem/tableau/I9SCbCFzoo7TgLx6BP1cHdtRnWc.png
new file mode 100644
index 00000000000..59a49f74f01
Binary files /dev/null and
b/static/images/ecomsystem/tableau/I9SCbCFzoo7TgLx6BP1cHdtRnWc.png differ
diff --git a/static/images/ecomsystem/tableau/LJK9bPMptoAGjGxzoCtcY8Agnye.png
b/static/images/ecomsystem/tableau/LJK9bPMptoAGjGxzoCtcY8Agnye.png
new file mode 100644
index 00000000000..c31d1c259c7
Binary files /dev/null and
b/static/images/ecomsystem/tableau/LJK9bPMptoAGjGxzoCtcY8Agnye.png differ
diff --git a/static/images/ecomsystem/tableau/MNb0bjoB2ozn4kxfKx9cVj2hnhb.png
b/static/images/ecomsystem/tableau/MNb0bjoB2ozn4kxfKx9cVj2hnhb.png
new file mode 100644
index 00000000000..6f6a6c28840
Binary files /dev/null and
b/static/images/ecomsystem/tableau/MNb0bjoB2ozn4kxfKx9cVj2hnhb.png differ
diff --git a/static/images/ecomsystem/tableau/QSrsbadm0oEiuHxyGv3clFhTnLh.png
b/static/images/ecomsystem/tableau/QSrsbadm0oEiuHxyGv3clFhTnLh.png
new file mode 100644
index 00000000000..d385d3d3a44
Binary files /dev/null and
b/static/images/ecomsystem/tableau/QSrsbadm0oEiuHxyGv3clFhTnLh.png differ
diff --git a/static/images/ecomsystem/tableau/ZJuBbDBc5o2Gnyxhn7icv30xnXw.png
b/static/images/ecomsystem/tableau/ZJuBbDBc5o2Gnyxhn7icv30xnXw.png
new file mode 100644
index 00000000000..22361b77962
Binary files /dev/null and
b/static/images/ecomsystem/tableau/ZJuBbDBc5o2Gnyxhn7icv30xnXw.png differ
diff --git a/static/images/ecomsystem/tableau/ZmRDbjws9o5Ampx4YZYcS6Umnqf.png
b/static/images/ecomsystem/tableau/ZmRDbjws9o5Ampx4YZYcS6Umnqf.png
new file mode 100644
index 00000000000..f8208dd1154
Binary files /dev/null and
b/static/images/ecomsystem/tableau/ZmRDbjws9o5Ampx4YZYcS6Umnqf.png differ
diff --git a/versioned_docs/version-3.x/ecosystem/bi/tableau.md
b/versioned_docs/version-3.x/ecosystem/bi/tableau.md
index 5f3c44be389..692a1198567 100644
--- a/versioned_docs/version-3.x/ecosystem/bi/tableau.md
+++ b/versioned_docs/version-3.x/ecosystem/bi/tableau.md
@@ -5,42 +5,30 @@
}
---
-VeloDB provides an official Tableau Doris connector. This connector accesses
data based on the MySQL JDBC Driver.
+For enabling Apache Doris access on Tableau, Tableau's official MySQL
connector can meet your needs. This connector uses the MySQL JDBC driver to
access data.
-The connector has been tested by the [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) with a
100% pass rate.
+Through the MySQL connector, Tableau can integrate Apache Doris databases and
tables as data sources. To enable this feature, follow the setup guide below:
-With this connector, Tableau can integrate Apache Doris databases and tables
as data sources. To enable this, follow the setup guide below:
-
-- Install Tableau and the Doris connector
-- Configure an Apache Doris data source in Tableau
-- Build visualizations in Tableau
+- Required setup before use
+- Configuring the Apache Doris data source in Tableau
+- Building visualizations in Tableau
- Connection and usage tips
-- Summary
-
-## Install Tableau and Doris connector
+## Installing Tableau and the JDBC driver
1. Download and install [Tableau
desktop](https://www.tableau.com/products/desktop/download).
-2. Get the
[tableau-doris](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/doris_jdbc-latest.taco)
custom connector connector (doris_jdbc-***.taco).
-3. Get [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
(version 8.3.0).
-4. Locations to place the Connector and JDBC driver
- MacOS:
- - Refer to this path: `~/Documents/My Tableau Repository/Connectors`,
place the `doris_jdbc-latest.taco` custom connector file (if the path does not
exist, create it manually as needed).
- - JDBC driver jar placement path: `~/Library/Tableau/Drivers`
- Windows:
- Assume `tableau_path` is the Tableau installation directory on Windows,
- typically defaults to: `tableau_path = C:\Program Files\Tableau`
- - Refer to this path: `%tableau_path%``\Connectors\`, place the
`doris_jdbc-latest.taco` custom connector file (if the path does not exist,
create it manually as needed).
- - JDBC driver jar placement path: `%tableau_path%\Drivers\`
+2. Obtain [MySQL
JDBC](https://velodb-bi-connector-1316291683.cos.ap-hongkong.myqcloud.com/Tableau/latest/mysql-connector-j-8.3.0.jar)
(version 8.3.0).
+3. JDBC Driver Placement Path
+ - macOS: JDBC driver JAR file placement path: `~/Library/Tableau/Drivers`
+ - Windows: Assuming `tableau_path` is the Tableau installation directory
on the Windows operating system, generally the default is: `tableau_path =
C:\Program Files\Tableau`, then the JDBC driver JAR file placement path is:
`%tableau_path%\Drivers\`
Next, you can configure a Doris data source in Tableau and start building data
visualizations!
-## Configure a Doris data source in Tableau
-
+## Configuring a Doris Data Source in Tableau
-Now that you have installed and set up the **JDBC and Connector** drivers,
let's look at how to define a data source in Tableau that connects to the tpch
database in Doris.
+Now that you have installed and set up the **JDBC and Connector** drivers,
let's see how to define a data source in Tableau that connects to the tpch
database in Doris.
-1. Gather your connection details
+1. Gathering Your Connection Details
To connect to Apache Doris via JDBC, you need the following information:
@@ -48,90 +36,73 @@ To connect to Apache Doris via JDBC, you need the following
information:
| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
| Server | Database host
| 127.0.1.28 |
| Port | Database MySQL port
| 9030 |
-| Catalog | Doris Catalog, used when querying external tables and
data lakes, set in Advanced | internal |
| Database | Database name
| tpch |
-| Authentication | Choose database authentication method: Username /
Username and Password | Username and Password |
| Username | Username
| testuser |
| Password | Password
| Leave blank |
| Init SQL Statement | Initial SQL statement
| `select * from database.table` |
-2. Launch Tableau. (If you were already running it before placing the
connector, please restart.)
-3. From the left menu, click **More** under the **To a Server** section. In
the list of available connectors, search for **Doris JDBC by VeloDB**:
-
-
-
-4. Click **Doris by VeloDB ，the following dialog will pop up:**
+2. Start Tableau. (If you are already running it, please restart it.)
+3. From the left-hand menu, click **More** under the **To a Server** section.
Search for **mysql** in the list of available connectors.
-
+
-5. Enter the corresponding connection information as prompted in the dialog.
-6. Optional advanced configuration:
+4. Clicking **MySQL** will bring up the following dialog box:
- - You can enter preset SQL in Initial SQL to define the data source
- 
- - In Advanced, you can use Catalog to access data lake data sources; the
default value is internal,
- 
-7. After completing the above input fields, click the **Sign In** button, and
you should see a new Tableau workbook:
- 
+
-Next, you can build some visualizations in Tableau!
+5. Follow the prompts in the dialog box to enter the corresponding connection
information.
+6. After completing the above input boxes, click the **Sign In** button. You
should then see a new Tableau workbook.
+ 
-## Build visualizations in Tableau
+Next, we can build some visualizations in Tableau!
-We choose TPC-H data as the data source, refer to [this
document](../../benchmark/tpch.md) for the construction method of the Doris
TPC-H data source
+## Building Visualizations in Tableau
-Now that we have configured the Doris data source in Tableau, let's visualize
the data
+We've chosen TPC-H data as our data source. For instructions on building a
Doris TPC-H data source, refer to [this document](../../benchmark/tpch.md).
-1. Drag the customer table and orders table to the workbook. And select the
table join field Custkey for them below
+Now that we've configured the Doris data source in Tableau, let's visualize
the data.
-
+1. Drag the `customer` and `orders` tables into the workbook. Then, select the
`Custkey` field for the table association below.
+ 
+2. Drag the `nation` table into the workbook and associate it with the
`customer` table by selecting the `Nationkey` field.
+ 
+3. Now you have linked the `customer`, `orders`, and `nation` tables as data
sources, so you can use this relationship to work on data-related issues.
Select the `Sheet 1` tab at the bottom of the workbook to access the workbench.
+ 
+4. Suppose you want to know the total number of users each year. Drag
OrderDate from orders to the Columns area (a horizontal field), and then drag
customer(count) from customer to Rows. Tableau will generate the following line
chart:
+ 
-2. Drag the nation table to the workbook and select the table join field
Nationkey with the customer table
- 
-3. Now that you have associated the customer table, orders table and nation
table as a data source, you can use this relationship to handle questions about
the data. Select the `Sheet 1` tab at the bottom of the workbook to enter the
workspace.
- 
-4. Suppose you want to know the summary of the number of users per year. Drag
OrderDate from orders to the `Columns` area (horizontal field), and then drag
customer(count) from customer to `Rows`. Tableau will generate the following
line chart:
- 
-
-A simple line chart is completed, but this dataset is automatically generated
by the tpch script and default rules and is not actual data. It is not for
reference and is intended to test availability.
+A simple line chart is now complete. However, this dataset is not real data
and was automatically generated by the tpch script and default rules; it is
intended for testing usability.
5. Suppose you want to know the average order amount (USD) by region (country)
and year:
- - Click the `New Worksheet` tab to create a new sheet
- - Drag Name from the nation table to `Rows`
- - Drag OrderDate from the orders table to `Columns`
+ - Click the `New Worksheet` tab to create a new table
+ - Drag Name from the nation table into `Rows`
+ - Drag OrderDate from the orders table into `Columns`
You should see the following:
-
-6. Note: The `Abc` value is just a placeholder value, because you have not
defined aggregation logic for that mark, so you need to drag a measure onto the
table. Drag Totalprice from the orders table to the middle of the table. Note
that the default calculation is to perform a SUM on Totalprices:
- 
+6. Note: The `Abc` value is just a populated value because you haven't defined
the aggregation logic to this icon, so you need to drag the measure onto the
table. Drag Totalprice from the orders table to the middle of the table. Note
that the default calculation is a SUM on Totalprices:
+ 
7. Click `SUM` and change `Measure` to `Average`.
- 
-8. From the same dropdown menu, select `Format ` and change `Numbers` to
`Currency (Standard)`:
- 
-9. Get a table that meets expectations:
- 
+ 
+8. From the same drop-down menu, select `Format` and change `Numbers` to
`Currency (Standard)`
+ 
+9. You will get a table that meets your expectations.
+ 
-So far, Tableau has been successfully connected to Apache Doris, and data
analysis and visualization dashboard production has been achieved.
+At this point, Tableau has been successfully connected to Apache Doris,
enabling data analysis and dashboard creation.
-## Connection and usage tips
+## Connection and Usage Tips
-**Performance optimization**
+**Performance Optimization**
-- According to actual needs, reasonably create doris databases and tables,
partition and bucket by time, which can effectively reduce predicate filtering
and most data transmission
-- Appropriate data pre-aggregation can be done by creating materialized views
on the Doris side.
-- Set a reasonable refresh plan to balance the computing resource consumption
of refresh and the timeliness of dashboard data
+- Create Doris database tables appropriately based on actual needs,
partitioning and bucketing by time to effectively reduce predicate filtering
and most data transfer.
+- Appropriate data pre-aggregation can be achieved by creating materialized
views on the Doris side.
+- Set a reasonable refresh schedule to balance refresh computational resource
consumption and dashboard data timeliness.
-**Security configuration**
+**Security Configuration**
-- It is recommended to use VPC private connections to avoid security risks
introduced by public network access.
+- It is recommended to use a VPC private connection to avoid security risks
introduced by public network access.
- Configure security groups to restrict access.
-- Enable access methods such as SSL/TLS connections.
-- Refine Doris user account roles and access permissions to avoid excessive
delegation of permissions.
-
-## Summary
-
-This connector simplifies the connection setup process of generic ODBC/JDBC
driver-based connectors and provides a better compatible connector for Apache
Doris. If you encounter any problems when using the connector, please feel free
to contact us on [GitHub](https://github.com/apache/doris/issues).
-
-
+- Enable SSL/TLS connections and other access methods.
+- Fine-tune Doris user account roles and access permissions to avoid excessive
delegation of permissions.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
