Is this still true in the current version?
I have many graphs that I set up with parameters. Most of those use the parameters in the where
clause of SQL queries. If I want to convert these to Launch Services on my CloverETL server, do I have to convert all of those parameters to dictionary entries, or is there another way?
Thanks for any suggestions.
Unfortunately using dictionary in DbInputTable is not supported.
* prepend DataGenerator in front of DbInpuitTable and set it to produce exactly one record
* in transformation of DataGenerator generate your SQL query using http://doc.cloveretl.com/documentation/ ... -ctl2.html
* connect DataGenerator and DbInputTable via edge using metadata containing at least single string field (containing SQL query)
* set DbInputTable to read data from input port; see input port section of http://doc.cloveretl.com/documentation/ ... table.html
Please let me know if you have further questions.