Saturday, February 13, 2010

Step-By-Step Installation Guide for Informatica PowerCenter Server v8.6


Pre-requisites:

1)Window xp
os(vista will not support most of the times)
Vista
users can able to install this in VM
ware(Virtual Machine)

2)Atleast one database(ex:Oracle,Sql,Teradata, etc..)


3)1GB Ram


4)System should support Java ,

If all the above conditions are satisfied then continue installation with the help given below steps.

Informati 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.Then will see below window.











3)Here simply click on Next button.


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.
6)Click on Next button.


7)Select complete radio button and click on Next button.
8)Leave the defaults and select next button.

9)Click on Install button

Select create new domain radion button, and click on Next button.

  • Select database type
  • Database URL: ComputerName:portno
  • Ex:abc-pc:1521
  • To find the computer name:Go to my computer propertiesàcomputer Name tab.
  • Database userId:scott(if you are using oracle 10g)
  • Database UserPassword: Tiger(if you are using oracle 10g)
  • Database service name:Orcl(if you are using oracle 10g)
  • Find database service name:
  • Control Panel--Administrative tools--Services

Here XE is the service name.

For Oracle 10g users you will find the service name like :OracleServiceORCL

Here service name is 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.

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


Uncheck the check box and click on next button.

Click on Done.After finishing installation need to run the services

Run the Informcatica sevices:

Control Panel ->Administrative tools->Services->


Configure the repository service and Integration service:

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


Enter the user name and password

Select administrative Consol

Make sure Domain is running.


Make sure node is also running.

From create drop down select repository service.



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)Connction 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 user name and password.

8)Leave other defaults as well.

9)Click on create button.

10)Enable the repository service.



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



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


Creation of Integration service:



1)Enter 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.



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.


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

Connect to the repository service.



Enter the repository username and password.


Hope this helps,Thank you.

8 comments:

  1. hi ram
    thans for ur blog
    but i am facing a problem when i am creating integration service
    [REP_57262] Unable to handle request because repository contents do not exist.
    and one more thing i can't able to create contents to my repository service also it is showing failed creation plz help me in doing
    ThanQ
    Kalpana.N
    kk.narra@gmail.com

    ReplyDelete
  2. The codepage option also disabled not able to select any code type i want ur advice
    ThanQ

    ReplyDelete
  3. This helped me a lot in installing.
    For informatica scenarios: informatica scenarios

    ReplyDelete
  4. hi i am facing problem to install informatica 9.1.0 .. please help me .... Getting error .. The connection failed.Correct the database connection information and test the connection again"


    Mai ID: vinay4125@gmail.com

    ReplyDelete
  5. iam facing the problem how to instaliation process pls tell me



    my mail id: varadareddy999@gmail.com

    ReplyDelete
  6. As we heared more and more tips which enable us for writing for the content. But with this especially how the authoritative really nice. I agree with your 3 point include with more images and videos. It will enable the readers without any confused or any other thing and finally cleared with what we are going to tell.


    MSBI Training in Chennai

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete