Sign inTry Free

Connect with Alteryx Designer

On this page

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:

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

  • No authentication

  • Username/password

  • Generic OAuth

Prerequisites

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) 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, LONGBLOB SingleStore data types

Last modified: February 6, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK