odbc - 无法从 Tableau Server 连接 clickhouse ODBC

Question

我正在尝试从 Tableau Server 连接 clickhouse

为了连接 Tableau，我们在 Tableau Server 上安装了 clickhouse ODBC 下面是 odbc.ini 和 odbcinst.ini 例如：Clickhouse 位于 192.168.0.1 例如：Tableau 位于 192.168.0.2''

odbcinst.ini

> [ODBC Drivers] ClickHouse ODBC Driver (ANSI)    = Installed ClickHouse
> ODBC Driver (Unicode) = Installed
> 
> [ClickHouse ODBC Driver (ANSI)] Description = ODBC Driver (ANSI) for
> ClickHouse Driver      =
> /root/clickhouse-odbc/build/driver/libclickhouseodbc.so Setup       =
> /root/clickhouse-odbc/build/driver/libclickhouseodbc.so UsageCount  =
> 1
> 
> [ClickHouse ODBC Driver (Unicode)] Description = ODBC Driver (Unicode)
> for ClickHouse Driver      =
> /root/clickhouse-odbc/build/driver/libclickhouseodbc.so Setup       =
> /root/clickhouse-odbc/build/driver/libclickhouseodbc.so UsageCount  =
> 1 [ODBC] Trace=yes TraceFile= /tmp/clickhouse-odbc.log 
> 
> odbc.ini
> 
> [ODBC Data Sources] ClickHouse DSN (ANSI)    = ClickHouse ODBC Driver
> (ANSI) ClickHouse DSN (Unicode) = ClickHouse ODBC Driver (Unicode)
> 
> [ClickHouse DSN (ANSI)] Driver      = ClickHouse ODBC Driver (ANSI)
> Description = DSN (localhost) for ClickHouse ODBC Driver (ANSI)
> 
> ### New all-in one way to specify connection with [optional] settings:
> #Url = http://default@192.168.0.1:8123/query?database=default&max_result_bytes=4000000&buffer_size=3000000
> 
> #Url = http://192.168.0.1:8123
> 
> ### Old way: Server = 192.168.0.1 Database = default UID = default
> #PWD = password Port = 8123 Proto = http
> 
> DriverLog = yes DriverLogFile = /tmp/chlickhouse-odbc-driver.log
> 
> [ClickHouse DSN (Unicode)] Driver      = ClickHouse ODBC Driver
> (Unicode) Description = DSN (192.168.0.1) for ClickHouse ODBC Driver
> (Unicode)

我们可以从 Tableau Server 做 curl clickhouse

但是当我们尝试与 Tableau 连接时，我们遇到了错误

标签： odbctableau-apiclickhouse