MySQL

Version:
Current
Last modified: October 19, 2020
Connection Type

ODBC (32- and 64-bit)
Type of Support

Read & Write, In-Database
Validated On

Database version 5.1
Database version 5.6, 5.7 (Spatial support)
ODBC client version 5.01.04.00, 5.01.12.00
ODBC client version 5.02.06.00, ANSI and Unicode® encoding (Spatial support)
ODBC Client Version 8.0.19

Driver Details

In-Database processing requires 64-bit database drivers.
Certified SIMBA driver from Alteryx Download Center
Not certified ODBC driver from external provider

Alteryx tools used to connect

For Standard workflow processing

Link
Input Data Tool Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

For In-Database workflow processing

Link
Blue icon with database being plugged in.

Connect In-DB Tool

Link
Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

Limitations

Database Version 5.1
  • Maximum Columns In Table: 4096
  • Maximum Column Name Length: 64 characters
  • Maximum Row Size: 65535 bytes (does not include LOB size)
ODBC Version 5.01.04.00 (32- and 64-bit)
  • Fixed Numeric is transported as a SQL_C_CHAR; SQL_NUMERIC not supported.
  • Known bug with BIT datatypes (MySQL Bug#37118) - returns false no matter what you do.
OLEDB

MySQL does not have a native OLEDB provider.

Spatial
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.