Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Troubleshooting Database Connections
View full article
How to Sort with IN-Database tools
View full article
This article provides answers the most frequently asked questions related to In-Database Tools.
View full article
Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.
View full article
During run time of workflow, the following error is received:
View full article
This is a workaround for connecting to an Oracle database that uses LDAP authentication.
View full article
How To: Create an In-Database Connection
View full article
Select Tool fields show as missing & data types show unknown when querying from a database
View full article
Create a ‘Random’ sample using In-Database tools
View full article
When setting up your database connection you may be unsure whether selecting a user or system DSN is the best option. This article will guide you through the process.
View full article
As users collaborate, the sharing of workflows that connect to databases can be helpful. The In-DB Connection File type allows for this. A database connection is saved as an .indbc file so it can be packaged with a workflow.
View full article
Have you ever wondered what query was being sent to your database at a certain point in your workflow? This article will guide you through a relevant workflow
View full article
"No table chosen; Please select a Table from data source".
View full article
"drop table" command with IN-DB tool doesn't work with IN-DB tool
View full article