Type of Support: Read & Write; In-Database
Validated On: 12c,
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


Database Version: 10g and 11g

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

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

Oracle Call Interface (Client Versions: (Vista), (32- and 64-bit), (32- and 64-bit))

Known Issues

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