Can i use variables for my SQL password?

Help StudioX
,
1

Hi guys,

Due to my company policies, our passwords are expired every month.
I do change my passwords every month for all my “execute query” activities.
If i use 20 activity, i should change my password 20 times.

as far as i guess, there should be a way (like using variables) and after my password expire, i should change only one time and it should affects it all.

can someone help about it?

thanks a lot.

2

Hi @Krmi

Create an asset in Orchestrator with the Credential Type and store all your credentials there. Use the Get Credentials activity in Studio to retrieve those credentials and apply them in the Execute Query activities.

When you change your system password, update it in the Orchestrator asset, and the new credentials will be used in all Execute Query activities during subsequent runs.

Hope it helps!!

3

can you explain it like you’re talking to 5 years old :smiley: i am very new at it. i even dont know what is orchestrator… :frowning:

4

@Krmi,

Assets is the best practice here and you don’t need any redeployment after every password change it will automatically fetch latest asset value you store on Orchestrator.

5

Not a problem… @Krmi

Check the below video to know about it,

Hope it helps!!

6

i dont have this one. i have only studiox.

7

solution has been found.

i save it existing connection.

8

Hie @Krmi instead of saving your password in variable you can save it to Orchestrator Under Asset so you do not to update it on your code everytime . just changed it to Asset and it will update in your process as well.

The interface displays the "Assets" tab in a workspace application with a highlighted "Add asset" button, and currently shows no data. (Captioned by AI)
The interface displays the "Assets" tab in a workspace application with a highlighted "Add asset" button, and currently shows no data. (Captioned by AI)1356×534 34.5 KB

create asset and the type is Credentials
The image shows a form from a software application where users can add a new asset with details such as asset name, type, username, and password, and has a button to create the asset. (Captioned by AI)
The image shows a form from a software application where users can add a new asset with details such as asset name, type, username, and password, and has a button to create the asset. (Captioned by AI)1359×606 42.9 KB

and in the studio use Get Credential activity and select your asset then pass the variable value to where you want it to use.

cheers

cheers

9

my companies it dep. told me that i can not use it with studiox i dont have studio… for simple tasks :):slight_smile: but i got the solution anyway, its good for me so far.

appreciated for your helps.

1 Like