Normally when implementing ETL solutions with Alteryx, I tend to stay away from the Gallery, but I'd like to leverage the gallery as a maintenance/monitoring resource. The two big issues I am facing that I hope someone can help out with are:
Any help is appreciated !
Best,
devKev
Hi,
When you say Alteryx Gallery, are you referring to gallery.alteryx.com? Or to a server that is specific to your organization?
This is important because you can enable Runner Workflows/Run Command within Alteryx Server if you own it yourself.
I think that a combination of Runner/Conditional Runner could potentially get you where you need to go in terms of multiple workflows being run. You could leverage a database table/file in order to make this schedule configurable without redeploying your code.
With regard to enterprise Gallery publishing, features are currently somewhat lacking. I have an Idea posted to add some options for publishing workflows via an API call or some coded/automated deployment method.
If you could star this post it would be greatly appreciated!
https://community.alteryx.com/t5/Alteryx-Product-Ideas/Add-a-method-for-scripted-deploys-to-the-Alte...
Our organization has leveraged our deployment of Alteryx Server by using a self-created .bat file template which leverages the AlteryxEngineCMD on server to execute jobs. As I recall, there are options to add workflows to queue in Gallery via Command line as well - this could potentially provide some value for you.
If you need some pointers on diving into any of this, I'm happy to try and help where I can.
Hi Claje,
Thanks for the response! I am indeed using a Private gallery so you are right, I can in fact use the runners/ run command. The issue there is that I still need to provide those types of tools the location of the workflow I want to run. Do you have more insight into where these files are actually stored when you publish the workflow to the gallery? Are they in the same location and I could leverage relative paths?
Right, most of the ETL environments I have deployed have either been built around .bat commands triggered on a scheduling software or simply alteryx scheduler (neither involving the Gallery). May have to resort back to that
Best,
Kevin