Informatica7.1: Installation Steps in WINDOWS XP ( Service Pack 2) Oracle 8i
/************************************************
* INFORMATICA 7.1 Installation Steps
* OS: WINXP(SP-2)
* Oracle 8i
*************************************************/
1. Create an user for informatica metadata:-
DROP user jupalli_user cascade;
CREATE USER jupalli_user IDENTIFIED BY jupalli_user DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
GRANT CONNECT,DBA TO jupalli_user;
2. Configure IRS( Informatica Repository Sever ):-
Server port no-- 5858 ( say )
Administrator password-- 5858 ( say )
Remaining all--Keep as it is.
3. Create a New Repository Server:-
Go to ( RSAC )Repository server admin console.
Right click on Informatica Repository servers
-->New server registration.
Hostname--yours computer name.
Portnumber--IRS port number ( Here 5858 )
-->ok
Try to connect.
If its not getting connected,go to services and check whether Informatica Repository Service is running or not.If its not running,start it.
Again try to connect.
Repository server will be created as the same name as yours computer name. ( here jupalli )
That jupalli will have 4 things in it
>> Repositories
>>Activity Log
>>Backups
>>Available Packages
4. Create a new repository in the newly created repository server:-
-->Right click on that Repositories folder in the newly created repository server.
GENERAL TAB
------------
Repository Name--> jupalli_rep
Keep remaining thing as it is.
DATABASE CONNECTION TAB
-------------------------
ConnectString-->orcl
DBUser-->jupalli_user
Keep remaining thing as it is.
NETWORK TAB
-------------
Keep remaining thing as it is.
CONFIGURATION TAB
------------------
Keep remaining thing as it is.
LICENCE TAB
--------------
Update by all keys.
-->Apply
Once press
-->ok
After finishes,double click on Repositories folder.You can see yours repository there (here utopia_rep)
5. Create a folder to work:-
Go to client-->Repository Manager ( RM ).
Double Click on your repository jupalli_rep
Connect to repository dilog box will come
Username-->jupalli_user
password-->jupalli_user
Once connected.Go to menuber-->Folder-->Create
Create folder dialog box will come.
Name -->jupalli_user_folder
Give its all permission
-->OK
Folder will be created.
6. Go to designer:-
Right Click on the repository ( jupalli_rep ).-->connect
Username--> jupalli_user
password-->jupalli_user
-->connect
If you press on more,it will repository server info.The hostname and port number.
The folder jus created above will be shown there.
-->righ click and then open the folder.
-->Tools-->source analyzer ( to create a source )
-->go to source-->IMport from database.
-->ODBC data source ( Urs own created data source ).
-->user/password is from oracle user and password from which schema you want your source table.
-->Tools-->Warehouse Designer ( To Create a target )
-->Tools-->Mapping Designer ( To create a mapping )
Save the mapping and check whether its valid or not.
7.Go to Workflow Manager:-
-:Creating a session:-
Connect to the repository jupalli_rep.
Open the jupalli_user_folder.
Menu-->Tools -->Workflow Designer.
Menu-->Workflows-->Create a workflow.
GENERAL TAB
-----------
Name-->jupalli_user_wrkflow1
Keep remaining things same.
PARAMETERS
-----------
Keep remaining things same.
SCHEDULER
----------
Keep remaining things same.
-: Creating a Task :-
Menu-->Tasks-->Create a task.
tasktype-->session
name-->jupalli_user_task1
Once you press
Pick up that mapping we have created in mapping designer earlier.
-->ok.
-->Done
-: Linking the task and the session :-
Menu-->Tasks-->link task.
Save and check whether the workflow is valid or not.
8. Server configuration:-
Now we need to create a server in which our workflow will run.
For that
Menu-->Server-->server configuration-->new.
Server name -->jupalli_user_wrkflow_server.
HOst name / IP address -->Computer name ( here jupalli)
server variables-->Create a directory in your local disk ( here e:\demo )
and then $PMRoot directory -->e:\demo
Keep remaining things same.
Then -->resolve server-->ok.-->close
If the resolving done succesfully,then its fine else check...
9. Assigning the server to workflow:-
Close yours folder in Workflow Manager.Right click on the workflow server-->Assign to workflows
Check the folder and session-->assign.
10. Creating relational database connection:-
Menu-->connections-->relational-->type-->oracle-->
new-->name :relCon_jupalli_user_src
user name-->scott-->password-->tiger-->connect string -->orcl
new-->name :relCon_jupalli_user_tgt
user name--> jupalli_user --> password --> jupalli_user -->connect string -->orcl
Keep Workflow Manager open.We`ll come back here soon.
11. Setting Informatica Server Configuration:-
Go to STart-->Programs-->INformatica server setup.
Configure.
SERVER TAB
------------
server name-->jupalli_user_wrkflow_server ( It should be same as workflow server name ).
TCP/IP Host address-->Keep it blank.
Keep remaining things same.
REPOSITORY TAB
---------------
repository name--> jupalli_rep
Repository user --> jupalli_user
Repository pasword --> jupalli_user
Repository Server Host Name --> jupalli( Or your computer name )
Repository Sever Port Number --> 5858
LICENCE TAB
-----------------
Update all keys if they are not there.
COMPATIBILITY AND DATABASE
----------------------------
Keep remaining things same.
CONFIGURATION
---------------
Keep remaining things same.
JVM OPTIONS
----------------
Keep remaining things same.
HTTP PROXY
---------------
Keep remaining things same.
Apply-->ok-->exit
Go to services-->make informatica server up.
If facing problem to make it up-Check
12. Make workflow to run:-
Come back to Workflow Manager.double click on the session-->click on mapping tab.-->
click on source-->set the relational connection.
click on target -->set the relational connection-->normal load not bulk.
Save the workflow again and check if its valid or not.
13. And finally run the workflow:-
Right click on task and start workflow.
14. Check the success/failure status in Workflow monitor.
Comments