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
Peoplesoft EPM and Datastage Connectivity
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Table definitions have been preloaded for tables that contain PeopleSoft data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn