In one of our "JDBC Query" nodes, we have a need to modify our "DbUrl" connection property based on what environment the workflow is in. I can connect an input into the "JDBC Query" node that has a single one-row column (ie. a single data point) that can calculate the appropriate DbUrl. based on the environment, but I can't figure out a way to pass the value onto the "JDBC Query" node.
Similarly, I need to pass on a "SqlQuery" value because some of the table names are different across the different environments. What's the best way to accomplish both these things?
I've attached a simple example of what I'm currently trying. (For simplicity I subbed out my actual logic with a Create Data node just to see if I could get a simpler example to work since the concept of passing the value is my main concern).
Please sign in to leave a comment.