Showing posts with label PATH. Show all posts
Showing posts with label PATH. Show all posts

Thursday, 2 August 2018

What are the checks to be performed before using pmrep deployment group?

The following are the commands to be run:

1. Login to Host1 and run the following:

cd $INFA_HOME/server/bin
./pmrep connect -r <rep_name> -d <domain_name> -n <username> -x <password> -sdn <Native/LDAP domain>

2. Login to Host2 and run  the following:

cd $INFA_HOME/server/bin
./pmrep connect -r <rep_name> -d <domain_name> -n <username> -x <password> -sdn <Native/LDAP domain> 

If the $INFA_HOME/server/bin is in PATH environment variables then you can the pmrep command from anywhere.

3. Check if the below objects are created if you are using dynamic deployment groups in source repository. 
  • Label
  • Query

4. Check if you are able to connect source repository from target host where you run the deployment or vice versa.

The username (and password) is the one that you use to connect to the repository through the power center clients (such as repository manager).
The sdn is the security domain which is either Native or the LDAP domain. (enter the same details as the one on the PowerCenter client).


The Connect command uses the following syntax:

pmrep help connect
-r <repository_name> {-d <domain_name> |
{-h <portal_host_name>
-o <portal_port_number>}}
[{ <user_name>
[-s <user_security_domain>] [-x <password> |
-X <password_environment_variable>]} |
-u <connect_without_user_in_kerberos_mode>] [-t <client_resilience>]

To use -X option configure INFA_DEFAULT_DOMAIN_PASSWORD on UNIX:
1. At the command line, type:
pmpasswd <password>
pmpasswd returns the encrypted password.
2. In a UNIX C shell environment, type:
setenv INFA_DEFAULT_DOMAIN_PASSWORD <encrypted password>
    In a UNIX Bourne shell environment, type:
export INFA_DEFAULT_DOMAIN_PASSWORD=<encrypted password> 

Wednesday, 25 January 2017

Configure DataDirect ODBC on UNIX with PowerCenter


Do the following to install DataDirect ODBC drivers on UNIX:
  1. Install the Informatica Services which include the DataDirect ODBC drivers for UNIX.
  2. Set the ODBCHOME environment variable 
    > ODBCHOME=/opt/Informatica/9.6.1/ODBC7.1; export ODBCHOME
  3. Add the $ODBCHOME/bin directory to the PATH environment variable:
    Using a Bourne shell:
    $ PATH=${PATH}:$ODBCHOME/bin; export PATH
    Using a C shell:
    $ setenv PATH ${PATH}:$ODBCHOME/bin 
  4. Add the $ODBCHOME/lib to the library path variable.


  5. (OPTIONAL) Copy the odbc.ini file to the location where you would like this file to be used.
    Typically the Informatica home directory is used.
    cp $ODBCHOME/odbc.ini $HOME/.odbc.ini
  6. Set the ODBCINI environment variable to the location of the .odbc.ini (or odbc.ini) file: 
    $ ODBCINI=$HOME/.odbc.ini; export ODBCINI
    OR
    $ ODBCINI=$ODBCHOME/odbc.ini; export ODBCINI
  7. Edit the odbc.ini file (specified by the $ODBCINI environment variable) as follows:
    1. Set the InstallDir to the ODBC installation directory ($ODBCHOME).
  8. Re-Start the Informatica Node services.