# Connect with Alteryx Designer

You can connect to your SingleStore database from Alteryx Designer and perform analytics operations. Alteryx supports both read and write operations for the SingleStore data source.

For standard workflow processing, Alteryx supports the following tools for the SingleStore data source:

* [Input Data](https://help.alteryx.com/current/en/designer/tools/in-out-tools/input-data-tool.html)
* [Output Data](https://help.alteryx.com/current/en/designer/tools/in-out-tools/output-data-tool.html)

Alteryx supports the following authentication methods for the SingleStore data source:

* No authentication
* Username/password
* Generic OAuth

## Prerequisites

* Download and install [the SingleStore ODBC driver](https://docs.singlestore.com/db/v9.1/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver.md) version 1.1.5+
* [Download and install](https://help.alteryx.com/current/en/license-and-activate/install/download-and-install-a-product.html) Alteryx Designer

## Connect to SingleStore using a DSN and DCM

To connect to SingleStore from Alteryx using a DSN, you must [create a Data Source Name (DSN)](https://help.alteryx.com/current/en/designer/data-sources/odbc-and-oledb-database-connections.html#idp399997) for your ODBC connection. Once the DSN is created, perform the following tasks:

1. On the **Alteryx Designer** window, drag either the Input Data or Output Data tool from the tool palette to the workflow canvas area.

2. Select the **Use Data Connection Manager (DCM)** check box.

3. In the **Data Connections** window, select **Data Sources > Singlestore ODBC**. If Alteryx is unable to detect the SingleStore ODBC driver, a pop-up indicates that the driver must be installed.

4. On the **Connection Manager** window, select **New** to add a new data source.

5. Select **ODBC** from the list. This option is selected by default.

6. Enter a Data Source Name (DSN) for the new data source, for example, **Singlestore Server DSN**.

7. Select the **ODBC DSN** field to see a list of available DSNs, and select a DSN to use for the data source.

8. Select **Save**.

9. To link a credential, select **Connect Credential** and **select an Authentication Method** from the list.

10. Select **Connect** to use the Data Source and Credential in an Input Data or Output Data tool.

## Configure DSN-less Connection Using DCM

To connect to SingleStore from Alteryx using a DSN-less connection,

1. On the **Alteryx Designer** window, drag either the Input Data or Output Data tool from the tool palette to the workflow canvas area.

2. Select the **Use Data Connection Manager (DCM)** check box.

3. In the **Data Connections** window, select **Data Sources > SingleStore Quick Connect**. If Alteryx is unable to detect the SingleStore ODBC driver, a pop-up indicates that the driver must be installed.

4. On the **Connection Manager** window, select **New** to add a new data source.

5. Select **Singlestore ODBC DSN-less** from the list. This option is selected by default.

6. Enter the following connection configuration information:

   * Data Source Name for the connection, for example, **Singlestore DSN-less**
   * Hostname or IP address of the SingleStore deployment
   * Name of the SingleStore database to connect with
   * Port of the SingleStore database

7. (Optional) Select the **Driver** field to change the selected driver.

8. Select **Save**.

9. To link a credential, select **Connect Credential** and select an **Authentication Method** from the list.

10. Select **Connect** to use the Data Source and Credential in an Input Data or Output Data tool.

## Limitations

Alteryx does not support the following for the SingleStore data source:

* Spatial data types
* Table names containing `'` (single quote)
* Writing to `DOUBLE` type columns
* `BIT`, `BINARY`, `VARBINARY`, `TINYBLOB`, `BLOB`, `MEDIUMBLOB`, and `LONGBLOB` SingleStore data types

***

Modified at: September 26, 2025

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-alteryx-designer/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-alteryx-designer/)

(An index of the documentation is available at /llms.txt)