Skip to main content

Encrypting the Password


The pmpasswd command can be used to encrypt the password
The pmpasswd command is located in the <INFA_HOME>/server/bin directory in the Informatica Services installation and the <INFA_HOME>\CMD_Utilities\PC\server\bin directory in the 8.x client installation and  <INFA_HOME>\clients\PowerCenterClient\CommandLineUtilities\PC\server\bin in the 9.x client installation.

Windows

To encrypt the PowerCenter repository user password on Windows do the following:
  1. Create an environment variable for the PowerCenter Repository user (in this example "PMUSER"):
    1. Go to Start > Settings > Control Panel > System.
    2. Click the Advanced tab.
    3. Click Environment Variables .
    4. Under System Variables click New .
    5. Enter PMUSER for the Variable Name.
    6. Enter Administrator for the Variable Value .
    7. Click OK on each screen to exit.
  2. Create the encrypted password for the user:
    pmpasswd Administrator
    This command will convert the string 'Administrator' to an encrypted value (example: ae456=GHY&|3f7 ).
  3. Create an environment variable for the PowerCenter Repository user password:
    1. Go to Start > Settings > Control Panel > System.
    2. Click the Advanced tab.
    3. Click Environment Variables .
    4. Under System Variables click New .
    5. Enter PMPASS for the Variable Name.
    6. Enter the value of the encrypted password created in step 2. for the Variable Value.
    7. Click OK on each screen to exit.

UNIX

To encrypt the PowerCenter repository user password on a UNIX machine do the following:
  1. Create an environment variable for the PowerCenter Repository user:
    setenv PMUSER Administrator
  2. Create the encrypted password for the PowerCenter Repository user:
    pmpasswd Administrator
  3. Create an environment variable for the PowerCenter Repository user password.
    In a UNIX C shell environment, type:
    setenv PMPASS <encrypted password>
    In a UNIX Bourne shell environment, type:
    PMPASS = encrypted password export PMPASS
  4. Confirm the variable settings by typing the following:
    env
    The environment setting should have the following variables set:
    PMUSER=Administrator 
    PMPASS= encrypted_password

Using the Encrypted Password

The following are examples of using the encrypted repository user password in a command line tool.

PMCMD

To start a workflow using pmcmd with these environment variables type the following:
pmcmd startworkflow -sv service -uv PMUSER -pv PMPASS workflow

PMREP

To connect to a repository using pmrep with these environment variables type the following:
pmrep connect -r repository_name -d domain_name -n Administrator -X PMPASS

NOTE:

Do NOT use a dollar sign ('$'; "-uv $PMUSER") or percent sign ('%'; "-X %PMPASS") or any other symbol to denote the environment variables in the comman

Related Documents

Comments

Post a Comment

Popular posts from this blog

INFA _DOMAIN_CONFIGURATION I refere to 9.0.1 PowerCenter Installation and Configuration Guide and I found below statement. INFA_DOMAINS_FILE The installer creates a domains.infa file in the Informatica installation directory. The domains.infa file contains the connectivity information for the gateway nodes in a domain, including the domain names, domain host names, and domain host port numbers. 40 Chapter 5: After You Install Set the value of the INFA_DOMAINS_FILE variable to the path and file name of the domains.infa file. If you configure the INFA_DOMAINS_FILE variable, you can run infacmd and pmcmd from a directory other than /server/bin. Configure the INFA_DOMAINS_FILE variable on the machine where you install the Informatica services. On Windows, configure INFA_DOMAINS_FILE as a system variable. I have set the environment variable accordingly as INFA_DOMAINS_FILE=/informatica/node1/PC951/domains.infa but I am not able to run the pmcmd ...
Post a Comment
Read more
How to run Informatica Workflow using Unix command To run the workflow first need to got the command line  and go to the folder where the executable is installed. Mostly you can find the pmcmd command in  \server\bin\directory . Syntax: pmcmd  startworkflow -sv < Integration Service Name > -d < Domain Name > -u < Integration Service Username > -p < Password > -f < Folder Name>  < Workflow > pmcmd  startworkflow -sv  qpd_Service  -d qpd_Domain  -u  Administrator  -p  admin  -f  Alex wf_sales_tax Before that we need to configure the environment variables and make the necessary changes Go to control panel->systems->advanced ->environment variable->system variable and add a new system variable and in the variable value set the path of your server machine where informatica is installed (where pmcmd.exe file is present) After that Go to control panel->s...
Post a Comment
Read more