✍ Kashif M
Trends

Sunday, 16 November 2014


Configuring Informatica PowerCenter Workflow Manager


By on November 16, 2014




Configuring Relational Connections in Informatica PowerCenter Workflow Manager



Navigate to Start > All Programs > Informatica PowerCenter 8.6.0 > Client, click PowerCenter Workflow Manager






Right click on Oracle_BI_DW_Base. Click Connect








Enter Password 'Administrator'. Click Connect












Screen shows the Oracle_BI_DW_Base Repository Adaptors










Choose Connections from the menu, then Relational to display the Relational Connection Browser.

Create connection for each transactional (OLTP) database, and a connection for the Oracle Business Analytics Warehouse (OLAP) database.






In the Relational Connection Browser screen, select Oracle from the list.




Click New










Enter the Connection Object Definition, for example:



Name = ORA_R12 (Same as the Physical Data Source name defined in DAC)

User Name = apps

Password = apps

Connection = R12PLY



Keep other default values and settings intact. Click OK to return to Relational Connection Browser








Click New again. Enter the Connection Object Definition, for example:



Name = ORA_11_5_10 (Same as the Physical Data Source name defined in DAC)

User Name = apps

Password = apps

Connection = V11510



Keep other default values and settings intact. Click OK to return to Relational Connection Browser










Click New again. Enter the Connection Object Definition, for example:



Name = DataWarehouse (Same as the Physical Data Source name defined in DAC)

User Name = baw

Password = baw

Connection = orcl



Keeping other default values and settings intact. Click OK to return to Relational Connection Browser



Click Close. Exit Informatica PowerCenter Workflow Manager.










Stop and Start the Informatica Services


Kashif
mkashu: Configuring Informatica PowerCenter Workflow Manager
Review : Kashif | Kashif
Update: November 16, 2014 | Rating: 4.5

Comment for "Configuring Informatica PowerCenter Workflow Manager"

0 comments

Post a Comment

Blog Archive