Executing system commands from CloverETl graph

CloverDX Platform
1

Hi,
we want to run one utility from the ETL graph and also needs to pass some parameters to it.
Is it possible in clover tool ? if yes please give some idea of which component needs be used and how to use it?

does SystemExecute component can be used if yes how?

command prompt command is as follows:
highligheted part is parameters for the utility.

c:\utility.exe MyDataBase sa “” sa “” testlog.txt Y

Thanks!
Tushar

2

Hi Tushar,

yes, SystemExecute is good component for your purpose. If you have static command, just use “System command field” and put there your command like “cat /etc/issue”. When output is connected, you will get STDOUT on edge.

If you need to pass parameter dynamically please see following:
* viewtopic.php?f=4&t=5241
* viewtopic.php?f=4&t=6592