Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to format common ODBC DSN-less connection strings
View full article
Corrupted Data when writing V_STRING, V_WSTRING, WSTRING to a CLOB using OCI or when writing V_STRING to a CLOB using ODBC
View full article
This article details different methods for connecting to an Oracle database from Alteryx.
View full article
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
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
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
View full article
When using special charater "≥" value in a database Input Data tool, the field displays as "=".
View full article
Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.
View full article
Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname
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
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