community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Dynamic DB connections

Current solution exists as such...

 

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?

Labels