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

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Gallery data connection in macro

Highlighted
Quasar

Hi all

 

I have a macro that contains a SQL connection from the Gallery. The macro is saved on the server. We run workflows on our own credentials (no run as).

 

I am an admin on the server and so when I publish workflows to the server I don't need to attach Gallery connections as assets. However now others (artisan, no admin access) want to use the tool, but I'm not quite sure how to make the Gallery connection within the macro available to be attached as asset when saving to the Gallery. It currently says missing. The only thing I can think of doing is to place an input tool with the same server connection into the workflow to force it to be available as asset. That however does not seem very elegant.

 

What is the best approach to this?

 

Thanks

Katrin

@kat 

Unfortunately this is a known problem that doesn't appear to be getting any love from the developers;
https://community.alteryx.com/t5/Alteryx-Server-Ideas/Supporting-Gallery-Data-Connections-in-Macros-...

 

Are you going to Inspire19?  Maybe we can get a posse together and force the devs to pinky swear they'll fix this.  ;-)

 

 

Best,

David

 

Quasar

@David-Carnes , unfortunately not, you'll have to fight the fight yourself. I'll be rooting for you :)