Alteryx Connect Knowledge Base

The 2021.1 release brings the following features: Health Checks and the possibility to enable users to be automatically redirected to SAML IdP.

When trying to reach the H2 database from another computer, the DSN test fails.

There are three authentication options in Alteryx Connect that an Administrator can configure for their environment: Manual auth, Windows AD auth, and SAML auth. Please note that Manual auth is always a fallback option, even if you’re using Windows or SAML, which is a notable departure from Gallery authentication, which does not allow mixed authentication modes.

The 2020.4 release brings several features such as Notification Queue, new Custom Field type, the Alteryx Designer Tool Details section for analytic workflows, many improvements for metadata loaders, and more.

Defining a Lucene query is required for adding items to a new Connect Virtual Folder. Reference the Lucene documents for the items you want to add to find the correct parameters.

Everything you need to know to manage users and permissions in Alteryx Connect!

Since the introduction of Custom Fields in Connect allowing to define your own fields (for example to assign Terms and fill in respective values), we have received many questions on whether you can automatically load these fields. As of now – in Connect 20.3 - the answer is YES; you can do it for database assets! In this article we will show you how.

We're constantly working to improve your Connect experience. Here's a summary of new features, improvements, and bug fixes in the version 20.3.

Find out what new features, improvements, and bug fixes we released with this version of Connect! The 2020.2 release brings several new features such as new Admin Menu or Active Directory integration.

The purpose of this document is to describe the manual steps to deploy Alteryx Connect on the PostgreSQL database. This document is valid for Alteryx Connect 2020.2 or newer.

The newest release of Connect is here! With Connect 2020.1, find out what new features and improvements we released! Here is a summary of what has changed.

The purpose of this article is to describe the steps how to deploy Connect on the MS SQL database.

Error on Alteryx Connect - Kerberos authentication is not supported on the Gallery Server

In this article, you will learn how to update data assets in bulk using the import and export feature in Connect. In our examples we'll be updating data asset owners and changing the group membership of users by exporting, updating, and later importing an XLS file.

Backing up Connect can easily be done from the Administrator Console via the Connect web page. Please see the following Help article for details steps: Back Up and Restore Connect. However, for various reasons it may be advantageous to do the backup via the command line or a script. This article walks you through how to do this.

This tutorial contains information about Custom Fields. You will learn how to create, assign, and configure a Custom Field in the Connect data catalog.

This article provides instructions for adding a self-signed SSL certificate to the web page hosted by Alteryx Connect so that the page is served securely.   Note: This article is only intended for Self-Signed Certificates. A self-signed certificate is not recommended to be used for production purposes. This is because self-signed certificates must be installed on all of the machines you intend to use with Connect as a trusted certificate. This includes any machines that will use Connect applications like loading metadata in Alteryx Designer or using search results from Connect Designer.  

This article provides instructions for adding an issued SSL certificate to the web page hosted by Alteryx Connect so that the page is served securely.   Note: This article is intended for trusted certificates in your environment. You must have a copy of the certificate (such as .crt) and the signing key (such as .key), or a combined certificate file (such as .pfx or .p12) in order to complete this process. This certificate must be installed on all machines you intend to use with Connect as a trusted certificate if these machines are to be used in conjunction with Alteryx Connect, such as loading metadata with Alteryx Designer or search results from Alteryx Connect displayed within Alteryx Designer.

How To: Connect to the H2 Console   Connect has an interactive console for the H2 database that allows administrators to browse the database and execute commands. Follow the below steps to enable and connect to the console.   Prerequisites   Alteryx Connect   Procedure   Follow steps 1-6 under Enable access to the Connect database found on the Review Connect Usage Information Help page Navigate to http://localhost:8082 on the Connect Server If you have the firewall open, you can access this from another machine using the IP or the hostname in place of localhost (i.e. http://hostname:8082) Fill in the JDBC URL and the Password   For the JDBC URL, enter the value for the Master DB JDBC string found in the System Info section of the Connect Administration Console The database password is set by the Connect Administrator during installation. Your Administrator can reset the password in the Connect Console under Connect Configuration > H2 Password Click the Test Connection button You should see 'Test Successful'. If not, please double-check your connection information above Click the Connect button to enter the H2 Console A successful connection will show the console with the below schema (shows as folders on the left)   Common Issues   I don't see the STD_XFORMS database schema You have an invalid JDBC connection string - please confirm your JDBC URL found in the System Info section of the Administration Console    Additional Resources   Back Up and Restore Connect Database via Command Line

“A single point of entry into the world of data giving knowledge workers the power to discover and understand relevant data assets to their business”