Skip to main content


Connection Type

ODBC (64-bit)

Type of Support

Read & Write, In-Database

Validated On

Database Version: 8.0.25

ODBC Client Version:

Alteryx Tools Used to Connect

For Standard Workflow Processing

Input Data Tool

Input Data Tool Icon


Output Data Tool

Output Data Tool Icon


For In-Database Workflow Processing

Connect In-DB Tool

Blue icon with database being plugged in.


Data Stream In Tool

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



  • Maximum Columns In Table: 4096

  • Maximum Column Name Length: 64 Characters

  • Maximum Row Size: 65535 Bytes (does not include LOB size)

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

When writing to MySQL with the output option Update: Insert if New, make sure you have selected Return matched rows instead of affected rows in your driver DSN Setup.