Configuring Relational and Application Connections in Informatica Workflow Manager
Installing and Setting Up Oracle BI Applications
4-69
4.12.2.2 How to Configure Application Connections for PeopleSoft OLTP Data
Sources
PeopleSoft OLTP data sources use Application Connections that implement
Informatica's PowerConnect for PeopleSoft. PeopleSoft OLTP data sources do not use
relational connections. Therefore, you need to use Informatica Workflow Manager to
define Application Connections for the PeopleSoft OLTP data sources as described
below.
Note
: You need to configure relational connections for OLAP databases with
PeopleSoft adapters (for more information, see
Section 4.12.2.1, "How to Configure
Relational Connections."
).
To configure Application Connections for PeopleSoft OLTP data sources:
1.
In Informatica PowerCenter Workflow Manager, select Connections, then
Application, to display the Application Connection Browser dialog.
You need to create an Application Connection for each PeopleSoft transactional
(OLTP) data source.
2.
For each Application Connection that you need to create, do the following.
a.
Click New to display the Select Subtype dialog, select the appropriate
database type (for example, PeopleSoft Oracle), then click OK to display the
Connection Object Definition dialog.
b.
Use the Connection Object Definition dialog to define an Application
Connection (for example, a connection named PSFT_9_0_HCM).
c.
Click OK to save the details.
Notes:
You must specify the Name value exactly as it appears in the Physical Data
Sources tab in the DAC Setup View. For example, if your source system is named
PSFT_9_0_HCM in DAC, then you must name this connection as PSFT_9_0_HCM.
For more information, see
Section 4.11.3, "Setting Physical Data Sources"
.