◄Show Table of Contents

Oracle

Alteryx tools used to connect

• Input Data Tool and Output Data Tool (For standard workflow processing)
• Connect In-DB Tool and Data Stream In Tool (For In-Database workflow processing).

Additional Details

• Version 10.02.00.01 64 bit OLEDB provider had issues with FIXED DECIMAL. Alteryx recommends using the 11g or newer driver.

• Oracle Connection uses the Oracle Call Interface (OCI) library to connect to the Oracle database. This library is part of the Client software installed with the database.

• Oracle OLEDB is not supported in the In-Database tools. Use ODBC or OCI.

Limitations

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)

Known Issues

A single workflow with ODBC connections cannot contain either OleDB or OCI connections using the same driver.

Alteryx.com | Community | Customer Support | Documentation Feedback

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