This article talk about the installation of PowerCenter from Informatica on:
I have made it in the context of an Oracle Business Intelligence Application version 7.9.6.1 installation then it's why the computer name is OBIA7961.
The oracle database must be already installed: Oracle Database - Installation
The files for the software Informatica PowerCenter and PowerConnect Adapters 8.6.1 are available on Edelivery.com
Choose:
Then this two files :
The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of :
At least two database user accounts are required to host this repository :
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;
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.
For Oracle : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)
This information allow you to connect in the administration console (http://HostPowerCenter:6001/adminconsole)
A global administrator (for the domain and the repository) is automatically created with the credentials Administrator/Administrator. You may change the password for security purpose
Then it create domainand node, analyze the system
Informatica Services is the Windows service that runs PowerCenter Services on a node in a PowerCenter domain. Configure the user account if PowerCenter Services needs to access a network location not available to the current Windows user account.
The repository configuration is no more a step of the installer as in the installation of powercenter version 8.1.1. A new repository and integration service are now created with the help if the administration console. See section below.
A global administrator (for the domain and the repository) is automatically created during the installation with the credentials Administrator/Administrator. You may change the password for security purpose
Installation Steps:
Hot Fix 10 installation:
It will install :
The metadata manager console is not installed as in the installation of the version 8.1.1.
The creation of the repository can take maximum 2 minutes.
If you don't see the creation of tables in the POW_REP schema:
If it doesn't work