Peoplesoft EPM and Datastage Connectivity

vbeeram · Post by **vbeeram** » Mon Feb 21, 2005 10:36 am

Hi,

Where can I find white papers or literature about the conection process between DataStage 7.x and PeopleSoft EPM?

Any body know abt this connectivity?

Thanks
Vbeeram

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 21, 2005 11:11 am

At Ascential website under Partners topic.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 21, 2005 2:56 pm

To connect to the databases jobs use the Dynamic Relational Stage, with the access protocol set appropriately (Oracle, Sybase, IBM DB2, etc).

Table definitions have been preloaded for tables that contain PeopleSoft data.

vmcburney · Post by **vmcburney** » Mon Feb 21, 2005 4:10 pm

There is a product called DataStage for PeopleSoft and it comes packaged with PeopleSoft EPM. It is a Standard Edition of DataStage and comes with thousands of mappings out of the box and the PeopleSoft PACK for DataStage for extracting from PeopleSoft databases.

There is currenlty no version written using parallel jobs, mainly because the license is restricted to just 4 CPUs. There are upgrade license options to take you from Standard Edition to Enterprise Edition but all your jobs will still be Standard jobs and you will have to write your own parallel jobs.

To extract from core PeopleSoft systems you use the PeopleSoft PACK. To load to EPM you use database stages as shown in Ray's post. I believe that DataStage for PeopleSoft uses Dynamic RDBMS stages.