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.
We are proud to introduce you to the Manage Data Connection functionality in 11.0!
This new functionality will replace the Alias Manager.
The reason for this upgrade is twofold: first, we wanted the ability to create and manage aliases to become part of your database connection process as it will make users life easier when updating passwords and remembering what connections connect to where. The second reason is to have another one of our new functionalities (Database Connection Sharing) seamlessly integrated with users own database connections.
The Manage Data Connections allows you to create new connections, update passwords for existing connections, and sync your Designer with database connections that your Gallery administrator has shared with you.
We have started the New Connections without new Microsoft SQL Server connection and Oracle connections. We also have Other, where the connection string can be added to connect a database that Alteryx supports. Please be advised the appropriate driver will need to be installed in order to connection to the database. You can find these drivers here: techspecs.
Manage Data Connection is located here:
Manage Data Connection Window:
How to update password or connection string:
Hover over the connection that you would like to update and select the pencil. Another window will open, where you can update the information except for the name you have provided for the connection. You will not have the ability to update connections that have come from your Gallery Administrator. If changes are needed or you are having issues with the connection please reach out to your Gallery Administrator for assistance.
Issues connecting using the Other function, please make sure that your connection string and password are correct, as well as the appropriate driver is installed on your machine.
this error icon will appear when a Gallery connection is no longer available. Please reach out to your Gallery Administrator for more information.
If you find that when you open your Manage Data Connections and you do not have the ability to update your System connections. You will need to run Alteryx as an Admin user. Once Alteryx is run by an Admin user they will be able to update the password for User and System connections. Gallery will need to be updated by your Gallery admin no matter your permissions on your machine.
If, when using a Data Connection, you see the 'Resolve File Type' window, there is something wrong with the Data Connection: