Tableau doesn't recognize the data source type "Clickhouse_ODBC"

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse

https://clickhouse.tech

Apache License 2.0

245 stars 86 forks source link

Tableau doesn't recognize the data source type "Clickhouse_ODBC" #362

Open Fasilbeyene opened 3 years ago

Fasilbeyene commented 3 years ago

Hi Folks,

I used the latest version of the "clickhouse-odbc" driver from the link: https://github.com/ClickHouse/clickhouse-odbc/releases. I also used the connector "clickhouse-tableau-connector-odbc" as per the instruction listed out here: https://github.com/Altinity/clickhouse-tableau-connector-odbc. After doing this, I can able to access and visualize clickhouse data using Tableau Desktop.

Problem:

When I try to publish to Tableau Server, I got the following error:

image (9)

Could you please advice me what the issue is and what I can try to resolve this issue?

Thanks, Fasil

dima-altinity commented 3 years ago

@Fasilbeyene I think that this problem is not related to odbc driver and should be posted in this repo https://github.com/Altinity/clickhouse-tableau-connector-odbc

Most likely its because both ClickHouse ODBC driver and connector should be installed on Tableau Server.

jorgecabrera85 commented 3 years ago

@Fasilbeyene I think that this problem is not related to odbc driver and should be posted in this repo https://github.com/Altinity/clickhouse-tableau-connector-odbc

Most likely its because both ClickHouse ODBC driver and connector should be installed on Tableau Server.

Both (driver and connector are installed in Tableau server (Linux), as explained in the link you provided.

paramasivan1 commented 2 years ago

anyone know what is the solution for this

dima-altinity commented 2 years ago

what Tableau server do you use?
did you use latest connector version from https://github.com/Altinity/clickhouse-tableau-connector-odbc/releases
what do you see in Tableau server log?

jorgecabrera85 commented 2 years ago

what Tableau server do you use?

did you use latest connector version from https://github.com/Altinity/clickhouse-tableau-connector-odbc/releases

what do you see in Tableau server log?

Thanks! Dima! Just to clarify , we need to have the ODBC driver for clickhouse https://github.com/ClickHouse/clickhouse-odbc/releases AND we need to have the connector installed in the proper directory (windows vs. linux) https://github.com/Altinity/clickhouse-tableau-connector-odbc/releases

Restart Tableau server.

No need to specify ip,port,username, password, etc.

Thanks! JC