Alteryx Server Knowledge Base

Definitive answers from Server experts.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

One of the three database options when setting up the Alteryx Server is to connect into a User-Managed MongoDB instance. Why would you want to set up your own implementation of MongoDB? The main benefits are to take advantage of the features of MongoDB that are not included with our embedded instance.
View full article
Properly reading Alteryx Server logs will significantly help in the resolution of Alteryx Server issues. This article will help you understand and focus your search within the logs.
View full article
One of the three database options when setting up the Alteryx Server is to connect into a User-Managed
View full article
After having used MongoDB logging for troubleshooting purposes, you can now safely turn it off.
View full article
Capture and Generate HAR file on the Gallery
View full article
There are occasions where it is necessary to identify the ID of a Workflow or Schedule. These are easy to find in the URL.
View full article
When uploading a Workflow to the Gallery with Business Insights data, you will get an Error message saying that the "Datasets cannot be shared in public gallery". A Gallery Administrator can resolve this error by editing the Workflow Settings.
View full article
Configure the Gallery SMTP server using a Gmail account
View full article
How to guide to configure the setup and configuration of SAML through Azure AD on Alteryx Server.
View full article
After uploading a workflow to Gallery, you can make changes and manage multiple versions.
View full article
How to determine which User deleted a Gallery application
View full article
As Alteryx analysts, we’re whipping up insight at blazing fast speeds. Workflow after workflow, tool after tool, we’re gleaming functional understanding from inert webs of data that empower us to make better decisions. Good insight is only as good as it is shareable, however, and to enable better sharing any Alteryx analyst can take advantage of their Workflow Dependencies to simplify input or output path dependencies in shared workflows.
View full article
This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T
View full article
How to setup a SQL Server Bulk Loader Connection in Gallery.
View full article
Overview and suggestions on how allow multiple AD account to run specific workflows using specific credentials.
View full article
Engine logs are a useful when troubleshooting Engine related issues. They contain the output of messages created when a workflow runs, as well as the time stamps when tools run in a workflow.
View full article
How to Clean Up Duplicate Workflows In the Gallery
View full article
How To: Adding a Worker Node   Many customers need to expand their Alteryx Server environment to support a growing number of users, additional departments, increased data sizes, frequent job queuing, or a myriad of other reasons. This document walks through the process of adding a Worker Node to an Alteryx Server environment. These steps apply regardless of the size of the existing Alteryx Server environment.     Prerequisites   Product - Alteryx Server Additional required assets: Controller Hostname Controller Token Alteryx Server and Data installs ODBC Drivers   Procedure   Provision a new physical or virtual machine meeting the Alteryx Server minimum requirements, which are 4 cores, 16GB RAM, and 1 TB Disk. It is recommended to w ork with your Alteryx representative to understand what is an optimal system setup for your use cases, data set sizes, and business requirements.  Install applicable ODBC Drivers and configure System or User DSNs to match the existing Worker(s). In-Database connections should also be created for any data sources where In-Database processing is being used. Install Alteryx Server and any Data packages using the same install files from your existing Alteryx Server environment. This ensures version compatibility between the Controller and the new Worker Node. There are a couple of ways to verify the same version is being used. Check the version reported in Gallery at  https://MyGalleryHostname.com/#!help/version Check the version reported by Alteryx Designer running on the existing Alteryx Server machine. Ensure this matches the version reported by the file name of the Alteryx Server installable on the new Worker node. On the Alteryx Server Controller machine, open the System Settings and navigate to the Controller -> General section. Copy the Controller Token and save it for step 6. On the new Worker Node where Alteryx Server has been installed, launch the System Settings wizard. For the Environment Setup Type, choose Custom - Enable Worker.  Continue to the Controller -> Remote section. Enter your Controller Hostname and paste the Controller Token saved in step 4. Click Test to ensure the Alteryx Server version, Controller Hostname and Token match.  Configure the Worker and Engine settings as desired. Typically this involves matching the settings of an existing Worker but there are situations where it makes sense to have different settings across Workers, such as the number of workflows allowed to run simultaneously, QoS settings, Job tags, Map Rendering, etc... An example Worker Configuration Complete the System Settings wizard and validate the AlteryxService is Running on the new Worker node. Validate the new Worker shows up in the Gallery Admin -> Diagnostics page in the Workers panel.  Ensure the new Worker has access to any locally stored Macros or data sets. It is recommended to move all locally stored Macros and data sets to a network share or similar storage device that is accessible by all Workers, and then update Workflows based on the new locations. Storing files locally and copying to all Workers isn't recommended as it requires a method to keep them all in sync, increases data storage requirements, and introduces version differences across the environment.  Finally, run a few representative workflows through the new Worker to verify everything is working as expected.   Conclusion   With just a few simple steps a new Worker node can be added to an Alteryx Server environment to provide redundancy, higher throughput, shorter job queue times, and many more benefits.      Additional Resources   Worker System Settings Considerations for Scaling Alteryx Server Measuring and Scaling a Private Server Scaling a Private Server: Five steps to greater throughput
View full article
How to check what's using the port and steps for changing some services' default port!
View full article