Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

EncryptPassword

EncryptPassword

Generates and displays an encrypted form of a password. If you configure Data Validation Option to use Informatica authentication, use the
EncryptPassword
command to encrypt the password for an Informatica user or administrator. Set an environment variable to the encrypted password. Use the environment variable in DVOCmd commands, such as the
CopyFolder
,
RefreshRepository
, or
RunTests
commands.
Use a name of your choice for the variable. In the DVOCmd command, use the
ePassword
option instead of the
password
option and specify the environment variable. For example, set an environment variable named INFAPWD to the encrypted password. Use INFAPWD as the value of the
ePassword
option in DVOCmd commands that require the password. The DVOCmd commands replace the environment variable with the encrypted password, and then decrypt the password.
If you set the
ePassword
option, then do not set the
password
option. If the command contains both the
password
and
ePassword
options, then the Data Validation Option uses the
ePassword
and ignores the
password.
The
EncryptPassword
command uses the following syntax:
DVOCmd EncryptPassword <password>
The following table describes
EncryptPassword
options and arguments:
Option
Argument
Description
-
password
Password of the Informatica user.
Along with the encrypted password, the command displays the string that results when DVOCmd commands decrypt the password. The decrypted and unencrypted forms of the password must match.
You can also use the command line program pmpasswd to encrypt passwords. The pmpasswd utility installs in one of the following directories:
  • <InformaticaInstallationDir>/server/bin
  • <InformaticaClientInstallationDir>/PowerCenterClient/client/bin
The pmpasswd utility uses the following syntax:
pmpasswd <password> [-e CRYPT_SYSTEM)]
The following table describes pmpasswd options and arguments:
Option
Argument
Description
-
password
Required. The password to encrypt.
-e
CRYPT_SYSTEM
Optional. The encryption type.
The value is CRYPT_SYSTEM.