Dear Valued Customer, We are currently experiencing an issue with Alteryx Designer where the application closes upon opening and/or running workflows. Our team believes it has identified the root cause and is working to remedy the situation. We are sorry for this inconvenience and thank you for your patience. An e-mail will be sent once this issue is resolved. Alteryx Customer Support Team

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname
View full article
Error: "An item with the same key has already been added" when selecting Oracle Quick Connect
View full article
Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows
View full article
When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.
View full article
Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database
View full article
Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.
View full article
This is a workaround for connecting to an Oracle database that uses LDAP authentication.
View full article
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!
View full article
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.
View full article
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.
View full article
Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager
View full article
Display issues when reading data with unicode characters from Oracle
View full article
Understand and troubleshoot the "No error handle available to report exact OCI_ERROR" error message
View full article
An OCI error may occur when running a workflow from a network location with many OCI inputs: OCIEnvCreate Error: No error handle available to report exact OCI_ERROR.
View full article
Exception handling may be needed so that a scheduled workflow continues even if a pre or post Oracle SQL statement has an error.
View full article
Characters that are not on a standard English keyboard may need translation into Unicode or a language-specific code page for Designer and database drivers to read them correctly. Characters with incorrect encoding will often appear as boxes or question marks in the Designer Results screen and error messages. Unicode characters take more bytes than English ASCII characters. Changing the column type and increasing the column size may be needed. In Designer, the column size is the number of characters, not the number of bytes.
View full article
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.
View full article
Oracle database character set is AL32UTF8. The field defined is VARCHAR2. Writing back some Chinese characters to this field using OCI ends with garbled characters.
View full article
How to format common ODBC DSN-less connection strings
View full article
This article details different methods for connecting to an Oracle database from Alteryx.
View full article
How to Connect to Databases Outside of Alteryx.
View full article