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.
1. SQL server connections are created manually in an Alteryx "Import" file with all active SQL servers. When a new server is added or removed, a dedicated user goes into the Workflow and creates or deletes the connection string / query.
2. They also modify the server listing on an internal Sharepoint site which is connected to in a different Workflow file at a later point.
Is it possible to simply read all of the servers from the Sharepoint file and then generate a dynamic connection to each server from that? I can get an output from Sharepoint with the server name and write a formula with the connection string and query with no issues. The issue is to create a dynamic connection to connect / query based on the number of servers listed that day in the file. Is this possible in Alteryx?