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 . The OCI basic package must be installed in order for the Simba ODBC driver to work.
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.

  • Connection to Oracle database fails with Connection Error when the password contains or starts with special characters. Nonquoted identifiers must begin with an alphabetic character from your database character set. Quoted identifiers can begin with any character. To avoid the error when making the connection, enclose the password in double-quotes.