My organisation's on premise SQL server has recently been moved to a new location. It now has a new server name, but I can still the access the data tables via Alteryx Designer using my windows authentication. My question is...how can I update an existing Alteryx Designer workflow on the Input tool to access the new SQL server with a new server name, without having to change anything else, i.e. table name/query, field names, etc?
@Samantha2020
We use the Drop Down, Action tools to replace the server database part.
Sorry I can not give a sample, but this the image.
You will only need to update the Drop Down by adding new entries.