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
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
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/
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 System||Tableau's Driver Folder|
Step 3. Connect to Databend Cloud
- Launch Tableau Desktop and select Other Database (JDBC) in the sidebar. This opens a window as follows:
- In the window, provide the connection information you obtained in Step 1 and click Sign In.
|Parameter||Description||For This Tutorial|
|Dialect||Select "MySQL" for SQL dialect.||MySQL|
|Username||SQL user for connecting to Databend Cloud||cloudapp|
|Password||SQL user for connecting to Databend Cloud||Your password|
- 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.
You're all set! You can now drag tables to the work area to start your query and further analysis.