How can i change this username and password dynamic?

[Salman_Faries_V_S]

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

[vrdabberu (Varunraj Dabberu)]

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.

Regards

[Salman_Faries_V_S]

I have done same but error occuring. Please help

[vrdabberu (Varunraj Dabberu)]

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

[Salman_Faries_V_S]

Will you please send your workflow for my reference

[vrdabberu (Varunraj Dabberu)]

Sure bro @Salman_Faries_V_S

[vrdabberu (Varunraj Dabberu)]

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