Above Screenshot, Microsoft SQL Node. in Test_credential SQL Connection, i configured the SQL Credential details. but I have multiple different SQL Credential, Is it possible to pass the values in credential field by using variable in Test_Crendential SQL Connection? Condition is pass the values in credential field by using same SQL Connection(Test_Credential). To Avoid the Create the multiple SQL Connection Name, we need to achieve this. please anyone help me on this
Hi @Kaviya_V
What I think the best thing you can do is this:
i can pass the value of SQL details in value field dynamically under same credential Name. i can use same technique in another workflow but my quesition if both workflow run same time, is it will override? if not i can use same technique by using single credentialname instead of creating multiple credential name
@Kaviya_V I do not think so, they would override each other, as expressions in the credentials field are evaluated only once per executions, so you can just go on and use that single credential name.
So Are you saying, i achieved multiple credential in single credntial Name, is it right? Could you please confirm it with higher professional? because if we achived this, it will really helpful to us and don’t need to Create multiple credential Name.
@Kaviya_V i think it is officially stated:
i think so, i will not override and in n8n execution handled in queue based. if i schedule two workflow at same time, it will execute one by one so it will not override if there anything possible. Am i right?
@Kaviya_V let me clearly state it.
Yes, a single credential name with dynamic expression is safe to use even across concurrent flows, and that is safe because each execution of a flow has its own separate context or isolation, I would say.