Querying Connection Names

Has anyone experimented with querying the available connections that are utilized by a machine?

For example I want to build a macro that allows the user to just select a connection to be utilized within the macro.

Now I know that I can just have them type it in and it will just pass through or something like that. But I want to take it to the next level!

Ya dig?

Treyson

Macros

Alias Manager

Accepted answers

Claje

If you're looking to leverage Alteryx Aliases, @jdunkerley79 has a great solution here on how to accomplish this.

If you are looking to use more complex information, you may need to look for other configuration settings.

EDIT:
If you want to avoid running command prompt, as in the example i cited above, you can also skip it by using a formula as follows:

GETENVIRONMENTVARIABLE('APPDATA')

This will return the same information that is pulled by the Run command, regex, and filter tools in the solution I referenced. You will need at least one record incoming to use the formula (I recommend a text input tool with one dummy value)

All comments

CharlieS

So you want to retrieve a list of the configured System DSNs? This is a bit beyond me, but I read here about how you can retrieve this information from the registry. So if you can execute that code, you should be able to return the values you desire.

Claje

If you're looking to leverage Alteryx Aliases, @jdunkerley79 has a great solution here on how to accomplish this.

If you are looking to use more complex information, you may need to look for other configuration settings.

EDIT:
If you want to avoid running command prompt, as in the example i cited above, you can also skip it by using a formula as follows:

GETENVIRONMENTVARIABLE('APPDATA')

Treyson

This is what I was looking for. I wonder if it's different since Alias' aren't exactly a thing anymore. It should work the same I think?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703