Skip to main content
Solved

Parameterize a JDBC connection in a JDBC consumer and producer


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

View original
Did this topic help you find an answer to your question?

2 replies

saleempothiwala
Headliner
Forum|alt.badge.img

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
saleempothiwala wrote:

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!


Reply