This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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 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.
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)
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
Back Up and Restore Connect Database via Command Line