Powered By Blogger

Wednesday, June 29, 2011

Steps to install Informatica Power Center Server 8.6

Steps to install Informatica Power Center Server 8.6

Pre-requisites:


1)Window xp sp2 ( You can also install the same on any high end OS ).
2)At least one database(here we assume you to have Oracle XE pre installed ).
3)2 GB Ram Recommended


Informatica 8.6 Server Installation:

1) Select the sever folder from the informatica installation CD.
2)There will find set up, click on the set up file.clip_image001
3)click on Next button.clip_image002

4)Select the license key by using browse button.It will be available the fallowing location:…\Informatica 8.6\RAWANA


5)Click on Next button

clip_image003

. 6)Click on Next buttclip_image004on.

7)Select complete radio button and click on Next button.

8)Leave the defaults and select next button.

clip_image005

9)Click on Install button
clip_image006

10) Choose create new domain radio button, and click on Next button.

clip_image007

  • Select database type
  • Database URL: ComputerName:portno

Eg:windows-4dc4631:1521

  • To find the computer name.. Click on Start->Right click on My computer->Properties->Computer Name.
  • Provide the database credentials along with the Service name.
  • Find database service name:
  • Control Panel--Administrative tools--Services

clip_image008

  • Here XE is the service name.
  • For Oracle 10g users you will find the service name like :OracleServiceORCL then service name would be ORCL.

Note:SQL Server users they can give the name of the server name in the above field instead of service name.

  • Click on Test connection:If this succeed then it will take you to the further step.

clip_image009

11. Leave the defaults, enter password and confirm password and click on next button.

clip_image010

12.Uncheck the check box and click on next button.

clip_image011

13. Click on Done.

14.After finishing installation need to run the services

Run the Informatica services:

windows+r->services.msc-> Locate the Informatica services –> Start them.

clip_image012

Configure the repository service and Integration service:

  • To create these two above, please follow the below steps.

clip_image013

  • Give your Credentials

clip_image014

clip_image015

  • Select administrative Console. Make sure Domain is running.

clip_image016

  • Make sure node is also running.From create drop down select repository service.

clip_image017

clip_image018

1)Enter any service name.

2)Select License.

3)Select database type as oracle (if your sys contains oracle db)

4)Select node for which you want to create repository.

5)Leave the code page as default.

6)Connection string if ORCL for oracle users(Make sure connection string should be same as the service name what is given while installing server)

7)Enter Database Credentials

8)Leave other defaults as well.

9)Click on create button.

10)Enable the repository service.

clip_image019

  • Now Create content for the repository by selecting drop down shown below.

clip_image020

Note:Make sure Processes are enabled and repository service is enabled.

Creation of Integration service:

clip_image021

clip_image022

1)Give any name for Integration sevice.

2)Assign node to the IS.

3)Assign Repository to the IS.

4)Enter the rep.username and password.

Note:make this username and password should same as username and password of the Repository service.

5.Select data movement mode as ASCII.

clip_image023

In the process tab of the IS, enable the process.

Before enable, edit this section and select “Code page” as shown above.

Now Install client.

Open Informatica Repository Manager.

clip_image024

clip_image025

Select the RS from the RHS pane and click on OK.

clip_image026

clip_image027

Connect to the repository service.

clip_image028

Enter the repository username and password.

clip_image029

No comments: