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.
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.
In developing workflows our users need to push workflows to server or scheduler that contain database connections. This is a common source of errors if not configured properly.
We hope that you are as excited about this new feature as we are! The new Database Connection Share is a feature that will allow ease of access for your Alteryx users to your databases. The feature also allows the Alteryx Gallery and Database Administrators more governance over what connections are being made as well as who are making the connections. The Admin of the Gallery can create and manage their users' data connections.