Alteryx Server Knowledge Base

FAQs about Gallery Data Connections

This workflow downloads all workflows from a Server to a local machine using the V1 API endpoint /webapi/admin/v1/workflows and the V3 API Pack, then parses through the XML to search for a specified term (such as tools used, database connections, DSNs, queries, versions, etc.).

Updating to either 2021.4.2.47792 (Patch 5) or 2022.1.1.3.42590 (Patch 3) results in a failed schema migration if customer has any Gallery Data Connections established that contain empty passwords in their connection strings.

A few tips to help customer optimize db read and write speed. Please note that this is a gray area in terms of Support.

Driver configuration can impact how the data connection performs on a given machine.

Identifying bad network routes or firewall issues affecting Server nodes or data source hosts

How to set up a Bulk Loader Connection in Gallery.

How to connect to Alteryx Server MongoDB using the command line

This article details the steps and best practices for users who need to run In-DB workflows on the server

This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T

Error: "Validation failed. The input value is greater than 9999" when using DCM Data Source > Oracle Quick Connect menu.

When saving a workflow to the gallery, the following error occurs: Tool ## - Error finding connection "connection_name".

User is running workflow on gallery and getting a GSSAPI error

Snowflake Error in Gallery after running workflow: failed:CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error' osCode=2 osMsg='No such file or directory'

A FATAL connect error occurs when trying to publish a workflow to the Gallery that connects to a PostgreSQL database with Kerberos authentication.

21.3 defect impacting workflows with a Gallery Data Connection

Troubleshooting "Unable to translate Alias" with Gallery Data Connections

Error while publishing workflow to the Gallery

Upgrade from Alteryx 2019.4.8 to 2021.2.1 and experiencing intermittent connectivity issues between Designer/Server and Azure SQL databases.

Running a workflow with a database connection in the Gallery in a multi-node environment gets an error despite the connection working in the controller's instance of Designer. This is caused by not having a matching DSN or driver on the worker nodes.

When the option "Allow user alias to override the system alias" in Alteryx System Settings is selected the relevant UserAlias.xml file will be used rather than the System Alias. If after a credentials or other data source configuration change only the system connection was changed the user connection will be still used and this can cause the workflow to fail running in Designer or uploading to Gallery.