Connect with Tableau Server

You can use Tableau Server to connect your SingleStore cluster and explore your data.

Supported versions:

Tableau Server

v2022.3.1

SingleStore ODBC Driver

v1.1.1+

You can also use the MySQL ODBC Driver v8.0.30 to connect to SingleStore from Tableau Server.

To connect with Tableau Server, perform the following tasks:

  1. Install the latest supported version of Tableau Server.

  2. Download and install the latest version of the SingleStore ODBC Driver from its GitHub repository. See The SingleStore ODBC Driver for more information.

    You can also download the driver by following the instructions on the Tableau Driver Download page. To find the driver, select SingleStore as the Data Source, Linux as the Operating System, and 64-bit as the Bit Version from the respective drop-down lists.

    Note

    You must specify Unicode or ANSI in the driver name configuration. If the driver mode (Unicode/ANSI) is not specified in the driver name configuration, Tableau Server may not be able to detect/identify the SingleStore ODBC driver.

    The name should be: SingleStore ODBC Unicode Driver or SingleStore ODBC ANSI Driver.

  3. If you are using Linux, perform the following tasks:

    • Move the libssodbcw.so file to the /usr/lib/ directory.

    • Update the driver path in the /etc/odbcinst.ini file to Driver=/usr/lib/libssodbcw.so.

  4. Open/refresh the Tableau Service Manager page, and select New > Published Data Source.

  5. On the Connect to Data dialog, under the Connectors tab, select SingleStore.

  6. On the SingleStore dialog, enter the following details:

    • The IP address or the hostname of your cluster.

    • Port (default is 3306).

    • The SingleStore username and password.

  7. Select Sign In.

Once the connection is set up and you are successfully connected, you can plug into your SingleStore data using Tableau Server.

Last modified: November 9, 2023

Was this article helpful?