Oracle

 

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.

 

Alteryx tools used to connect:

Connecting to Oracle

See Connect to an Oracle Database.

Additional Details

Limitations

Database Version: 10g and 11g

ODBC (Client Versions: 10.02.00.03 (Vista), 10.02.00.01 (32- and 64-bit), 11.01.00.06 (32- and 64-bit))

OLEDB (Client Versions: 10.02.00.03 (Vista), 10.02.00.01 (32- and 64-bit), 11.01.00.06 (32- and 64-bit))

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))

Known Issues

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