Steps for Installing Informatica 6.2

Note: Default means Don't Change

1. Login as Administrator with the Administrators rights User Id & Password.
2. Install all Informatica clients, repository servers and work flow mangers.
3. Install Oracle 8i/9i. While installing give Global database a name and SID as ORCL.
4. Create a user at the Oracle.
5. Select * from all_users
Create user Infodev identified by Infodev default tablespace users temporary tablespace temp. Grant connect, resource, select any table, insert any table, update any table, delete any table to Infodev.

Configuring Repository Server:
6. Note down your Computer name or IP address
7. Open Repository management console. Then, right click on Informatica repository server, then add “New server registration” as your computer name.
8. Right click repository => add repository (Infodev)
9. Repository Configuration:
Database type: Oracle
Code page: default (Don't change)
Repository Name: Infodev
Connect String: ORCL
DB User:Infodev (Created User at the Oracle Backend)
DB password: Infodev

The rest of the network & configuration Tabs maintain as default.

10. Repository Server:
Server Port number: 5001
Administrator Password: Give Administrator Password
Minimum Port: 5002
11. Once you have given all this information, it will start creating Repository (OPB) tables at the Oracle user you have created.
12. Once the repository is created, it will create a local repository and an option will be provided by Informatica to convert the local repository to a Global repository.
13. Convert the local repository to Global repository.
14. Now go to services. There you will find Informatica Repository server service. Start that service by giving the Administrator User ID & password.

Informatica Server Configuration:
15. Go to Informatica Server set up. Install the Informatica Server and login as Administrator. Use Administrator's rights User Id & Password and Domain as your computer name.
16. In Server set up, enter all the License keys for platform key, Oracle key ODBC key in Key tab.
17. In the server tab, you will need to enter server name once the sever is created at workflow manger. However, leave that blank for the time being.
18. Enter the TCP/IP address or computer name in this place, the rest leave set as the default.
19. In repository Tab
Repository Name: Infodev
Repository User: Infodev
Repository password: Infodev
Repository host name: Computer name
Repository port number: 5001
20. Compatibility & Database TAB: default values
21. Configuration TAB: default values
22. Open Server Manager, click the Add folders to Repository Server Manager.

Steps for registering Server in Workflow manager:
23. In the workflow manger, connect to the repository.
24. Choose connection server.
25. Add register to new server.
26. Give the name as temp_server.
27. Now server dialog box appears.
28. Enter the following Info:
Host Name: Your Computer name/IP address (IP address is better)
Port Number: 4001(default)
Code page: default
Timeout: 60
27. Server Variables:
$PMRootDir: C:\Program Files\informatica\informatica PowerCenter 6.2-Server - all others should be set to the default values
28. Now go back to the Informatica configuration. There in Server tab enter the name of server as temp_server. Click OK & apply.
29. Go to services, start Informatica Service. Login as Administrator with the User Id & password.
30. In workflow manager, right click the server and select monitor.
31. Now th