Informatica PowerCenter Command Line Tool Installation

For Linux implementations, there are official instructions on how to install and configure the PowerCenter Command Line Utilities package. See Installing the Command Line Utilities for more details. Note that Informatica client tools require the installation of the libnsl and libidn Linux libraries. (https://knowledge.informatica.com/s/article/Domain-creation-failed-by-libpmjrepn-so-libidn-so-11-cannot-open-shared-object-file-No-such-file-or-directory?language=en_US)

Follow these steps to speed up the installation and configuration of the utilities. They are based on the directory structure for version 10.5.3. For other versions, minor adjustments may be required.

Install the libnsl and libdn system libraries.
Run the following as root.
```
#!/bin/bash
yum install libnsl
yum install libidn
```

Install the IFPC command line tools.
Run the following under root or under Manta user if Manta user has all the required privileges (update lines 5–17 per your environment).

#!/bin/bash
########################################################################
# configuration
# target directory where you want to deploy Informatica PowerCenter command line tools
IFPC_DIR=/opt/informatica_1053

# name of the Inforamtica PowerCenter command line tools installation file/archive
IFPC_INSTALL_FILE=informatica_1053_cmd_utilities_linux-x64.zip

# location where you have the Informatica PowerCenter command line tools installation file/archive
IFPC_INSTALL_LOCATION=/tmp

# Linux user under which MANTA runs
MANTA_SYSTEM_USER=manta

# Linux usergroup under which MANTA runs
MANTA_SYSTEM_GROUP=manta

########################################################################
# actual setup steps
IFPC_BIN_DIR=$IFPC_DIR/PowerCenter/server/bin
mkdir $IFPC_DIR
cp $IFPC_INSTALL_LOCATION/$IFPC_INSTALL_FILE $IFPC_DIR
cd $IFPC_DIR
unzip $IFPC_INSTALL_FILE
chown -R $MANTA_SYSTEM_USER:$MANTA_SYSTEM_USER $IFPC_DIR
chmod u+x $IFPC_BIN_DIR/pmrep
chmod u+x $IFPC_BIN_DIR/infacmd.sh
chmod u+x $IFPC_DIR/PowerCenter/isp/bin/infacmd.sh
chmod u+x $IFPC_DIR/PowerCenter/java/bin/java

#########################################################################
# Print Configuration for MANTA
echo "Put the following configuration to your Informatica PowerCenter connection in MANTA Admin UI:"
echo "pmrep application path: $IFPC_BIN_DIR/pmrep"
echo "infacmd application path: $IFPC_BIN_DIR/infacmd.sh"
echo "domains.infa path: $IFPC_BIN_DIR/domains.infa"
echo "LD library path: $IFPC_BIN_DIR"
echo "Client home directory path: $IFPC_DIR/PowerCenter"

The script prints the paths that you can put into the Informatica PowerCenter connection in Manta Admin UI.

Run the following under Manta user. To set up domains.infa, there are two options.
1. Copy it from another location; for example, one provided by your Informatica team.
```
cp /<currentlocation>/domains.infa $IFPC_BIN_DIR/
```
2. Generate it using infacmd.sh.
```
infacmd.sh updateGatewayInfo -dn <infa_domain> -dg <hostname>:<port_number>
```

To verify the connection independently of IBM Automatic Data Lineage:

Configure the OS environment variables.

INFA_HOME=$IFPC_DIR/PowerCenter/
PATH=.:$IFPC_BIN_DIR:$PATH
LD_LIBRARY_PATH=.:$IFPC_BIN_DIR:$LD_LIBRARY_PATH

Verify that the pmrep utility is running.

cd $IFPC_BIN_DIR
pmrep

The output should look similar to that below.

Informatica(r) PMREP, version [10.5.3], build [900.1009], Windows 64-bit
(c) Copyright Informatica LLC 1993,2022.
This software and documentation are provided only under a separate license agreement containing restrictions on use and disclosure.
This software is protected by patents as detailed at https://www.informatica.com/legal/patents.html
A current list of Informatica trademarks is available on the web at https://www.informatica.com/trademarks.html
See the Informatica privacy policy at https://www.informatica.com/privacy-policy.html
Invoked at Tue May 02 11:14:24 2023

You can also verify the actual connectivity.

cd $IFPC_BIN_DIR
pmrep connect -r <repository_name> -h <portal_host_name> -o <portal_port_number> -n <user_name> -x <password> -s <security domain>

The output should appear as follows.

Connected to repository <repository_name> in MantaDomain as user Administrator
connect completed successfully.

Verify that the infacmd.sh utility is running.

cd $IFPC_BIN_DIR
infacmd.sh

The output should look similar to that below.

(c) Copyright Informatica LLC 1993, 2022.
This software and documentation are provided only under a separate license agreement containing restrictions on use and disclosure.
This software is protected by patents as detailed at https://www.informatica.com/legal/patents.html
A current list of Informatica trademarks is available on the web at https://www.informatica.com/trademarks.html
See the Informatica privacy policy at https://www.informatica.com/privacy-policy.html

Usage: infacmd [ISP] <command> <arguments>
[ISP] commands ...
Folder Commands
  createFolder: Creates a folder in the domain.
  ...
Command ran successfully.

Verify the infacmd.sh connectivity.
```
cd $IFPC_BIN_DIR
infacmd.sh isp ListServices -dn <Domain Name> -un <User Name> -pd <Password> -st IS  -sdn <Security Domain>
```
The output should look similar to that below. (However, there may be more lines indicating the number of integration services you have and their names.)
```
INFA_SERVICE
Command ran successfully.
```