Hi,
I've two graphs (Graph1 and Graph2) in a server environment and calling Graph2 from Graph1 using RunGraph component. Also the graph name is received in Rungraph component thro' port0-field1. Since it is a server environment, i'd to set "The same JVM" to false and therefore cannot pass parameter values to Graph2 either thro' field1 of port0 or thro' "command line arguments" . Now i see the only way to pass parameter value is "Graph parameters to pass" property. It looks like i can only pass workspace parameter values which are of mostly static in nature. But my requirement is to pass a dynamic parameter value to Graph2 which will get invoked three times with different parameter values each time. how should i achieve that?
Say "value1" for the first invocation of Graph2, "string2" for the second invocation, "text3" for the third invocation of Graph2.
One option i tried out is setting workspace parameter value dynamically in a transformer component before coming to Rungraph component.
getGraph().getGraphProperties().setProperty("parametername", parametervalue );
but that doesn't work.
Any suggestions?
Thanks,
Senthil
I've two graphs (Graph1 and Graph2) in a server environment and calling Graph2 from Graph1 using RunGraph component. Also the graph name is received in Rungraph component thro' port0-field1. Since it is a server environment, i'd to set "The same JVM" to false and therefore cannot pass parameter values to Graph2 either thro' field1 of port0 or thro' "command line arguments" . Now i see the only way to pass parameter value is "Graph parameters to pass" property. It looks like i can only pass workspace parameter values which are of mostly static in nature. But my requirement is to pass a dynamic parameter value to Graph2 which will get invoked three times with different parameter values each time. how should i achieve that?
Say "value1" for the first invocation of Graph2, "string2" for the second invocation, "text3" for the third invocation of Graph2.
One option i tried out is setting workspace parameter value dynamically in a transformer component before coming to Rungraph component.
getGraph().getGraphProperties().setProperty("parametername", parametervalue );
but that doesn't work.
Any suggestions?
Thanks,
Senthil
-
Hi Senthil,
please take a look at this post viewtopic.php?p=8588&sid=9dd19d1afe8aeff1f2cf14c8e0525352#p8588 for working sample. Problematic aspect of this is the fact that this code works only for one execution - when more input records is sent to Reformat the parameter is overwritten.
Best option is to upgrade to CloverETL Server Corporate version 3.3+ where component http://doc.cloveretl.com/documentation/ ... graph.html is available. It would allow you to pass parameters in simple and extremely easy fashion. -
Hi Jaroslav Kubos,
Thanks for the suggestion. Yes, my question was exactly about executing the Rungraph for more input records. In a local ETL project in designer, i could set the "same JVM" to false and pass invoke the Graph2 multiple times with different parameter values using "Command line arguments" property. But that approach cannot be applied to server environment because of the "same JVM" property.
i) So commercial component is the only way to accomplish that in a server environment? How can i get more details about upgrading to corporate version?
Please sign in to leave a comment.
Comments 2