Database Version: 10g and 11g
Maximum Columns In Table: 1000
Maximum Column Name Length: 30 characters
Maximum Row Size: 4GB ( does not include LOB size )
Variable length strings may return NULL instead of Empty.
| Type of Support: | Read & Write; In-Database |
| Validated On: | 12c, 12.01.00.01 |
| Connection Type: | ODBC, OLEDB, and OCI (32- and 64-bit) |
| Driver Details: | The OCI driver can be downloaded from Oracle Instant Client. Bulk write support is available with 64-bit connections for standard and in-database workflows. In-Database processing requires 64-bit database drivers. |
Version 10.02.00.01 64 bit OLEDB provider had issues with FIXED DECIMAL. Alteryx recommends using the 11g or newer driver.
Oracle OLEDB is not supported in the In-Database tools. Use ODBC or OCI.
Database Version: 10g and 11g
Maximum Columns In Table: 1000
Maximum Column Name Length: 30 characters
Maximum Row Size: 4GB ( does not include LOB size )
Variable length strings may return NULL instead of Empty.
ODBC (Client Versions: 10.02.00.03 (Vista), 10.02.00.01 (32- and 64-bit), 11.01.00.06 (32- and 64-bit))
All versions - INT64 is transported as a Fixed Numeric; SQL_C_BIGINT is not supported.
OLEDB (Client Versions: 10.02.00.03 (Vista), 10.02.00.01 (32- and 64-bit), 11.01.00.06 (32- and 64-bit))
10.02.00.01 64 bit - issues with FIXED DECIMAL
Oracle Call Interface (Client Versions: 10.02.00.03 (Vista), 10.02.00.01 (32- and 64-bit), 11.01.00.06 (32- and 64-bit))
Int64 is transported as a Double.
Bool is transported as a String(1)
DateTime is transported as a String(19)
A single workflow with ODBC connections cannot contain either OleDB or OCI connections using the same driver.
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.