Tableau is a visualization tool that helps businesses transform their data into insights that can lead to action. The tool makes it easy to connect data in almost any format from almost any source
The tool can be a helpful way of keeping track of progress for businesses that have many clients, and there is no need for any coding expertise to use Tableau. With an option for cloud hosting, it may also be a good option for those who don’t want more software installed on-site.
The ClickHouse ODBC driver (v.22.214.171.12490523 or newer) works fine with Tableau Server for Linux.
Intuitive user interface
Extensive offering of data source integrations
Credentials and Connection Details
You need the following information to connect Tableau with Improvado Clickhouse Database:
Download and install the latest version of ODBC driver for Clickhouse from Clickhouse GitHub (you can find the latest version of ClickHouse ODBC driver here).
Run ODBC Data Sources tool and configure the connection with ClickHouse. If you downloaded the 64-bit Clickhouse driver previously, then you need to open ODBC Data Sources (64-bit):
Make sure that Clickhouse drivers are available (use the Unicode one)
Create a new System DSN, using the ClickHouse ODBC Driver (Unicode)
Fill in your credentials (if you work with large tables you might need to increase the default Timeout from 30s to 60-300s depending on the size of your table) and click Ok to save the new System DSN connection.
Open Tableau Desktop app and choosethe Other Databases (ODBC) in the Tableau Settings section.
Select the ClickHouse System DSN we created in the previous steps from the drop-down list in the DSN field.
Press the Connect button.
After a small loading, click Sign In.
Click the Search icon, then click the Load button, to see all the tables in this database.
IMPORTANT: be sure to use tables with the _all_data suffix in your reports.
Now you can visualize data using worksheet tabs
Choose fields for columns and rows, select a chart type.