Skip to main content

Connect with Tableau Prep

You can connect Tableau Prep to SingleStoreDB to perform ETL operations. The following certification matrix shows the latest versions tested for SingleStoreDB and Tableau Prep:

Certification Matrix

Versions

SingleStoreDB

7.0 and newer

MySQL ODBC Driver

Version 5.3.12 (64 bit)

Prerequisites

  • MySQL ODBC Driver version 5.3.12 (64 bit)

  • Create the DSN for source and destination databases

  • Tableau Prep License & software installed

Note: When using a source or target other than SingleStoreDB/MySQL, you will need to install the respective 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, the write back to a database functionality is available only for a limited set of datasources.

SingleStoreDB enables writing back via Tableau Prep’s support for MySQL. Writing back to a database allows SingleStoreDB 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

  1. Open the Tableau Prep application.

  2. Select the SingleStore datasource from the dropdown list.

  3. Provide the connection details.

  4. Select the database and tables.

  5. Configure your transformation.

  6. Under Save output to, select Database table.

  7. Select MySQL in the list of databases to connect to SingleStoreDB and enter the database details.

    16083b578e1bf7.png
  8. Either select a table or create a new table for the target.

  9. Click Run flow to run the transform.