Documentation

Tableau

Updated on

Oct 19, 2023

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.

We recommend using ClickHouse JDBC Connector by Analytika Plus with Tableau Desktop.

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:

Connection parameter Credentials
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

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:

  • macOS: ```~/Library/Tableau/Drivers```
  • Windows: ```C:\Program Files\Tableau\Drivers```

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:

  • macOS: ```~/Documents/My Tableau Repository/Connectors```
  • Windows: ```C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors```

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.

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Tableau
here

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.