Execution of multiple Workflows based on a scheduler and event on Gallery
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all.
I am working on a scenario where I have 5 workflows each of which take the exact Input data in the form of an Excel sheet
The excel sheet itself is generated by a Master Workflow. The flow of execution is as follows:
- Scheduler executes Master Workflow
- Master Workflow generates an Excel sheet
- All the other workflows run one after another in a sequential fashion (the ordering of which is fixed)
Note - All the later workflows are exclusive and don't depend on the previous one to end successfully. They are just running in a fixed sequence
Now I am not able to get any idea as to how to run this on Gallery. Any suggestion would be most welcome
Thank you for your precious time and suggestions. Have a great day ahead
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fardeen9983 - Workflow orchestration can be organised in a couple of different ways in Alteryx. From an Alteryx perspective, there are several forms of orchestration to consider:
- Intra-workflow orchestration: the coordination of data via connectors, preparation and blending of that content, followed by spatial and advanced analytics leading to the repeatable production of analytic datasets containing business insight.
- Inter-workflow orchestration: the coordination of multiple workflows (including chaining and branching) with dependencies between the elements in the chain.
- Inter-service orchestration: the coordination of workflows and external applications on a wider enterprise basis.
Each of these is covered in the sections below. For easy reference, a summary of the orchestration options are provided in the grid below.
| Intra-Workflow | Inter-Workflow | Inter-Service |
Block Until Done | X |
|
|
Batch Macros | X | X |
|
Runner Macros |
| X | X |
Events |
| X | X |
AlteryxEngineCmd |
| X | X |
AlteryxService |
| X | X |
Gallery API | X | X | X |
Scheduler | X |
|
|
Hope the above will help you to chose the best for your use case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ArtApa
I am looking for the Solution involving Inter Workflow orchestration
As far as I have read and I might be incorrect, that Events and Runner Macros are not allowed to run on a Server/Gallery environment
And it would be very helpful if you could give a bit more details about the chaining of workflows and sharing the output of one workflow to another
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fardeen9983 -
- You can use Alteryx Events to launch additional workflows (see https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Scheduling-Workflows-Using-Event-Run-Command... ). This requires some command line scripting to ensure that jobs are added to the scheduler queue, some example configuration is in the link above.
- Deploying the Conditional Runner to a server would involve packaging up all required assets (including workflow yxmd files) as part of a single server-based workflow. Any changes to the underlying workflows in the chain would require a redeploy of the conditional runner orchestration workflow. However, CREW macros are an Alteryx product, that's why not officially supported by Alteryx.
Does it help?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @ArtApa Thanks for the Solution. I would follow through the article
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In @ArtApa 's last comment I believe that there is a mistype... It should have read
However, CREW macros are NOT an Alteryx product, that's why not officially supported by Alteryx.
Now, in 2021.4 that is slightly out of date as 2021.4 there is an officially supported version of AlteryxRunner.exe BUT only for Designer.. still no support on Server. The use of the new V3 API's are targeted as a solution for better workflow orchestration
