Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 16 November 2014

Configuring Informatica PowerCenter Workflow Manager


By on 11:20:00




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


0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)