Skip to main content

SingleStore

Connection Type

ODBC (64-bit)

Driver Configuration Requirements

Download the driver from the SingleStore download page.

Type of Support

Read and Write

Validated On

Client Version: 1.1.5

Authentication Methods

  • No authentication

  • Username/Password

  • Generic OAuth

Alteryx tools used to connect

Standard workflow processing

Configure Connection Using a DSN and DCM

  1. Drag an Input Data tool or Output Data tool onto the Designer canvas.

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

  3. In the Data Connections window, go to Data Sources and select Singlestore ODBC. If Alteryx can't detect an ODBC driver, a pop-up indicates that you need to install a driver.

  4. The Connection Manager window opens. Select +New to add a new data source.

  5. The dropdown pre-selects ODBC by default.

  6. Enter a descriptive Data Source Name 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 preferred authentication method.

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

Configure DSN-less Connection Using DCM

  1. Drag an Input Data tool or Output Data tool onto the Designer canvas.

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

  3. In the Data Connections window, go to Data Sources and select SingleStore Quick Connect. If Alteryx can't detect an ODBC driver, a pop-up prompts you to install a driver.

  4. The Connection Manager window opens. Select +New to add a new data source. .

  5. The dropdown pre-selects Singlestore ODBC DSN-less.

  6. Enter the information for the connection:

    • Descriptive Data Source Name for the connection, for example, "Singlestore DSN-less",

    • host name,

    • select the Driver field to change the driver selection,

    • database name,

    • port number.

  7. Select Save.

  8. To link a credential, select + Connect Credential and select an Authentication Method from the dropdown.

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

Known Issues

  • Spatial data types are not supported.

  • Table names containing ' (single quote) are not supported.

  • Writing to DOUBLE column is not supported.

  • BIT, BINARY, VARBINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB data types are not supported.