How To: Manage Data Connections
The Manage Data Connections allows you to create new connections and sync your Designer with database connections that your Gallery administrator has shared with you. For some FAQs on Gallery Data Connections, please refer to this KB article. It is the central hub to manage both regular database connections and in-DB data connections; see also this comprehensive Help Doc page.
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 links to these drivers here under the respective Data Source.
Manage Data Connection is located here:
Manage Data Connection Window:
How to update a 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 and password 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.
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:
Alteryx Help Doc - Managing Data ConnectionsKB Article - Gallery Data Connections