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.