Connecting Tableau to TiDB

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tableau连接tidb

| username: TiDBer_thVyCYGs

Can Tableau connect to TiDB through the MySQL connector in Desktop? Currently, the connection fails with an error: invalid username or password. However, it can connect using Tableau’s JDBC.

| username: Billmay表妹 | Original post link

You might need to seek help from their community; currently, there is no such practice observed.

| username: Fly-bird | Original post link

Tableau Desktop can connect to MySQL using the ODBC connection method. You can connect by selecting the MySQL ODBC 8.0 Driver. Note to change the TiDB port to 4000.

| username: cassblanca | Original post link

A MySQL 8.0 or higher driver is required for a proper connection.

| username: 大飞哥online | Original post link

The authentication method for the password has changed, right?

| username: Kongdom | Original post link

This is indeed possible. When we used MySQL 8.0.33 without changing the driver, we encountered this kind of issue.

| username: ajin0514 | Original post link

Try changing the driver.

| username: TiDBer_thVyCYGs | Original post link

Currently using the MySQL ODBC driver version 8.0.23.

| username: TiDBer_thVyCYGs | Original post link

Currently using version 8.0.23.

| username: jansu-dev | Original post link

Are you connecting to serverless (serverless requires a secure connection) or OP TiDB?
If the TiDB log only shows invalid username or password, it should still be an issue with the driver or the incoming request. How about capturing a packet? :thinking:

There shouldn’t be much difference between using an ODBC connection and a JDBC connection. The only thing I can think of is the driver. If it doesn’t work, try capturing a packet.
Steps to connect Tableau to MySQL - Zhihu (zhihu.com)

| username: TiDBer_thVyCYGs | Original post link

Which version of the driver did you use later that worked normally?

| username: Kongdom | Original post link

.Core uses the 8.0.31 driver

| username: andone | Original post link

You need to install the driver.