How can i change this username and password dynamic?

image
How can i split the strings like this properly ? username - Config(“username”).tostring password = config("password).tostring

Note: this is a SQL database connection activity

Hi @Salman_Faries_V_S

store the user name and password as the credential asset in the orchestrator and pass that variable into studio through config (Setting Sheet)and pass the config variable into Get Credentials activity.
From that activity you will get the Username and Password variables. Simply pass those username and password variables into that SQL connection.

image
image

Regards


I have done same but error occuring. Please help

Hi @Salman_Faries_V_S

By using below syntax please change the securestring variable to a string variable.

DBPassword(String DataType) = New System.Net.NetworkCredential("", DBSecurePassword).Password

Here DBSecrePassword is a securestring variable

Regards

Will you please send your workflow for my reference

Sure bro @Salman_Faries_V_S

Hi @Salman_Faries_V_S

Please create an credentials asset in the orchestrator and then pass the variable created in the orchestrator into the settings sheet and then pass the config variable into the studio.

Please refer the below attached zip file for better understanding.



BlankProcess1.zip (648.8 KB)

Regards

1 Like

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