Skip to main content

Tableau

Tableau is a visual analytics platform transforming the way we use data to solve problems—empowering people and organizations to make the most of their data. By leveraging the databend-jdbc driver (version 0.0.8 or higher), Databend Cloud seamlessly integrates with Tableau, enabling seamless data access and efficient analysis. It is important to note that for optimal compatibility, it is advisable to use Tableau version 2023.1.0 or higher to avoid potential compatibility issues.

In the following tutorial, you will find a detailed, step-by-step guide on deploying and integrating Tableau Desktop with Databend Cloud.

Tutorial: Integrate with Tableau Desktop

In this tutorial, you'll integrate Databend Cloud with Tableau Desktop. Before you start, download Tableau Desktop and follow the on-screen instructions to complete the installation.

Step 1. Obtain Connection Information

Obtain the connection information from Databend Cloud. For how to do that, refer to Connecting to a Warehouse.

Step 2. Install databend-jdbc

  1. Download the databend-jdbc driver (version 0.0.8 or higher) from the Maven Central Repository at https://repo1.maven.org/maven2/com/databend/databend-jdbc/

  2. To install the databend-jdbc driver, move the jar file (for example, databend-jdbc-0.0.8.jar) to Tableau's driver folder. Tableau's driver folder varies depending on the operating system:

Operating SystemTableau's Driver Folder
MacOS~/Library/Tableau/Drivers
WindowsC:\Program Files\Tableau\Drivers
Linux/opt/tableau/tableau_driver/jdbc

Step 3. Connect to Databend Cloud

  1. Launch Tableau Desktop and select Other Database (JDBC) in the sidebar. This opens a window as follows:

Alt text

  1. In the window, provide the connection information you obtained in Step 1 and click Sign In.
ParameterDescriptionFor This Tutorial
URLFormat: jdbc:databend://{user}:{password}@{host}:{port}/{database}jdbc:databend://cloudapp:<your-password>@https://<your-host>:443/default
DialectSelect "MySQL" for SQL dialect.MySQL
UsernameSQL user for connecting to Databend Cloudcloudapp
PasswordSQL user for connecting to Databend CloudYour password
  1. When the Tableau workbook opens, select the database, schema, and tables that you want to query. For this tutorial, select default for both Database and Schema.

Alt text

You're all set! You can now drag tables to the work area to start your query and further analysis.

Did this page help you?
Yes
No