Gallery data connection in macro

kat

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

David-Carnes

@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-run-on-Private/idc-p/351874

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