# Connect with Tableau Prep

You can connect Tableau Prep to SingleStore using [the SingleStore JDBC driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-java-jdbc/the-singlestore-jdbc-driver.md) or [the SingleStore ODBC driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md) to perform ETL operations.

To connect using the SingleStore ODBC driver, select the **SingleStore** option from the connection list. To connect using the SingleStore JDBC driver, select the **SingleStoreDB JDBC by SingleStore** option from the connection list instead.

The following certification matrix shows the latest version(s) tested for SingleStore and Tableau Prep:

| Certification Matrix   | Versions            |
| ---------------------- | ------------------- |
| Tableau Prep           | 2023.1.3, 2023.2.0+ |
| SingleStoreODBC Driver | 1.1.7+              |
| SingleStoreJDBC Driver | 1.1.4+              |

> **📝 Note**: SingleStore recommends using the latest version of Tableau Prep with the latest version of the SingleStore JDBC driver or the SingleStore ODBC driver.

## Prerequisites

* Install the SingleStore JDBC driver or the SingleStore ODBC driver.
* Create the DSN for source and destination databases.
* Install Tableau Prep.

**Note**: When using a source or target other than SingleStore or MySQL, you will need to install the respective JDBC/ODBC driver for that platform.

## Write to a Database

Although Tableau Prep can read data from a wide array of databases and cloud storage platforms, writing to external databases is available only for a limited set of datasources.

SingleStore enables writing back to a database via Tableau Prep, which allows the users to:

* Connect to other data sources supported by Tableau Prep or connect to a SingleStore database.
* Prepare data, including cleansing, imputation, and complex transformation.
* Write changes back to the SingleStore database from the other sources, a different SingleStore database, or a different table in the same database.
* Build Tableau dashboards using the data in SingleStore.

## Configure Tableau Prep to Connect to SingleStore and Run a Transform

To connect to SingleStore from Tableau Prep:

1. On Tableau Prep, on the left navigation pane, select **Connections > Connect > SingleStore** (or **SingleStoreDB JDBC by SingleStore**).

   ![](https://images.contentstack.io/v3/assets/bltac01ee6daa3a1e14/blt631f42678c4640d9/6a2c43c2714c3620a48ec22a/tableau_prep1-otExWu.png)

2. Enter the connection details in the **SingleStore** dialog and connect to the datasource:

   * **Server**: IP address or hostname of the SingleStore cluster
   * **Port**: Default is `3306`
   * **Database** (Optional): The SingleStore database name
   * **Username** and **Password**: The SingleStore database username and password

3. Select the database and tables, and configure the required transformations.

4. From the **Save output to** list, select **Database table**.

5. Under **Settings**, either select an existing connection or create a new connection to the target database.

6. From the **Write Options** list select one of the following options: **Create table**, **Append to table**, or **Replace data**.

7. Select **Run flow** to run the transform.

***

Modified at: September 26, 2025

Source: [/db/v9.1/load-data/integrate-with-singlestore/connect-with-tableau-prep/](https://docs.singlestore.com/db/v9.1/load-data/integrate-with-singlestore/connect-with-tableau-prep/)

(An index of the documentation is available at /llms.txt)