Hi Guys,
Today we will see how to install and configure Informatica 9.5.1 Powercenter in Windows Server 2008 R2 environment.This consists of a step by step process of the installation of Informatica including creation of Domain metadata, logging into admin console and configuring Repository metadata and Integration service. Few lessons learnt by me during this installation was : ALWAYS BE CAREFUL WHILE NAMING YOUR DOMAIN. This is because I named the domain a little bit differently than the client wanted and had to uninstall and re-install Infa again (might have had some workaround, but nevertheless would never had been easy).
PreRequisites:
Installation of Informatica also calls for a set of prerequisites. If we are interested in installing only the Powercenter and not the other components such as IDQ or MDM then it calls for the below minimum system requirements:
Today we will see how to install and configure Informatica 9.5.1 Powercenter in Windows Server 2008 R2 environment.This consists of a step by step process of the installation of Informatica including creation of Domain metadata, logging into admin console and configuring Repository metadata and Integration service. Few lessons learnt by me during this installation was : ALWAYS BE CAREFUL WHILE NAMING YOUR DOMAIN. This is because I named the domain a little bit differently than the client wanted and had to uninstall and re-install Infa again (might have had some workaround, but nevertheless would never had been easy).
PreRequisites:
Installation of Informatica also calls for a set of prerequisites. If we are interested in installing only the Powercenter and not the other components such as IDQ or MDM then it calls for the below minimum system requirements:
Informatica
follows a distributed system architecture. Hence it would be preferable to install
server and client components seperately in different nodes.This would
ensure harnessing Informatica’s full potential
towards Data Integration solutions.
But before that we
must have a database installed to store Domain Metadata as well as Repository
contents (in our case Oracle). The repository is nothing but a metadata storage
area where all the related information about mappings, sessions, exclusively
defined parameters, user roles and privileges etc are stored for integration
service to read.
After creating a database,
we must also create a user having full privileges on the database which is
mandatory for Informatica Installation. The required privileges are given
below:
CREATE and DROP tables,
indexes, and views.
SELECT, INSERT, UPDATE and DELETE data from
all the tables.
CONNECT, RESOURCE and CREATE VIEW privileges.
Informatica would
use the ports 6005 to 6009 for connecting to client and hence such ports must
not be used by any other processes or blocked by firewalls. Also the appropriate version must be
installed on the supporting OS with enough CPU’s, disk space and temporary disk
space.
Informatica actually has a prerequisite tool present that helps you check whether your system has the necessary configuration to install the corresponding Informatica version. It mostly resides in Informatica server installation folder under the name I9PI.exe
The document having the step by step screenshots of the installation process can be found here.
Informatica actually has a prerequisite tool present that helps you check whether your system has the necessary configuration to install the corresponding Informatica version. It mostly resides in Informatica server installation folder under the name I9PI.exe
The document having the step by step screenshots of the installation process can be found here.
