Page 1 of 1

Dynamic value for DBInputTable component configuration

Posted: Thu Oct 22, 2015 11:53 am
by zed.yap

Is it possible to configure the DB Connection configuration in DBInputTable component via data coming from input port? Or if there any ways to achieve this?


Re: Dynamic value for DBInputTable component configuration

Posted: Mon Nov 02, 2015 3:36 pm
by cholastal
Hi zed.yap

It is not possible to change the DB connection configuration via input port, however you can create variable connection configuration by inserting parameters (e.g. ${HOST}) into the connection string. However these parameters are replaced with real values usually during the initialization, so the values have to be known before the graph starts. I'm sending you an example graph, where such connection is set. In case you want me to help you further, please specify the way you want to acquire the input data for the connection string and what version of Designer and CloverETL Server (if you have one) you are using.

You can also find additional information about parameters in our documentation.

Thank you.