How to give a password's value to variable

[DK852652]

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.

 

​

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.

 

​

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.

 

As a side note, password is absolutely correct.

Hope there is any solution about this problem.

 

Thanks

[DK852652]

※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)

[DK852652]

Hi all.

​

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

 

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)

 

 

Thank you.