I need to pass variables for user name and password in Configure Connection

Help Studio
, ,
1

Hello Team,

Good Day.

I was successful able in connecting to the database, however I don’t want the developers to know the user and password of the database.

“SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= HOSTNAME) (PORT=1521))(CONNECT_DATA=(SERVICE_NAME= SERVICE NAME )));uid= username ;pwd= password ;”

I need to pass variables for user name and password in Configure Connection of the Connect activity. I tried it and got an error
image

image
image985×295 19.8 KB

Regards,
Manjesh

2

I do not fully get what you are doing to be honest but I would assume it is because the connection string can not include the password variable of type SecureString?
In this case secure string would have to be decrypted first or int he ConnectionString itself.

(new System.Net.NetworkCredential(string.Empty, password).Password) will make it a normal string.

3

Hello @nicortak ,

Hi . you are right I wanted to pass the secure string into my connection. I tried the method you had sent but it is still the same error. Can you send me a sample workflow to see where am I going wrong.

Regards,
Manjesh