Oct 19, 2023
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.
We recommend using ClickHouse JDBC Connector by Analytika Plus with Tableau Desktop.
You need the following information to connect Tableau with Improvado Clickhouse Database:
Replace ```CustomerID``` with the ID that you can find on the Visualization page.
Step 1. Download the latest version of the Clickhouse JDBC driver (version ```0.3.2-patch8``` required) from Clickhouse GitHub and place the ```clickhouse-jdbc-0.3.2-patch8-shaded.jar``` to:
Note: If this folder doesn't already exist, you'll need to create it.
Step 2. Download the latest TACO connector ```clickhouse_jdbc_<version>.taco``` from the Releases page and place it to:
Step 3. Open the Tableau Desktop app and choose the ClickHouse JDBC by ANALYTIKA PLUS in the Tableau Settings section.
Step 4. Fill in your credentials from the Improvado connection settings page.
Step 5. Select the Advanced tab, and enter the following custom parameter for JDBC Driver: ```join_use_nulls=0```.
Step 6. Press the Sign In button.
Step 7. After a small loading, you should see a new Tableau Workbook. 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.
Step 8. Now you can visualize data using worksheet tabs
Step 9. Choose fields for columns and rows, select a chart type.