Data Integrator Password File

[Former Member]

Hi,

I have few DI batch jobs for countries which will invoke/execute other jobs of respective cities. This is done by running a batch file.

Recently we have upgraded our DI to 11.7.3. We are planning to use passord file feature available on this version. But i am not sure how to use this feature for above mentioned scenerio.

In existing bat file, we have encrypted the password like this,

-SBOTRNP -NOracle -Udiexec -P493D523D5336482F680D630A4F -L -G"99b2c58b_017f_4d04_af2b_9aad60e6b6a2" -r1000 -T14 -Ck -KspXX_MN_N_AHG -LocaleGV -CtBatch -Cmlseusas0054 -CaAdministrator -CjLSEUSAS0054 -Cp3201

Since the passwords will change periodically for additional security,

Can anybody help me how to make use of passwords from password file instead of this encrypted password?

Please help as soon as possible.

Regards,

Prasanth

[Former Member]

Hi Manoj,

Thanks for your quick reply.

I understood that we have to export the execution command once to the recent password along with new server information.

I did that and now its working fine.

Thanks again.

Prasanth

[Former Member]

the password file will store the complete repository connection information in encrypted form so from the job command following will be replaced by -R<password file name>

-SBOTRNP -NOracle -Udiexec -P493D523D5336482F680D630A4F

The Password file with connection information can be generated from the Management Console, from the page where you add/modify repository connection information, you will see a option Generate Password file

also from export execution command and schedule page, you will see a option to use password file, if you check that option the command will not have the connection info, instead will have -R option and will read the connection details from password file

if your repo password is changed, you need to change the password in the repo page and generate the password file again, no need to export the schedule or command again