Enabling DAC Client Communication with Informatica PowerCenter
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Section A.5.2, "How to Verify the DAC Client Is Able to Use pmrep and pmcmd"
A.5.1 How to Define the Informatica Domains File Path in the DAC Client Environment
In order for the DAC Client to be able to use the pmrep and pmcmd programs, the
path of the Informatica Domain file 'domains.infa' must be defined in the environment
variables on the DAC Client machine.
When you use the DAC installer to install the DAC Client, this configuration is
To define the Informatica Domains File path in the DAC Client environment
Locate the file domains.infa in the root Informatica PowerCenter installation
directory and note down the directory path of this file.
For example, <drive>:\Informatica\PowerCenter8.6.1.
Create an environment variable called INFA_DOMAINS_FILE with the value set
to the directory path to the domans.infa file, as follows:
On Windows, display the Windows Environment Variables dialog box (that is,
from the Windows Control Panel, select System, then Advanced, then
Environment Variables), and create a System variable with the following
Variable name: INFA_DOMAINS_FILE
Variable value: <directory path of domains file>\domains.infa
The path should include the name of the file. For example,
Add the directory path to Informatica PowerCenter binaries to the PATH
environment variable as follows:
In the Windows System Properties > Environment Variables dialog box, add the
path of the Informatica \Client\bin directory to the PATH environment variable.
For example: <drive>:\Informatica\PowerCenter8.6.1\client\bin.
A.5.2 How to Verify the DAC Client Is Able to Use pmrep and pmcmd
From a Windows command prompt, execute pmrep and then pmcmd. The test is
successful if you see the programs are invoked and the pmrep and pmcmd prompts
If pmrep and pmcmd are not recognized, then:
Ensure Hotfix 6 has been applied to Informatica PowerCenter 8.6.1.
Verify that the INFA_DOMAINS_FILE variable points to the domains.infa file
located in the Informatica directory.
Verify that the PATH variable includes the path to the Informatica binaries
(\Informatica\PowerCenter\client\bin), and that pmrep.exe and pmcmd.exe exist
in the \bin directory.