4.0 SQL Server Connector add JDBC Params via flow variable

Is there a way in the new SQL Server driver to use the URL to connect as before and if not, is there a way to dynamically add params to the JDBC Parameters section. I have a case where sometimes I need to connect using a domain account and sometimes not. It’s configurable from outside the scope of the Connection node.

in the new DB connector nodes you can use flow variables in the JDBC Parameter tab by changing the Type column to “Flow variable”. I just tried to pass in null as value for the domainName and the connector worked without problem. So it seems that setting the variable value to the domain name if required or setting it to missing (null the default value according to the documentation) if not require could work.



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.