Documentation

Tableau

What is Tableau?

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.1.0.0.20190523 or newer) works fine with Tableau Server for Linux.

Pros:

  • Versatile features
  • Intuitive user interface
  • Customizable dashboards
  • Extensive offering of data source integrations

Credentials and Connection Details

You need the following information to connect Tableau with Improvado Clickhouse Database:

user improvado_CustomerID_db
port 443
host db-access.improvado.io
SSL require
database improvado_CustomerID_{db_id}

Replace CustomerID with the ID that you can find on the Visualization page.

Example: improvado_1234_{db_id}

Connection Description

  1. 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).
  2. 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):
  1. Make sure that Clickhouse drivers are available (use the Unicode one)
  2. Create a new System DSN, using the ClickHouse ODBC Driver (Unicode)
  1. 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.
  1. Open Tableau Desktop app and choose the Other Databases (ODBC) in the Tableau Settings section.
  1. Select the ClickHouse System DSN we created in the previous steps from the drop-down list in the DSN field.
  1. Press the Connect button.
  2. After a small loading, click Sign In.
  1. 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.

  1. Now you can visualize data using worksheet tabs
  2. Choose fields for columns and rows, select a chart type.
Related articles
No items found.
No items found.