Last modified: September 26, 2019
Connection Type

ODBC (32- and 64-bit)

Driver Details

The ODBC driver can be downloaded from MySQL.

In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write, In-Database

Validated On

Database version 5.1
Database version 5.6, 5.7 (Spatial support)
ODBC client version,
ODBC client version, ANSI and UnicodeĀ® encoding (Spatial support)

Alteryx tools used to connect

For Standard workflow processing

For In-Database workflow processing

Blue icon with database being plugged in.

Connect In-DB Tool

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

Data Stream In Tool


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 (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.

MySQL does not have a native OLEDB provider.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.