Oracle

Type of Support: Read & Write, In-Database
Validated On:

Database Version: 12c and 19c

ODBC Client Version: 1.4.10.1010

Connection Type: ODBC, OLEDB, and OCI (64-bit)
Driver Details: The OCI driver can be downloaded from Oracle Instant Client. The certified SIMBA drive can be dowloaded from the Alteryx Download Center .
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.

  • Support only for username and password authentication.

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.