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 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).

   

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.