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 aa10b75b245 [BI](tableau) tableau connector doc (#2984)
aa10b75b245 is described below
commit aa10b75b245f27200f17d9b406ca8e512cc7bba9
Author: catpineapple <[email protected]>
AuthorDate: Mon Oct 20 11:28:09 2025 +0800
[BI](tableau) tableau connector doc (#2984)
---
docs/ecosystem/bi/tableau.md | 141 ++++++++++++++++++---
.../current/ecosystem/bi/tableau.md | 138 +++++++++++++++++---
.../version-3.x/ecosystem/bi/tableau.md | 139 +++++++++++++++++---
static/images/ecomsystem/tableau/p01.png | Bin 0 -> 153777 bytes
static/images/ecomsystem/tableau/p02.png | Bin 0 -> 30853 bytes
static/images/ecomsystem/tableau/p03.png | Bin 0 -> 22671 bytes
static/images/ecomsystem/tableau/p04.png | Bin 0 -> 20160 bytes
static/images/ecomsystem/tableau/p05.png | Bin 0 -> 72710 bytes
static/images/ecomsystem/tableau/p06.png | Bin 0 -> 151433 bytes
static/images/ecomsystem/tableau/p07.png | Bin 0 -> 147281 bytes
static/images/ecomsystem/tableau/p08.png | Bin 0 -> 123233 bytes
static/images/ecomsystem/tableau/p09.png | Bin 0 -> 160280 bytes
static/images/ecomsystem/tableau/p10.png | Bin 0 -> 242186 bytes
static/images/ecomsystem/tableau/p11.png | Bin 0 -> 388946 bytes
static/images/ecomsystem/tableau/p12.png | Bin 0 -> 214882 bytes
static/images/ecomsystem/tableau/p13.png | Bin 0 -> 125189 bytes
static/images/ecomsystem/tableau/p14.png | Bin 0 -> 204092 bytes
versioned_docs/version-3.x/ecosystem/bi/tableau.md | 141 ++++++++++++++++++---
18 files changed, 487 insertions(+), 72 deletions(-)
diff --git a/docs/ecosystem/bi/tableau.md b/docs/ecosystem/bi/tableau.md
index cc7bd9d8f6c..5f3c44be389 100644
--- a/docs/ecosystem/bi/tableau.md
+++ b/docs/ecosystem/bi/tableau.md
@@ -5,28 +5,133 @@
}
---
-## Introduction
-Tableau is a lightweight data visualization analysis platform that combines
data operations with beautiful charts perfectly. It seamlessly combines data
computation with visually appealing charts, requiring no coding from the user.
By simply dragging and dropping, users can quickly gain insights into the data.
They can explore different views and even easily combine multiple data sources
to complete tasks such as data visualization, exploration, and analysis.
-## Prerequisites
-Regardless of whether your Mac is based on an Intel chips or Apple Silicon
Chips, for Tableau Desktop on Mac, you need to download and install the Intel
version. This is to ensure compatibility with the MySQL driver. You can select
and download the Intel version from the [Support
Releases](https://www.tableau.com/support/releases) page.
+VeloDB provides an official Tableau Doris connector. This connector accesses
data based on the MySQL JDBC Driver.
-## Driver Installation
-1. iODBC Installation
- 1. Close Tableau Desktop
- 2. Download the latest Driver Manager (mxkozzz.dmg) from the official
[iODBC
website](https://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X)
- 3. Install the downloaded dmg file
-2. Install the MySQL driver
+The connector has been tested by the [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) with a
100% pass rate.
-When choosing the ODBC driver for MySQL to connect to Doris, you should
install the MySQL 5.x ODBC driver. Using the latest MySQL driver may result in
an "Unsupported command" error when connecting to Doris.
-## Connection Configuration and Usage
-1. Click the Tableau Desktop home page and select MySQL at the connection data
source
+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
+- Connection and usage tips
+- Summary
-2. Fill in the Doris server address, port and other relevant information, and
click sigin in button after correctly filling
+## Install Tableau and Doris connector
- 
-3. After entering Tableau, select the corresponding library table to carry out
the relevant compass processing.
+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\`
+
+Next, you can configure a Doris data source in Tableau and start building data
visualizations!
+
+## Configure 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.
+
+1. Gather your connection details
+
+To connect to Apache Doris via JDBC, you need the following information:
+
+| Parameter | Meaning
| Example |
+| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
+| 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:**
+
+
+
+5. Enter the corresponding connection information as prompted in the dialog.
+6. Optional advanced configuration:
+
+ - 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!
+
+## Build 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
+
+Now that we have configured the Doris data source in Tableau, let's visualize
the data
+
+1. Drag the customer table and orders table to the workbook. And select the
table join field Custkey for them below
+
+
+
+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.
+
+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`
+
+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:
+ 
+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:
+ 
+
+So far, Tableau has been successfully connected to Apache Doris, and data
analysis and visualization dashboard production has been achieved.
+
+## Connection and usage tips
+
+**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
+
+**Security configuration**
+
+- It is recommended to use VPC private connections 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).
+
- 
\ No newline at end of file
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 357b549ec43..48f70aef41b 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,30 +5,132 @@
}
---
-## 介绍
-Tableau
是一款轻量级数据可视化分析平台，它将数据运算与美观的图表完美地结合在一起，不要求用户编写代码，仅仅通过拖拽的方式就可以快速洞察数据；探索不同的视图，甚至可以轻松地将多个数据源组合在一起，完成数据展示、探索和分析工作。
+VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 MySQL JDBC Driver 实现访问数据。
-## 前置条件
-无论你的 Mac 采用 Intel 还是 Apple Silicon 架构，Tableau Desktop Mac 版需下载安装 Intel
版本，这是为了保证与 MySQL 驱动的兼容性。可通过 [Support
Releases](https://www.tableau.com/support/releases)页面选择并下载 Intel 版本。
+该连接器通过 [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) 测试，通过率为
100%。
-## 驱动安装
-1. iODBC 安装
- 1. 关闭 Tableau Desktop
- 2. 从 [iODBC
官网](https://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X)下载最新的
Driver Manager（mxkozzz.dmg）
- 3. 安装下载好的 dmg 文件
+通过这个连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-2. MySQL 驱动安装
+- 安装 Tableau 和 Doris connector
+- 在 Tableau 中配置 Apache Doris 数据源
+- 在 Tableau 中构建可视化
+- 连接和使用技巧
+- 总结
-选择 MySQL 5.x 的 ODBC 驱动进行安装；请勿使用最新版本的 MySQL ODBC 驱动，否则在连接 Doris
时会出现“Unsupported command”错误。
-## 连接配置与使用
-1. 点击 Tableau Desktop 主页，在连接数据源处选择 MySQL
+## 安装 Tableau 和 Doris connector
- 
-2. 填写 Doris 服务器地址，端口等相关信息，正确填写后点击登录即可。
+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\`
- 
+接下来，就可以在 Tableau 中配置一个 Doris 数据源并开始构建数据可视化！
-3. 进入 Tableau 后选择对应的库表即可进行相关的罗盘处理。
+## 在 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 | 密码
| 留空 |
+| Init SQL Statement | 初始化 SQL 语句
| `select * from database.table` |
+
+
+2. 启动 Tableau。（如果您在放置 connector 之前已经在运行它，请重新启动。）
+3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **Doris JDBC by
VeloDB**：
+
+
+
+4. 点击 **Doris by VeloDB ，将会弹出以下对话框：**
+
+
+
+5. 按照对话框提示输入相应的连接信息。
+6. 可选进阶配置：
+
+ - 可以在 Initial SQL 中输入预置 SQL 来定义数据源
+ 
+ - 在 Advanced 中，可以使用 Catalog 来实现数据湖数据源的访问，默认值为 internal,
+ 
+7. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
+ 
+
+接下来，就可以在 Tableau 中构建一些可视化了！
+
+## 在 Tableau 中构建可视化
+
+我们选择 TPC-H 数据作为数据源，Doris TPC-H 数据源构建方式参考[此文档](../../benchmark/tpch.md)
+
+现在我们在 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. 假设您想知道按地域（国别）和年份计算的平均订单金额（美元）：
+ - 点击 `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，并实现了数据分析和可视化看板制作。
+
+## 连接和使用技巧
+
+**性能优化**
+
+- 根据实际需求，合理创建 doris 库表，按时间分区分桶，可有效减少谓词过滤和大部分数据传输
+- 适当的数据预聚合，可以通过 Doris 侧创建物化视图的方式。
+- 设置合理的刷新计划，均衡刷新的计算资源消耗 和 看板数据时效性
+
+**安全配置**
+
+- 建议使用 VPC 私有连接，避免公网访问引入安全风险。
+- 配置 安全组 限制访问。
+- 启用 SSL/TLS 连接等访问方式。
+- 细化 Doris 用户账号角色和访问权限，避免过度下放权限。
+
+## 总结
+
+这个连接器简化了通用 ODBC/JDBC 驱动程序的连接器 连接设置流程，为 Apache Doris
提供了更好兼容的连接器。如果您在使用连接器时遇到任何问题，请随时在
[GitHub](https://github.com/apache/doris/issues) 联系我们。
- 
\ No newline at end of file
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 1b229c35b90..48f70aef41b 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,29 +5,132 @@
}
---
-## 介绍
-Tableau
是一款轻量级数据可视化分析平台，它将数据运算与美观的图表完美地结合在一起，不要求用户编写代码，仅仅通过拖拽的方式就可以快速洞察数据；探索不同的视图，甚至可以轻松地将多个数据源组合在一起，完成数据展示、探索和分析工作。
-## 前置条件
-无论你的 Mac 采用 Intel 还是 Apple Silicon 架构，Tableau Desktop Mac 版需下载安装 Intel
版本，这是为了保证与 MySQL 驱动的兼容性。可通过 [Support
Releases](https://www.tableau.com/support/releases)页面选择并下载 Intel 版本。
+VeloDB 提供了一个官方的 Tableau Doris 连接器。 该连接器基于 MySQL JDBC Driver 实现访问数据。
-## 驱动安装
-1. iODBC 安装
- 1. 关闭 Tableau Desktop
- 2. 从 [iODBC
官网](https://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X)下载最新的
Driver Manager（mxkozzz.dmg）
- 3. 安装下载好的 dmg 文件
+该连接器通过 [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) 测试，通过率为
100%。
-2. MySQL 驱动安装
+通过这个连接器，Tableau 可以将 Apache Doris 数据库和表作为数据源进行集成。要启用此功能，请遵循下面的设置指南：
-选择 MySQL 5.x 的 ODBC 驱动安装，最新的 MySQL 驱动连接 Doris 会报错 Unsupported command 错误。
-## 连接配置与使用
-1. 点击 Tableau Desktop 主页，在连接数据源处选择 MySQL
+- 安装 Tableau 和 Doris connector
+- 在 Tableau 中配置 Apache Doris 数据源
+- 在 Tableau 中构建可视化
+- 连接和使用技巧
+- 总结
- 
+## 安装 Tableau 和 Doris connector
-2. 填写 Doris 服务器地址，端口等相关信息，正确填写后点击登录即可。
- 
+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\`
-3. 进入 Tableau 后选择对应的库表即可进行相关的罗盘处理。
+接下来，就可以在 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 | 密码
| 留空 |
+| Init SQL Statement | 初始化 SQL 语句
| `select * from database.table` |
+
+
+2. 启动 Tableau。（如果您在放置 connector 之前已经在运行它，请重新启动。）
+3. 从左侧菜单中，点击 **To a Server** 部分下的 **More**。在可用连接器列表中搜索 **Doris JDBC by
VeloDB**：
+
+
+
+4. 点击 **Doris by VeloDB ，将会弹出以下对话框：**
+
+
+
+5. 按照对话框提示输入相应的连接信息。
+6. 可选进阶配置：
+
+ - 可以在 Initial SQL 中输入预置 SQL 来定义数据源
+ 
+ - 在 Advanced 中，可以使用 Catalog 来实现数据湖数据源的访问，默认值为 internal,
+ 
+7. 在上述输入框完成后，即可点击 **Sign In** 按钮，您应该会看到一个新的 Tableau 工作簿：
+ 
+
+接下来，就可以在 Tableau 中构建一些可视化了！
+
+## 在 Tableau 中构建可视化
+
+我们选择 TPC-H 数据作为数据源，Doris TPC-H 数据源构建方式参考[此文档](../../benchmark/tpch.md)
+
+现在我们在 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. 假设您想知道按地域（国别）和年份计算的平均订单金额（美元）：
+ - 点击 `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，并实现了数据分析和可视化看板制作。
+
+## 连接和使用技巧
+
+**性能优化**
+
+- 根据实际需求，合理创建 doris 库表，按时间分区分桶，可有效减少谓词过滤和大部分数据传输
+- 适当的数据预聚合，可以通过 Doris 侧创建物化视图的方式。
+- 设置合理的刷新计划，均衡刷新的计算资源消耗 和 看板数据时效性
+
+**安全配置**
+
+- 建议使用 VPC 私有连接，避免公网访问引入安全风险。
+- 配置 安全组 限制访问。
+- 启用 SSL/TLS 连接等访问方式。
+- 细化 Doris 用户账号角色和访问权限，避免过度下放权限。
+
+## 总结
+
+这个连接器简化了通用 ODBC/JDBC 驱动程序的连接器 连接设置流程，为 Apache Doris
提供了更好兼容的连接器。如果您在使用连接器时遇到任何问题，请随时在
[GitHub](https://github.com/apache/doris/issues) 联系我们。
- 
\ No newline at end of file
diff --git a/static/images/ecomsystem/tableau/p01.png
b/static/images/ecomsystem/tableau/p01.png
new file mode 100644
index 00000000000..694d23b8beb
Binary files /dev/null and b/static/images/ecomsystem/tableau/p01.png differ
diff --git a/static/images/ecomsystem/tableau/p02.png
b/static/images/ecomsystem/tableau/p02.png
new file mode 100644
index 00000000000..f118ddd7731
Binary files /dev/null and b/static/images/ecomsystem/tableau/p02.png differ
diff --git a/static/images/ecomsystem/tableau/p03.png
b/static/images/ecomsystem/tableau/p03.png
new file mode 100644
index 00000000000..0369fdf079f
Binary files /dev/null and b/static/images/ecomsystem/tableau/p03.png differ
diff --git a/static/images/ecomsystem/tableau/p04.png
b/static/images/ecomsystem/tableau/p04.png
new file mode 100644
index 00000000000..dec191dd779
Binary files /dev/null and b/static/images/ecomsystem/tableau/p04.png differ
diff --git a/static/images/ecomsystem/tableau/p05.png
b/static/images/ecomsystem/tableau/p05.png
new file mode 100644
index 00000000000..a7d94a9b207
Binary files /dev/null and b/static/images/ecomsystem/tableau/p05.png differ
diff --git a/static/images/ecomsystem/tableau/p06.png
b/static/images/ecomsystem/tableau/p06.png
new file mode 100644
index 00000000000..d3675fc631a
Binary files /dev/null and b/static/images/ecomsystem/tableau/p06.png differ
diff --git a/static/images/ecomsystem/tableau/p07.png
b/static/images/ecomsystem/tableau/p07.png
new file mode 100644
index 00000000000..d21c3ba1829
Binary files /dev/null and b/static/images/ecomsystem/tableau/p07.png differ
diff --git a/static/images/ecomsystem/tableau/p08.png
b/static/images/ecomsystem/tableau/p08.png
new file mode 100644
index 00000000000..8305d64a256
Binary files /dev/null and b/static/images/ecomsystem/tableau/p08.png differ
diff --git a/static/images/ecomsystem/tableau/p09.png
b/static/images/ecomsystem/tableau/p09.png
new file mode 100644
index 00000000000..50a025ce325
Binary files /dev/null and b/static/images/ecomsystem/tableau/p09.png differ
diff --git a/static/images/ecomsystem/tableau/p10.png
b/static/images/ecomsystem/tableau/p10.png
new file mode 100644
index 00000000000..3a824e80901
Binary files /dev/null and b/static/images/ecomsystem/tableau/p10.png differ
diff --git a/static/images/ecomsystem/tableau/p11.png
b/static/images/ecomsystem/tableau/p11.png
new file mode 100644
index 00000000000..b8fd844815f
Binary files /dev/null and b/static/images/ecomsystem/tableau/p11.png differ
diff --git a/static/images/ecomsystem/tableau/p12.png
b/static/images/ecomsystem/tableau/p12.png
new file mode 100644
index 00000000000..4c02c305108
Binary files /dev/null and b/static/images/ecomsystem/tableau/p12.png differ
diff --git a/static/images/ecomsystem/tableau/p13.png
b/static/images/ecomsystem/tableau/p13.png
new file mode 100644
index 00000000000..8aa44dc1f65
Binary files /dev/null and b/static/images/ecomsystem/tableau/p13.png differ
diff --git a/static/images/ecomsystem/tableau/p14.png
b/static/images/ecomsystem/tableau/p14.png
new file mode 100644
index 00000000000..3677abcf4e8
Binary files /dev/null and b/static/images/ecomsystem/tableau/p14.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 739228aff11..5f3c44be389 100644
--- a/versioned_docs/version-3.x/ecosystem/bi/tableau.md
+++ b/versioned_docs/version-3.x/ecosystem/bi/tableau.md
@@ -5,28 +5,133 @@
}
---
-## Introduction
-Tableau is a lightweight data visualization analysis platform that combines
data operations with beautiful charts perfectly. It seamlessly combines data
computation with visually appealing charts, requiring no coding from the user.
By simply dragging and dropping, users can quickly gain insights into the data.
They can explore different views and even easily combine multiple data sources
to complete tasks such as data visualization, exploration, and analysis.
-## Prerequisites
-Regardless of whether your Mac is based on an Intel chips or Apple Silicon
Chips, for Tableau Desktop on Mac, you need to download and install the Intel
version. This is to ensure compatibility with the MySQL driver. You can select
and download the Intel version from the [Support
Releases](https://www.tableau.com/support/releases) page.
+VeloDB provides an official Tableau Doris connector. This connector accesses
data based on the MySQL JDBC Driver.
-## Driver Installation
-1. iODBC Installation
- 1. Close Tableau Desktop
- 2. Download the latest Driver Manager (mxkozzz.dmg) from the official
[iODBC
website](https://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X)
- 3. Install the downloaded dmg file
-2. Install the MySQL driver
+The connector has been tested by the [TDVT
framework](https://tableau.github.io/connector-plugin-sdk/docs/tdvt) with a
100% pass rate.
-When choosing the ODBC driver for MySQL to connect to Doris, you should
install the MySQL 5.x ODBC driver. Using the latest MySQL driver may result in
an "Unsupported command" error when connecting to Doris.
-## Connection Configuration and Usage
-1. Click the Tableau Desktop home page and select MySQL at the connection data
source
+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
+- Connection and usage tips
+- Summary
-2. Fill in the Doris server address, port and other relevant information, and
click sigin in button after correctly filling
+## Install Tableau and Doris connector
- 
-3. After entering Tableau, select the corresponding library table to carry out
the relevant compass processing.
+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\`
+
+Next, you can configure a Doris data source in Tableau and start building data
visualizations!
+
+## Configure 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.
+
+1. Gather your connection details
+
+To connect to Apache Doris via JDBC, you need the following information:
+
+| Parameter | Meaning
| Example |
+| -------------------- |
-------------------------------------------------------------------- |
----------------------------- |
+| 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:**
+
+
+
+5. Enter the corresponding connection information as prompted in the dialog.
+6. Optional advanced configuration:
+
+ - 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!
+
+## Build 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
+
+Now that we have configured the Doris data source in Tableau, let's visualize
the data
+
+1. Drag the customer table and orders table to the workbook. And select the
table join field Custkey for them below
+
+
+
+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.
+
+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`
+
+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:
+ 
+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:
+ 
+
+So far, Tableau has been successfully connected to Apache Doris, and data
analysis and visualization dashboard production has been achieved.
+
+## Connection and usage tips
+
+**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
+
+**Security configuration**
+
+- It is recommended to use VPC private connections 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).
+
- 
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
