Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
View full article
No Teradata Parallel Transport logs are being created when a workflow, that includes a Teradata Bulk Connection, is executed.
View full article
Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to data source
View full article
Stored Procedures are powerful and helpful, however, in Designer and Server it is required for them to have a return value. If that is not the case the error "no columns returned" will occur.
View full article
For a SQL Server connection, the Test Query in the SQL Editor is returning with message "Error opening : No Columns Returned."
View full article
How to fix an error during installation that says "The feature you are trying to use is on a network resource that is unavailable".
View full article
Error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB'" when converting an ODBC DSN-less connection to OLEDB
View full article
Visual Query Builder does not populate schemas containing only views for Snowflake
View full article
This article details different methods for connecting to an Oracle database from Alteryx.
View full article
How to set up a DSN-less connection to Salesforce that allows you to specify which version of the API you'd like to use when outputting data.
View full article
Unable to configure or select Simba Oracle driver in system ODBC dialogue due to system error code 126
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
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
Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.
View full article
The guide covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, CROSS JOIN, WHERE BETWEEN, WHEREIN, DISTINCT and we hope you find it helpful.
View full article
When doing Teradata bulk loader There's no difference between the two output options Append (Ignore Duplicate Rows) and Append (Mark duplicate Rows).
View full article
Troubleshooting Database Connections
View full article
We are proud to introduce you to the Manage Data Connection functionality in 11.0!
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
Below is a quick overview of how the different types of database connections appear within "workflow dependencies." This will help determine and compare different connection types from a quick glance.
View full article
How To: Gather ODBC Logs for troubleshooting
View full article