Minnu's Blog on Informatica & Data warehouse concepts

Archives

Friday, May 4, 2007

Informatica Installation & Configuration

free html hit counters
www.hit-counter-download.com


Pre-Requisites



  1. XP Professional or Media Center or The Server Editions
  2. Oracle installed
  3. Network card on the pc
  4. User id on system with Admin Privilages
  5. Oracle user id with sufficient privilages so that repository server can create its database tables

Steps Involved

  1. Installation of Informatica
  2. Configure Informatica Repository Server
  3. Start Informatica Repository Service
  4. Create a Repository Server
  5. Create a Repository
  6. Make a folder in the repository to store your mappings, maplets etc
  7. Now finally configure your Informatica Server

Installation of Informatica
Free Image Hosting at allyoucanupload.com

Double click on Lanuch

Free Image Hosting at allyoucanupload.com

Click on Power Center for Windows

Free Image Hosting at allyoucanupload.com

Click Next

Free Image Hosting at allyoucanupload.com

Leave options to default settings & click next

Free Image Hosting at allyoucanupload.com

Click on Yes & then on Next

Free Image Hosting at allyoucanupload.com

Enter the name of your Enterprise, The product key that you got & then click Next

Free Image Hosting at allyoucanupload.com

Click Next

Free Image Hosting at allyoucanupload.com

Next again

Free Image Hosting at allyoucanupload.com

Click on Ok

Free Image Hosting at allyoucanupload.com

Just click next

Free Image Hosting at allyoucanupload.com
Click on Finish

Repository Server Config & Starting Repository Service Free Image Hosting at allyoucanupload.com

The above screen is to configure repository service. Just enter a password for administration of repository. This password is usefull while you create repository's. After you enter a password just click on OK leaving all the options to default.

Free Image Hosting at allyoucanupload.com

Now right click 'My Computer', Click on Manage, Go to services & Start the Informatica repository service.


Free Image Hosting at allyoucanupload.com

Change the startup type to automatic so that you dont have to do this all over again whenever computer reboots. Click on apply & then on OK.

Creation of Repository
Free Image Hosting at allyoucanupload.com

Go to Start Menu -> All Programs -> Informatica PowerCenter -> Informatica PowerCenter Client -> Repository Server Administration Console

Free Image Hosting at allyoucanupload.com

Right Click Informatica Repository Servers & Click on New Server Registration

Free Image Hosting at allyoucanupload.com

Enter your System Name & then click on OK

Free Image Hosting at allyoucanupload.com

Now right click on your system name i.e. displayed & click on Connect

Free Image Hosting at allyoucanupload.com

Enter the password that you have created while configuring Informatica repository Server

Free Image Hosting at allyoucanupload.com

Right click on the repositories & Click on Create New Repository

Free Image Hosting at allyoucanupload.com

In the General TAB, Enter a name for your repository & Then click on Database Connection TAB.

Free Image Hosting at allyoucanupload.com

Now Enter the Connect String for your database & User id & PWD of the Database user in which repository server can create all its tables, Then click on Licences TAB.

Free Image Hosting at allyoucanupload.com

Enter the Product licence key first & then click on Update, Then Enter Connectivity Licence & Update again, Then the Optional Licence Keys you got & Then Update

Free Image Hosting at allyoucanupload.com

When all licences are updated, You can see the screen as above. Now Click on Apply. The Repository will be created now. Now click on OK.

Free Image Hosting at allyoucanupload.com

After the repository is succesfully created, You can see the screen as above.

Creating the Folder in Repository

Free Image Hosting at allyoucanupload.com

Go to Start Menu -> All Programs -> Informatica PowerCenter -> Informatica PowerCenter Client -> Repository Manager

Free Image Hosting at allyoucanupload.com

Right click on your repository name & click on connect

Free Image Hosting at allyoucanupload.com

Enter the user id & pwd of oracle database that you have used to create repository

Free Image Hosting at allyoucanupload.com

Click on Folder in the menu bar & click on Create

Free Image Hosting at allyoucanupload.com
Enter a name for your folder & click on OK. Leave rest of options to the defaults.

Configuring Informatica Server
Free Image Hosting at allyoucanupload.com

Click on Continue

Free Image Hosting at allyoucanupload.com

In the server TAB, Enter your system name, Give the IP address as 127.0.0.1 & Now click on Repository TAB over the top

Free Image Hosting at allyoucanupload.com

Enter the name of repository that you have created before, Then enter the user name & pwd of oracle database user that you have used while creating repository, Enter your system name & Now click on licences TAB

Free Image Hosting at allyoucanupload.com

Update with all licence keys you have got i.e Product, Connectivity, Optional respectively. Click on apply & OK


***** Now your informatica is fully installed & configured. You can use desginer, workflow manager BUT before you run the workflow you need to start an other service called the Informatica Service. If you start it before it may stop automatically as it may not have any job to execute.

So at your first workflow execution go to services & Make this service as automatic & start the service.
Free Image Hosting at allyoucanupload.com

------------------ ------------------------------------------------------------------------------

3 comments:

SAM said...

Hey can u upload Informatica PowerCenter 7 on some storage site...

Anonymous said...

can u mail the links at king166@gmail.com

Kiran said...

Hay, hi, h r u,
can you send me the informatica 8.1.1 software to me.
my mail id is
kkirankumar.net@gmail.com