Page 1 of 1
Peoplesoft EPM and Datastage Connectivity
Posted: Mon Feb 21, 2005 10:36 am
by vbeeram
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
Posted: Mon Feb 21, 2005 11:11 am
by Sainath.Srinivasan
At Ascential website under Partners topic.
Posted: Mon Feb 21, 2005 2:56 pm
by ray.wurlod
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.
Posted: Mon Feb 21, 2005 4:10 pm
by vmcburney
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.