PowerCenter - Installation and Configuration (8.1.1 for Windows 32Bit)

About

This article talk about the installation of the data integration tool PowerCenter from Informatica.

Articles Related

Prerequisites

Download the files

• The files for the software Informatica PowerCenter and PowerConnect Adapters 8.1.1 SP5 are available on Edelivery.com

Choose Oracle Business Intelligence / Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit) :

Then this two files :

• File1 contain the initial software (server and client)
• File2 contain the documentation and the patch / hot fix

Repository Account

At least two database user accounts are required to host this repository :

• POW_REP for PowerCenter - Repository Database
• POW_DOM fro the Informatica - Domain Configuration Database

For Oracle, you must perform the following instruction :

CREATE user POW_REP IDENTIFIED BY POW_REP 
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT connect, resource, create view TO POW_REP;

CREATE user POW_DOM IDENTIFIED BY POW_DOM 
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT connect, resource, create view TO POW_DOM;

Services / Server

This sequence of installation don't say that you have to hit the next button and does not take care of review and informative windows.

• Frist, run File1\pc811_windows32\install.exe
• Select an option to install : Server. Install Anywhere launch.
• License key : select the license key text file in File2>Oracle_All_OS_Prod.key
• Option Install for the first time
• I leave the default directory C:\Informatica\PowerCenter8.1.1 (no space)
• Review and install
• As it's the first time, I choose “Create a new domain” option
• PowerCenter Domain Configuration Metadata :

For Oracle : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)

• Unblock java
• Powercenter service configuration : set the password (admin for instance)

Then it create domain and node, analyze the system

• Next screen, I uncheck “Install Informatica Services with a different account user” because I will use it only on my laptop.

• Repository Configuration

• Create integration service

• Then you must get this message :

Installation Status : SUCCESS 
The PowerCenter 8.1.1 installation completed successfully. The information below summarizes the location and 
configuration of the installed products and components and status of the services. 
Use the debug log file C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.log for more information.

Installation Date :  Fri Aug 07 12:42:44 CEST 2009  
Product Name :       PowerCenter 8.1.1  
Chosen Install Set : Complete  
Chosen Components :  PowerCenter Services  
Installation Directory :  C:/Informatica/PowerCenter8.1.1  
Shortcut Folder :    Start > Programs > Informatica PowerCenter 8.1.1> Services  

Configuration Properties  
----------------------------  

PowerCenter Services 
-------------------------------- 
Administration Console URL: http://NGERARD:6001/adminconsole 
Domain Name : Domain_NGERARD 
Gateway Host Name : NGERARD 
Administrator User Name : admin 
Node Name : node01_NGERARD 
Node Port Number : 6001 Repository 
Name : PowerCenter 
Repository Type : Oracle 
Connection String : orcl 
DB Username : POW_REP   

Configuration Status  
---------------------------- 
PowerCenter Domain Creation : Success 
PowerCenter Ping Domain : Success 
Repository Service Creation : Success 
Repository Service Startup : Success 
PowerCenter Repository Creation : Success 
DI Service Creation : Success 
DI Service Startup : Success

The installation debug log file can be found at : C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.log  

Client

Double click on the file install.bat located in this directory : File1\pc811_windows32\Client\Disk1

It will install :

• PowerCenter - Client
  • PowerCenter - Designer
  • PowerCenter - Repository Manager
  • PowerCenter - Workflow Manager
  • PowerCenter - Workflow Monitor
  • PowerCenter - Data Stencil
• PowerCenter - Metadata Manager console
• Custom Metadata Configurator

During the installation, you can see that it install a JRE.

When the installation has succeed, you will be able to read this message :

Installation Status : SUCCESS The PowerCenter Client 8.1.1 installation completed successfully. 
The information below summarizes the location and configuration of the installed products and components 
and status of the services. 
Use the debug log file C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Client_Debug.log for more information.
..............

Patch

Service Pack 15

• Stop all informatica service
• launch file2>pc811sp5_win32_x86>install.exe
• rename the licence key Oracle_All_OS_Prod.key as ias_license.xml and choose it
• select server option
• custom installation > uncheck PowerCenter - Data Analyzer and PowerCenter - Metadata Manager

• next and when finish, you must have this message :

Installation Status : SUCCESS  
The PowerCenter 8.1.1 SP5 installation completed successfully. 
The information below summarizes the location of the installed products .  
For more information, see the debug log file at 
C:\Informatica\PowerCenter8.1.1/Informatica_Installation_Server_SP5_Debug.log  

Installed Components: 
-------------------------- 
PowerCenter Services 8.1.1 SP5  
You must restart Informatica Services to complete the installation.  

Backed up server directory :  
------------------------ 
C:\Informatica\PowerCenter8.1.1\server_Bak_from_SP5

EBF - Fixe

The file2 contain two fix : EBF189068 and EBF189069.

• unzip them
• and copy the files :
  • in the PowerCenter_Home directory for the server file (EBF189068.Win32)
  • in the PowerCenter_Home\client\bin for the client file (EBF189068.Win32_Client)

Reference

• Installing Informatica PowerCenter Services Software from BI Apps
• You can find valuable information in the installation and configuration guide (PC_811_InstallationGuide.pdf) delivered with the file2.