Dynamic value for DBInputTable component configuration

zed.yap

• October 22, 2015 00:00

• Answered

Follow

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

• 

  Lukas Cholasta

  • November 02, 2015 14:36

  0

  Comment actions Permalink

  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.

  • dbinput_w_param.grf

Please sign in to leave a comment.