# How to give a password's value to variable

**URL:** <https://matillioncommunity.discourse.group/t/how-to-give-a-passwords-value-to-variable/1571>\
**Category:** Matillion ETL\
**Created:** [November 24, 2021, 8:17am UTC](https://matillioncommunity.discourse.group/t/how-to-give-a-passwords-value-to-variable/1571 "2021-11-24T08:17:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DK852652](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@DK852652](https://matillioncommunity.discourse.group/u/DK852652)\
**Post date:** [November 24, 2021, 8:17am UTC](https://matillioncommunity.discourse.group/t/how-to-give-a-passwords-value-to-variable/1571/1 "2021-11-24T08:17:30Z")

</div>

Hi.

​

I'm trying to create new shared job which can do table sharding from RDS to BQ.

Like the image below, I defined password as a job variables and set ${password} to password's property on JDBC Table Metadata To Grid component and Database Query component.

&nbsp;

 ![0694G00000HcNrgQAF_0D54G000083e3KLSAY](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/29cc8ba2a3d3ebf53c800fe178cd2902eaba9806.png)

​

Then, I generated this job as a shared jobs and when I use it on some orchestration job, I set password to password’s property like below.

&nbsp;

 ![0694G00000HcNvkQAF_0D54G000083e3KLSAY](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/c7f175b1cd3de161e10698a1452912327619c271.png)

​

After that I run this component and it shows error message like

“Parameter Validation Failure: Password - Unrecognised password name [password0000].”

Even though the username was success(I gave value as a variable to username but it doesn’t matter), somewhat password shows error.

​

I guess that password should secure safely, so I need to use password manager, but there is a choice that I can check “□use variable”, so I am confused.

&nbsp;

As a side note, password is absolutely correct.

Hope there is any solution about this problem.

&nbsp;

Thanks

---

<div class="post-metadata">

**Author:** ![DK852652](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@DK852652](https://matillioncommunity.discourse.group/u/DK852652)\
**Post date:** [November 24, 2021, 9:08am UTC](https://matillioncommunity.discourse.group/t/how-to-give-a-passwords-value-to-variable/1571/2 "2021-11-24T09:08:56Z")

</div>

※Additional comment

​

​The reason why I defined password is that I would like to connect more than two databases.

I understand that if I connect only one database, I should set the password which is stored in Password Manager.

But in this case, if I set a password which is stored in Password Manager, I need to create one more shared jobs for another database.

In other words, I would like to create only one shared job and can connect more than two databases.(not at the same time)

---

<div class="post-metadata">

**Author:** ![DK852652](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@DK852652](https://matillioncommunity.discourse.group/u/DK852652)\
**Post date:** [November 30, 2021, 10:57am UTC](https://matillioncommunity.discourse.group/t/how-to-give-a-passwords-value-to-variable/1571/3 "2021-11-30T10:57:37Z")

</div>

Hi all.

​

I could solve this problem and this is absolutely my fault because of ​my ignorerance.

&nbsp;

AS I posted image, I gave ${password} to the password property and then, when I use it as a shared jobs, I should give value which is stored in Password Manager to the password property. (Collector-STG has a password for connecting to database)

&nbsp;

 ![0694G00000HczCGQAZ_0D74G000007kCKhSAM](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/1cfbef04d031a776f654e46aed79bebd2bf55596.png)

&nbsp;

Thank you.