Wednesday, February 3, 2016

Informatica PowerCenter 9.0.1 Installation (Windows)

Informatica PowerCenter 9.0.1 Installation and Configuration Complete Guide
This article provides complete step by step instructions  for installation and configuration of Informatica PowerCenter 9.0.1. This includes the installation of server components, configuration of different Informatica services and client installation and configuration.
Order of Installation and configuration of Services.
        1. Installation of  Informatica PowerCenter Server.
        2. Configuring Repository Service.
        3. Configuring Integration Service.
        4. Installation of  Informatica PowerCenter Client .
        5. Configuring Domain
        6. Creating Folder in Repository.
1.Installation of Informatica server 9.0.1 On Windows7.
Step 1: Go to Informatica software location and open server folder as shown below:

Step-2: Explore server folder then you can see the sub-folders presented in it as shown below and  install.exe file or right click on it and run it as administrator.

Step 3: Go to Informatica software location and open server folder

Step 4: Choose the type of installation you want.

Step-5:Enter license key which has been generated along with your installation pack.
Step-6:It starts installation by creating domain as shown below

Step-7:It configures database credentials as shown below.
Step-8:  Configuring   Domain Credentials.
Step-9: After continuing the installation skip the user account details as shown below.

 Step-10:That’s all the installation is done as shown below:

2.Configuring Repository/Creating new repository:-  
     2.1 Up the Informatica Services:
      2.1.1: Goto →run→services   as shown below.

Select informatica services as shown below:
Go to Start menu and Click on “Informatica Administrator Home Page”. This will open up the Admin Console in a web browser.

step 2.1.2
Log on to Admin console using your Admin User ID and Password. You set your Admin User ID and Password in “Domain Configuration” section Step 3

2.2.Configuring Of Repository Service :
Step : 1
Choose your Domain Name from “Domain Navigator”, Click on “Actions”, Choose “New” Repository Service.
Step2 :  Creation of new Repository Service
  1. Repository Name :     infa_sss_repo (Your Repository Name).
2.    Description :  An optional description about the repository.(not mandatory)
3.    Location:    Choose the Domain you have already created. If you have only one Domain, this value      will be pre populated.
4.  License:   Choose the license key from the drop down list.
5.Node : Choose the node name from the drop down list and click next
Step : 3 Configuring  Database Credentials
A new screen will appear, Provide the Repository database details.
  1. Database Type : Choose your Repository database (Oracle/SQL Server/Sybase)choose according to your choice
  2. Username : infa_repo_user(Database user ID to connect database)the user we created earlier
  3. Password:  Database user Password.
  4. Connection String :  orcl (Database Connection String).
(Our database is oracle lo given string as orcl,it differs from databases)
  1. Code Page : (by default)Database Code Page
  2. Table Space : Database Table Space Name
  3. Choose “No content exists under specified connection string. Create new content” as shown below:

Enable the service ,After the repository creation below screen will be seen. The repository service will be running in “Exclusive” mode as shown below. This needs to be change to “Normal” before we can configure Integration service.
Click “Edit” Repository Properties.
3.Configuring Integration service:
Step-1: Select Integration Service to create  

Step : 2
A new window will appear, Provide the details as shown below.
Name: Your Integration Service Name.
Description:  An optional description about the repository.
Location: Choose the Location
License: Choose the license key from the drop down list.
Node : Choose the node name from the drop down list.
Click Next.


           Step3: Specify the user Credentials as shown below:
             Username:  Admin user name.
             Password : Admin password.
            Data Movement Mode : ASCII.

Step : 4
A pop up window will appear, Choose the Code Page as ANSI,Click Ok.
4.Installation of Informatica Power Center Client:  
Step : 1
Installation wizard Starts.  Choose the installation type as in the below image.
Click Next.

Step : 2
Installation Pre-requisites will be shown before the installation starts as below.
Click Next.
Step : 3
Choose the client tools you need. Only PowerCenter Client is mandatory.
Click Next.
Step : 4
Choose the client installation directory.

Click Next.
Step : 5
Click Install

Step : 6
Installation is completed  and you will get the post-installation summery,now the installation is done.
5.Configuring Domain :-

6.Creating folder in repository:
 That’s all The installation,configuring repository ,integration,domain and folder is completed


  1. That was a great message in my carrier, and It's wonderful commands like mind relaxes with  understand words of knowledge by information's.
    Python Training in Chennai

  2. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

  3. Nice information about test automation tools my sincere thanks for sharing post Please continue to share this post.

    mulesoft training course

  4. It was really a nice article and i was really impressed by reading this Informatica Online Training

  5. That's a tremendously interesting blog on Informatica. python training in Chennai

  6. This is a nice post in an interesting line of content.Thanks for sharing this article, great way of bring this topic to discussion.
    Click here:
    angularjs training in annanagar
    Click here:
    angularjs training in bangalore
    Click here:
    angularjs training in chennai
    Click here:
    angularjs training in velarchery

  7. Howdy, would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 completely different web browsers, and I must say this blog loads a lot quicker than most. Can you suggest a good internet hosting provider at a reasonable price?
    Click here:
    Microsoft azure training in marathahalli
    Click here:
    Microsoft azure training in bangalore
    Click here:
    Microsoft azure training in pune

  8. I am really happy with your blog because your article is very unique and powerful for new reader.
    Click here:
    Selenium Training in Chennai | Selenium Training in Bangalore | Selenium Training in Pune

  9. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    Blueprism training in Chennai

    Blueprism training in Bangalore

    Blueprism training in Pune

    Blueprism online training

    Blueprism training in tambaram

  10. This comment has been removed by the author.

  11. Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
    DevOps online Training

  12. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

    rpa training in electronic-city | rpa training in btm | rpa training in marathahalli | rpa training in pune

  13. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts
    java training in chennai | java training in bangalore

    java interview questions and answers | core java interview questions and answers

  14. I’m planning to start my blog soon, but I’m a little lost on everything. Would you suggest starting with a free platform like Word Press or go for a paid option? There are so many choices out there that I’m completely confused. Any suggestions? Thanks a lot.
    Best AWS Training in Marathahalli | AWS Training in Marathahalli
    Amazon Web Services Training in Anna Nagar, Chennai |Best AWS Training in Anna Nagar, Chennai
    AWS Training in Velachery | Best AWS Course in Velachery,Chennai
    Best AWS Training in Chennai | AWS Training Institutes |Chennai,Velachery

  15. Very well written blog and I always love to read blogs like these because they offer very good information to readers with very less amount of words....thanks for sharing your info with us and keep sharing.

    angularjs Training in marathahalli

    angularjs interview questions and answers

    angularjs Training in bangalore

    angularjs Training in bangalore

    angularjs Training in chennai

  16. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.

    advanced excel training in bangalore

  17. I really like the dear information you offer in your articles. I’m able to bookmark your site and show the kids check out up here generally. Im fairly positive theyre likely to be informed a great deal of new stuff here than anyone
    python training in rajajinagar | Python training in bangalore | Python training in usa

  18. Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
    excel advanced excel training in bangalore | Devops Training in Chennai

  19. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.

    AWS Training in Bangalore | Amazon Web Services Training in bangalore , india

    AWS Training in pune | Amazon Web Services Training in Pune, india

    AWS Training in Chennai|Amazon Web Services Training in Chennai,India

    aws online training and certification | amazon web services online training ,india

  20. This blog is the general information for the feature. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.
    Data Science training in rajaji nagar | Data Science Training in Bangalore
    Data Science with Python training in chennai
    Data Science training in electronic city
    Data Science training in USA
    Data science training in pune

  21. Thanks for making this guide and you have given such a clear breakdown of technology updates. I've seen so many articles, but definitely, this has been the best I?ve read!

    Selenium Training in Chennai
    Selenium Course in Chennai
    iOS Course in Chennai
    French Classes in Chennai
    Big Data Training in Chennai
    Android Course in Chennai
    Android Training Chennai

  22. This comment has been removed by the author.

  23. A much needed article right now since there was a urgent need of learning how to install Informatica and its related products.Thank you so much.

    Informatica Read Soap API.

  24. thanks for your article it's very nice and useful keep updating many blog thanks for it web design company in velachery

  25. It's a wonderful post and very helpful, thanks for all this information about Java. You are including better information regarding this topic in an effective way.Thank you so much.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

  26. Woah this blog is wonderful i like studying your posts. Keep up the great work! You understand, lots of persons are hunting around for this info, you could help them greatly.share some more.
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

  27. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. data science training in coimbatore