Creating Informatica Repository and Integration Service

In the earlier post we have completed Informatica server installation.

Now we will see how to create Informatica Repository Service as well as Integration Service.

Step 1: Login to Informatica Admin Console page using below url .( differs in your machine)

              URL:  http://win2008server:6007/administrator
              User Name: Administrator
              Password: Administrator

Step 2:  Here no Repository and Integration services are defined.( Marked with red color area).

Step 3: Click on Domain name, click "Action" -> "New" -> "Power Center Repository Service" to start creating Repository service.

Step 4:  Give repository name like "InfoREP" and select Licence and Node from the drop down boxes. Click "Next"

Step 5:  Provide the below details and Click "Finish" button.

              Database Type: Oracle

              User Name: inforep

              Password: Admin$1234

              Connection String: ORADB

Note: Before starting Informatica server installation, we have created two schemas.

           a) Infodom ( This will be used for domain configuration while Informatica server installation)

           b) Inforep  ( We are using this schema for creating repository service now)

Step 6: It will take few minutes to complete the process.

Step 7: Once the Repository service created, Make "Operating Mode" to "Normal" from "Exclusive".

Step 8: Now the repository will run in Normal mode.

Normal Mode: Normal mode provides full access to users with permissions and privileges to use a PowerCenter Integration Service.

Exclusive Mode: Safe mode limits user access to the PowerCenter Integration Service and workflow activity during environment migration or PowerCenter Integration Service maintenance activities.

We have successfully created Informatica repository service. Now we have to create "Integration service" to complete

Step 9: Click on Domain name, click "Action" -> "New" -> "Power Center Integration Service" to start creating Integration service.

Step 10: Give Name to Integration service, select Licence and Nod from the drop down box. Click "Next" to complete.

Step 11: Select previously created Repository, and give Username and Password. Finally click "Finish".

               Administrator/Administrator

Step 12: Click on domain to see whether Integration service is running or not.

 With this, we have completed creating Informatica Repository service and Integration service.

 Now the Informatica Service is ready to connect using Informatica Client tools.

In the next post we will learn about Informatica Client tools.

CHEERS :)