Thursday, August 7, 2014

Informatica 9x Installation on Windows 7 Part 3


5. Configure Repository Service
Step : 1
Go to Start menu and Click on “Informatica Administrator Home Page”. This will open up the Admin Console in a web browser.


 Step : 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






















 

Step : 3
Once you Log on you will see the Screen just like shown below.
























Step : 4
Choose your Domain Name from “Domain Navigator”, Click on “Actions”, Choose “New” and “PowerCenter Repository Service”.


























Step : 5
A new screen will appear, Provide the details as shown below.
o    Repository Name : Your Repository Name.
o    Description :  An optional description about the repository.
o    Location : Choose the Domain you have already created. If you have only one Domain, this value will be pre populated.
o    License : Choose the license key from the drop down list.
o    Node : Choose the node name from the drop down list.
Click Next.






















 


Step : 6
A new screen will appear, Provide the Repository database details.
o    Database Type : Choose your Repository database (Oracle/SQL Server/Sybase)
o    Username : Database user ID to connect database.
o    Password : Database user Password.
o    Connection String : Database Connection String.
o    Code Page : Database Code Page
o    Table Space : Database Table Space Name
o    Choose “No content exists under specified connection string. Create new content”
Click Finish

























Step : 7
It takes couple of minutes create Repository content. After the repository creation below screen will be seen.


























 Step : 8
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.
























Step : 9
A pop up window appears, Set the properties
o    Operation Mode : Normal
o    Security Audit Trail : No
Click OK.

Click OK for the next two pop up windows which confirms the Repository Restart to change the Repository Operating Mode.


6. Configure Integration Service
Step : 1
Choose your Domain Name from “Domain Navigator”, Click on “Actions”, Choose “New” and “PowerCenter Integration Service”.

























Step : 2
A new window will appear, Provide the details as shown below.
o    Name : Your Integration Service Name.
o    Description :  An optional description about the repository.
o    Location : Choose the Domain you have already created. If you have only one Domain, this value will be pre populated.
o    License : Choose the license key from the drop down list.
o    Node : Choose the node name from the drop down list.
Click Next.





















Step : 3
A new window will appear, Provide the details as shown below.
o    PowerCenter Repository Service : Choose your Repository Service Name from the drop down list.
o    Username :  Admin user name.
o    Password : Admin password.
o    Data Movement Mode : ASCII.
Click Finish.


























Step : 4
A pop up window will appear, Choose the Code Page as ANSI.
Click OK.

























Step : 5
Window will be closed and you can see all the configured services in the “Domain Navigator”




































With that we are all done with the installation and configuration for Informatica PowerCenter Server.





No comments:

Post a Comment