◄Show Table of Contents

MySQL

Alteryx tools used to connect:

• Input Data and Output Data (Standard workflow processing)

Additional Details

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

• Projections are not supported for writing spatial data.
• The Spatial Match Tool only supports the "Intersects" calculation type.
• The Find Nearest Tool is not supported.

Learn more about Alteryx at www.alteryx.com | Connect with experts and access Alteryx support options at the Alteryx Community | Send comments on Alteryx Help to helpfeedback@alteryx.com

©2017 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.