Connect with Tableau Prep

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 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 cluster

   • Port: Default is 3306

   • Database (Optional): The SingleStoreDB 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.