Using Password Encryption

Oracle Hyperion Financial Data Quality Management, Enterprise Edition provides a Win/UNIX script to encrypt a password and store in a file. Script encryptpassword.bat/sh is located in EPM ORACLE INSTANCE/FinancialDataQuality directory.

To encrypt a password:

1. Navigate to the directory that has the batch files.

   Typically, the batch file directory is EPM ORACLE INSTANCE/FinancialDataQuality directory

2. From the EPM ORACLE INSTANCE/FinancialDataQuality directory, at a command prompt, run the script encryptpassword.bat <passwordfile>.
3. When prompted, enter the password, and then click Enter.

   Note the following:

   • The password is masked when you type it.

   • When running the batch script, you can provide the password by file name as a parameter in the following format: –f:passwordfile. The file name used as a parameter is placed in the location defined in “Encrypted Password Folder” option of System Settings.

   • Do not include a disk or directory specification as part of the file name, just enter a file name with or without an extension.

   • Replace the [file] with the actual file name, and do not include the brackets.

   • The script encrypts the password and writes it to the file provided as a parameter.

   • For information on running a data load rule batch script with a password from a file, see Executing the Batch Script for Data Load Rules.

   • For information on running a metadata load rule batch script with a password from a file, see Executing the Batch Script for Metadata Rules.