Repository Server & PowerCenter Server Configuration Manual
Following steps to be followed to configure repository server
Configuring Repository Server
Admin Pwd : hello which is used while connecting / creating a repository in repository admin console
Prepared by Marathon Team
1
Repository Server & PowerCenter Server Configuration Manual Following steps to be followed to configure Informatica server
Configuring Informatica Server
Prepared by Marathon Team
2
Repository Server & PowerCenter Server Configuration Manual
Infa_Server
The server name specified has to be used while creating a server in Server Configuration under Option Server in Workflow Manager
Prepared by Marathon Team
3
Repository Server & PowerCenter Server Configuration Manual
Rep pwd: hai In Repository Admin Console, create a repository with the name RepTrial.
Prepared by Marathon Team
4
Repository Server & PowerCenter Server Configuration Manual
Give the product key, Connectivity Keys and Options key (Team Based Development) from the patch file. Note: start the Informatica repository server then go to Admin console
Prepared by Marathon Team
5
Repository Server & PowerCenter Server Configuration Manual
Rt. Click on Informatica Repository Server -> New Server Registration
Prepared by Marathon Team
6
Repository Server & PowerCenter Server Configuration Manual
Hello
The above password should be same as that of the one specified while configuring the Repository Server.
If above error is encountered, you must start the Infa Repository server in services.
Prepared by Marathon Team
7
Repository Server & PowerCenter Server Configuration Manual Creating new database for Repository Creating new user in oracle: Syntax: create user <user name> identified by
Eg. create user pand identified by good; grant privilege: Syntax : grant connect,resource to <username> Eg. grant 0connect,resource to pand
Create New Repository: Create new repository after registering the server.
Prepared by Marathon Team
8
Repository Server & PowerCenter Server Configuration Manual
RepTrial R
Give Repository Name RepTrial as given in Server Configuration
Prepared by Marathon Team
9
Repository Server & PowerCenter Server Configuration Manual
Specify the DB user and DB Password created earlier
Prepared by Marathon Team
10
Repository Server & PowerCenter Server Configuration Manual
Prepared by Marathon Team
11
Repository Server & PowerCenter Server Configuration Manual Provide the all Patch License Keys
Note: The same patch keys should be updated in Repository connection & server Connection.
Prepared by Marathon Team
12
Repository Server & PowerCenter Server Configuration Manual Creating Repository…..
A new Repository has been created
Prepared by Marathon Team
13
Repository Server & PowerCenter Server Configuration Manual
First time, when you are connecting to Repository Manager, Use the repository database conection and pwd. For Eg. Use User: pand and pwd: good In Repository database pand: 247 Metadata tables would be created No. of Tables Created: 163 No. of Views Created: 64
Prepared by Marathon Team
14
Repository Server & PowerCenter Server Configuration Manual Then go create users and groups. Assign Priviliges. Create Folders and Assign Permissions
Prepared by Marathon Team
15
Repository Server & PowerCenter Server Configuration Manual
Prepared by Marathon Team
16
Repository Server & PowerCenter Server Configuration Manual
Prepared by Marathon Team
17
Repository Server & PowerCenter Server Configuration Manual
In Workflow Manager Create Server under Server-> Server Configuration
Prepared by Marathon Team
18
Repository Server & PowerCenter Server Configuration Manual
Create Relational Connections Connections -> Relational: For source and target
Note: Before running the session ,need to start Informatica service
Prepared by Marathon Team
19
Repository Server & PowerCenter Server Configuration Manual
Reason: 1) Server is not initialized and assigned to the workflow 2) Server Service is not started.
Prepared by Marathon Team
20