Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: 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.

0 COMMENTS

We’d like to hear from you!