Connect with Tableau Prep

You can connect Tableau Prep to SingleStoreDB using the SingleStore JDBC driver or the SingleStore ODBC driver 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 SingleStoreDB Cloud and Tableau Prep:

Certification Matrix


Tableau Prep

2023.1.3, 2023.2.0+

SingleStore ODBC Driver


SingleStore JDBC Driver



SingleStore recommends using the latest version of Tableau Prep with the latest version of the SingleStore JDBC driver or the SingleStore ODBC driver.


  • 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 SingleStoreDB 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.

SingleStoreDB 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 SingleStoreDB database.

  • Prepare data, including cleansing, imputation, and complex transformation.

  • Write changes back to the SingleStoreDB database from the other sources, a different SingleStoreDB database, or a different table in the same database.

  • Build Tableau dashboards using the data in SingleStoreDB.

Configure Tableau Prep to Connect to SingleStoreDB and Run a Transform

To connect to SingleStoreDB from Tableau Prep:

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

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

    • Server: IP address or hostname of the SingleStoreDB Cloud workspace

    • Port: Default is 3306

    • Database (Optional): The SingleStoreDB Cloud database name

    • Username and Password: The SingleStoreDB 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.

Last modified: December 1, 2023

Was this article helpful?