◄Show Table of Contents

MySQL

Alteryx tools used to connect

Input Data Tool and Output Data Tool (For 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.

Alteryx.com | Community | Customer Support | Documentation Feedback

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