[INFORMATICA] - Steps to install Informatica Powercenter 9.5 in Windows 8 or windows 8.1

Here am going to give the step by step process to download and install Informatica Powercenter 9.5.x in Windows 8/8.1

Step 1 : Define Schema in Oracle DB for Domain repository:
********************************************************************************************************
Where teaneck_ts is your tablespace(you can choose your own tablespace name)
Where teaneckdb is your own username(you can choose your own tablespace name)
Skip step 1 if already the repository schema in place.
**********************************************************************
CREATE TABLESPACE TEANECK_TS DATAFILE 'C:\app\<your computer name>\oradata\orcl\teaneck_ts.dbf' SIZE 100M AUTOEXTEND ON MAXSIZE 500M;
CREATE USER teaneckdb
IDENTIFIED BY teaneckdb
DEFAULT TABLESPACE TEANECK_TS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
ALTER profile DEFAULT limit password_life_time UNLIMITED;
Create role SSE_ROLE;
Grant connect, resource to SSE_ROLE;
Grant select any table to SSE_ROLE;
Grant create session to SSE_ROLE;
Grant insert any table, delete any table, update any table to SSE_ROLE;
GRANT SSE_ROLE TO teaneckdb;
GRANT GLOBAL QUERY REWRITE TO teaneckdb;
GRANT CREATE MATERIALIZED VIEW TO teaneckdb;
GRANT CREATE TABLE TO teaneckdb;
GRANT CREATE ANY VIEW, DROP ANY VIEW TO teaneckdb;
GRANT CREATE ANY SEQUENCE, DROP ANY SEQUENCE TO teaneckdb;
GRANT CREATE ANY INDEX, DROP ANY INDEX TO teaneckdb;
GRANT UNLIMITED TABLESPACE TO teaneckdb WITH ADMIN OPTION;



Step 2 : Copy and paste the entire SOURCE folder to INFA HOME folder.
*********************************************************************************
1.Download Informatica 9.5.1 from Oracle

    -- Follow steps given in This_Link to download and extract setup files

2. Copy SOURCE folder from 951HF2_Server_Installer_winem-64t folder

3. Paste the SOURCE folder to C:\Informatica\9.5.1   (INFAHOME)

Step 3: GUI is not compatible for Windows 8.1. We have to choose the cmd line execution to create the domain.
*********************************************************************************
Go to INFAHOME(C:\Informatica\9.5.1\Source\isp\bin) in cmd prompt and execute the below command

infasetup.bat defineDomain -da localhost:1521 -dt Oracle -du teaneckdb -dp teaneckdb -ds ORCL -dn domain_localhost -ad administrator -pd <yourpassword> -ld C:\Informatica\log -nn nodelocalhost -na localhost:6000 -mi 6000 -ma 6005 -rf nodeoptions.xml

where du teaneckdb is your oracle repository and du teaneckdb is password.
<Yourpassword> Administrator password.

Step 4 : Start the domain.
*********************************************************************************

Go to C:\Informatica\9.5.1\Source\tomcat\bin in CMD prompt(in INFAHOME)

Run infaservice.bat startup

C:\Informatica\9.5.1\Source\tomcat\bin> infaservice.bat startup

The domain will be kicked off.

Step 5: In browser type the URL
********************************************************************************
http://localhost:6000

This will take you the informatica administrator console.

Step 6 : Install Informatica Client by making compatibility of Windows 7.
*********************************************************************************

Go to folder "951HF2_Client_Installer_win32-x86\Client"

Right click "install.exe" and choose properties

In the compatibility tab choose "Windows 7" and click apply

Now double click the exe file and install it.

********************************************************************************

Step 7: Configure Environment variables

Set varaible INFA_HOME to "C:\Informatica\9.5.1\Source"

Set variable LIBPATH to "C:/Informatica\9.5.1\Source\server\bin"

********************************************************************************

Step 8: Update versions of Plug-ins

when the plug-ins are not registered to the domain and the version of the plug-ins need to be updated so perform the following steps:

1. Shut down the domain.
2. From the $INFA_HOME/server/ directory, run the command: "infasetup.bat validateandregisterallfeatures".
3. Once the command executes successfully, restart the domain and Model Repository Services and connect from the Developer client.

********************************************************************************

You are ready to work in Windows 8.1.