zed.yap
Posts: 1
Joined: Thu Oct 22, 2015 6:36 am

Dynamic value for DBInputTable component configuration

Postby zed.yap » Thu Oct 22, 2015 11:53 am

Hi,

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?

Regards

cholastal
Posts: 103
Joined: Tue Sep 01, 2015 1:22 pm

Re: Dynamic value for DBInputTable component configuration

Postby cholastal » Mon Nov 02, 2015 3:36 pm

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.
Attachments
dbinput_w_param.grf
(1.94 KiB) Downloaded 43 times
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support