Pass Metadata and Filename as Parameter in Designer

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

pfield
Posts: 7
Joined: Thu Mar 19, 2020 3:46 pm

Pass Metadata and Filename as Parameter in Designer

Postby pfield » Wed Mar 25, 2020 6:22 pm

Hi,

I would like to somehow pass in a filename and metadata to a graph via parameters. I did this before using Server but am now restricted to Designer and want to know if this is possible?

What I would like to happen is to have a parent graph feeding the child 2 parameters:
1) File Name (to be passed into the Reader URL)
2) Metadata (Metadata is externalized and would be used by the edge coming out of the Reader)

This way, i can use the same graph no matter how many files I need to read. Hoping there is a solution...

Thanks,
Paul

dpavlis
Posts: 185
Joined: Sat Mar 10, 2007 8:12 pm

Re: Pass Metadata and Filename as Parameter in Designer

Postby dpavlis » Thu Mar 26, 2020 6:29 pm

Hi Paul,

This is exactly what Server and JobFlow components are good for. If you need this to work in Designer without Server then you need to use parameters (external parameter file) and re-create the content of the parameter file each time with new values before you run the child graph. There is also no direct way how to execute child graph from within parent graph on Designer - again something easily done on Server through JobFlow, but with Designer only this means manually execute parent graph (which modifies some parameter file) and then manually execute child graph.
David Pavlis
CloverCARE Support
CloverDX | Rapid Data Integration

Visit us online at http://www.cloverdx.com

pfield
Posts: 7
Joined: Thu Mar 19, 2020 3:46 pm

Re: Pass Metadata and Filename as Parameter in Designer

Postby pfield » Thu Mar 26, 2020 8:14 pm

Thanks for the reply David.

Would there be anyway of passing a parameter via RunGraph using command line arguments? See related post below. This would allow for some form of synchronous execution.

https://urldefense.proofpoint.com/v2/url?u=https-3A__forum.cloverdx.com_viewtopic.php-3Ft-3D4576&d=DwMGaQ&c=tq9bLrSQ8zIr87VusnUS9yAL0Jw_xnDiPuZjNR4EDIQ&r=G3WmcsdBDGCmkCl7b1Ipe-ZSjXFSn856hSZy51xAqz4&m=6RzOjMN5sNIrM8LbBA70rnco_QwzrkUqfBP44NPpY7w&s=1LvATZPpTuf86Do2IPzHGOY5_RaQIJ31jAHtx1jJNN8&e=

Paul