Trigger workflow using Control M

[mhiko-s]

Hi all,

I am currently working on a project and we are planning to use Alteryx for data preparation. The team is very pleased with the tool as we were able to transform our data easily with it. The only thing that we are worried about is its deployment in our environments.

We are aware that Alteryx has its own scheduler and we have tried it but we see no option in the scheduler to integrate with other scheduling tool.

What we are planning to do is to trigger the Alteryx workflows using control M as we have existing jobs in control M that should be finished first before executing the Alteryx workflows. Is this possible?

Thanks in advance.

Mhiko

[BenMoss]

Hi  mhiko-s,

I don't think this is possible no, i've seen a number of people trying to use different windows systems to trigger alteryx designer to run as a schedule but they have always failed in their attempts. 

However, perhaps you can use an external programme if you do have Alteryx scheduler installed, that I do not know. 

Further to this it may be worth opening up your question for potential solutions on how to integrate Alteryx scheduler with your other scheduling tools, because it may be possible.

Ben

[mhiko-s]

Hi Ben,

Yes, we have the Alteryx Scheduler also installed. So our best option is to integrate Alteryx scheduler with a third party scheduler?

Mhiko

[KaneG]

If you have Alteryx Server, then you are able to kick off jobs via CmdLine and API. This won't work if you don't have a scheduler licence.

Here is some information on scheduling from the command line.

API information can be found at <Your Gallery URL>/api-docs. Information on getting your secret and key can be found here.

I believe that you would be able to use Control-M with either of the above situations, however it means that you miss out on some of the Alteryx Scheduling capability by not using the designed GUI.

[deethesh]

Hi All , 

I'm using Informatica for any ETL works , for which I'm using Tivoli work Scheduler ( TWS) . But now I need to use Alteryx for ETL works and use TWS for scheduling and triggering Job , can anyone advice on whether we can trigger Alteryx workflows using TWS ( 3rd part scheduler ) 

[gerconn]

We have implemented this by getting Control-M to call a shell script which then triggers an Alteryx app via the API. That app contains a number of workflows which are kicked off in sequence using the Crew Macro Runner tools. 

[Raghu_s]

Hey, just a check. So you have the scheduled installed along with designer? Curious to know if its other way round. 

[chamarthivamsi]

Hi

We have a requirement to call workflow from Control-M. can you please provide the detailed steps how to write the shell scripts to call the alteryx workflow.

[JohnBell]

Hi,

I'm not too familiar with Control M jobs, but I know we have a few Control M jobs apparently calling Alteryx workflows...here's my take...

1) As an Admin I don't appear to have visibility since they're not a "scheduled" workflow

2) I've found the Control M jobs by going thru the Engine logs

3) I've noticed (but can't proof) that even though the control M job has completed it seems to take a lot of resources.  I have a sequence of workflows that run every 2 hours without issue except on the hour when the Control M job is running.

Can anyone send me a link or give me additional information so I can better understand the nuances of Control M jobs with Alteryx...and why would one want to use Control M when we have Alteryx scheduler?

Thanks in advance...

[jasonMMedina]

@KaneG

Will running the AlteryxEngineCmd myModule.yxmd put the job at the front of the queue?

I am looking for a way to execute a workflow with High priority.  Is there a CL option for addtoqueue or will calling AlteryxEngineCmd push the job to the top of the queue?  Thank you.