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.

Connecting to Oracle

  • 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.

Stored procedures

Limitations

Known Issues

  • A single workflow with ODBC connections cannot contain either OleDB or OCI connections using the same driver.
  • If you are connecting to an Oracle database that contains UnicodeĀ® encoded data, select Force SQL WChar Support in the Input Data Tool Configuration window. Character columns are then treated as SQL_WCHAR, SQL_WVARCHAR, or SQL_WLONGVARCHAR.