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 |
|
Alteryx tools used to connect
Standard workflow processing
Configure Connection Using a DSN and DCM
Drag an Input Data tool or Output Data tool onto the Designer canvas.
Select the Use Data Connection Manager (DCM) check box.
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.
The Connection Manager window opens. Select +New to add a new data source.
The dropdown pre-selects ODBC by default.
Enter a descriptive Data Source Name for the new data source, for example, "Singlestore Server DSN".
Select the ODBC DSN field to see a list of available DSNs and select a DSN to use for the data source.
Select Save.
To link a credential, select + Connect Credential and select preferred authentication method.
Select Connect to use the Data Source and Credential in an Input Data our Output tool.
Configure DSN-less Connection Using DCM
Drag an Input Data tool or Output Data tool onto the Designer canvas.
Select the Use Data Connection Manager (DCM) check box.
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.
The Connection Manager window opens. Select +New to add a new data source. .
The dropdown pre-selects Singlestore ODBC DSN-less.
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.
Select Save.
To link a credential, select + Connect Credential and select an Authentication Method from the dropdown.
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.