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
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.