Dynamic DF or WF execution

[Former Member]

Hello all,

I need to know if it's possible to create a Job which launch dynamically a Dataflow or a Workflow based of value retrieve for example from database or calculated variable.

The idea is to develop a generic Job without nested if, but a job using a script for retrieving the name of the Dataflow and submit its execution.

Regards

Laurent

[former_member271656]

Hi Laurent,

I think you can use parameters to achieve this. Have both the things in Work Flow, and add a condition using the parameter. Hope it works.

Thank you!

Warm Regards,

Abdul Majeed Mohammed

[former_member187605]

Sure, use a series of Conditional objects (cf. section 2.3.5 in the SAP Data Services Reference Guide), one per flow you want to execute.

[Former Member]

Hi Dirk,

Thank you for your answer.

Yes, it's a possibility, but my first idea was to create a script ( or something else) to execute dynamically a DF or WF, without using nested conditionnal step.

For example:

Script

   DataFlowtoExecute = read a dataflow from a parameter table () ;

   ResultValue= RUNDATAFLOW($DataFlowtoExecute );

...

Do you think it's possible ?

Regards

Laurent

[former_member187605]

No that's not possible. You cannot run a data flow from a script.

The unit of execution in DS is the job. So, you can do this with jobs only. You could design a separate job for every single data flow. But I do not think that's a good idea.

[Former Member]

It's a pity!

Thank You