Event based trigger (AWS SQS) in combo with Alteryx Desktop Scheduler (no Server)

Question

Hi all,

I've tried to find similar topics but couldn't find any (please correct me if I'm wrong).

I have a situation where I use Alteryx Desktop Scheduler (not Server) to run multiple workflows on schedule with intervals as low as hourly. One requirement is to run one of the workflows based of a trigger from AWS SQS messages (or file changes in AWS S3).

What is the best solution to make that happen? I can't use the event trigger macro (workflow running 24hrs re-iterating until the event happened) as that would block the other workflows from running causing an indefinite queue. I also can't use the Gallery API as there is no Server license.

I was thinking if the specific workflow which is event triggered could be set up in windows task manager on the same machine/computer, but i'm not sure if it will cause a conflict if Alteryx+Scheduler is active in 2 instances in parallel for the period of time that the event based workflow runs in a separate Alteryx+Scheduler instance. Not sure if the second instance will also start triggering the workflows that are on the scheduler.

My proposed solution in summary, running on a Windows Server:

* Alteryx+Scheduler running 24/7 executing all scheduled workflows
* Alteryx+Scheduler running in parallel instance for a short period of time (random time of the day) in parallel to the Alteryx+Scheduler running 24/7

Thanks,

Thomas

hugoscaper · Answer

Hi @ThomasT 
if you can provide what to send and you can send me via email, follow my contact: hugoscaper@gmail.com

ThomasT · Answer

Hi @hugoscaper

we've ended up purchasing Alteryx Server. At this point we are not pursuing event based triggers from SQS but it would be easy to manage with Alteryx Server.

Also, I've realised that you can run multiple workflows in parallel when using Alteryx Scheduler. The system setting allow that change and it would resolve my question from the top.

Please let me know if you need any other info on SQS API or similar. We had a working system at some point and I can provide more details on the python script/alteryx workflow

hugoscaper · Answer

Hello, @ThomasT

I'm more or less in the scenario you are, did you manage to resolve this issue?

Do I have access to the alteryx server and need to consume or send messages to SQS queues in AWS?