Skip to main content
Solved

Parameterize a JDBC connection in a JDBC consumer and producer

  • August 22, 2022
  • 2 replies
  • 83 views

Hi, is there a way to define a connection (created in Control Hub => Set Up => Connections) by parameter in the JDBC consumer and producer stages? It seems the select box does not allow a text field entry where could reference a connection via a parameter? I am aware that I could use the alternative way of defining the connection via connection URL parameters etc but then I have to also expose user name and password etc so it would be much nicer if the connection would take a parameter.

Thank you!

 

Best answer by saleempothiwala

hi @pedromanuel 

the best way to define a connection is to use runtime value for connect string and credential store for username and password. Depending upon where you run your pipeline, relevant values will be used.

 

more about it: Runtime values and Credential Stores

2 replies

saleempothiwala
Headliner
Forum|alt.badge.img
  • Headliner
  • 258 replies
  • Answer
  • August 22, 2022

hi @pedromanuel 

the best way to define a connection is to use runtime value for connect string and credential store for username and password. Depending upon where you run your pipeline, relevant values will be used.

 

more about it: Runtime values and Credential Stores


  • Author
  • Opening Band
  • 12 replies
  • August 22, 2022

hi @pedromanuel 

the best way to define a connection is to use runtime value for connect string and credential store for username and password. Depending upon where you run your pipeline, relevant values will be used.

 

more about it: Runtime values and Credential Stores

 

Hi @saleempothiwala , thank you for your answer. Yes, I thought its best to not use pre-configured configurations in our case, instead use runtime values. Thank you!