Alteryx Designer Desktop Knowledge Base

Error: "An item with the same key has already been added" when selecting Quick Connect

When connected to an Oracle database, the Visual Query Builder will freeze, or Designer occasionally crashes, when trying to select a method of aggregation for a selected column

If there is already a selected stored procedure in the SQL Editor tab, clicking on the Stored Procedures tab in the “Configure Pre/Post SQL statements and Stored Procedure” window will throw out “Unable to find stored procedure ” where the name of the procedure is incorrect.

the issue occurs when opening a data source in Designer

How to Connect to Databases Outside of Alteryx.

This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.

How to format common ODBC DSN-less connection strings

Corrupted Data when writing V_STRING, V_WSTRING, WSTRING to a CLOB using OCI or when writing V_STRING to a CLOB using ODBC

This article details different methods for connecting to an Oracle database from Alteryx.

Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists

Alteryx allows you to connect to many different types of data sources. One type of data source you can connect to is a database. Examples of databases are SQL Server, Oracle, Teradata, and MongoDB;  amongst many others. There are several connection methods to connect to database sources including ODBC, OleDB, or natively.

When using special charater "≥" value in a database Input Data tool, the field displays as "=".

Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.

Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname

Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows

When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.

Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database

Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.

This is a workaround for connecting to an Oracle database that uses LDAP authentication.

Have you ever wanted to enrich your marketing data through improved data blending and analytics. Now is your chance by connecting to Oracle Eloqua through Alteryx!

Unable to find the dll: "OCI.dll" Within Alteryx this error will be prompted due to a mismatch between 32/64 bit drivers and the Alteryx bit version. This error may also appear if you do not have the drivers installed. One way to troubleshoot this is to find out what drivers you have installed! You can use an input tool in the Alteryx Designer, go to Other Databases and select either ODBC/OleDB (64-bit) or 32-Bit Database Connections -> ODBC/OleDB. In the next pop out window it will populate with the available drivers for those connections. If you have no drivers in this pop out window this means you do not havethe correct drivers for 32 bit or 64 bit connection dependent upon which one you chose. Links to drivers are available from within individual data source pages here. This will take you away from the Alteryx website and onto the driver provider’s pages. Please consult with your IT to find the correct drivers for your environment.