Regarding Connecting to PeopleSoft from Datastage Px

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
haimadhu3
Participant
Posts: 2
Joined: Thu Mar 29, 2007 3:18 am

Regarding Connecting to PeopleSoft from Datastage Px

Post by haimadhu3 »


Hello,

I'm Madhuri.
I use DS Enterprise Edition(Px) and have Oracle as the underlying Database. I am using PeopleSoft as a FrontEnd Application .
In which stage of Datastage Px , can i use Connectivity to PEOPLESOFT CRM ?

Thanks,
Madhuri.A.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. :D

The PeopleSoft PACK that you can buy from PeopleSoft consists only of server jobs and associated table definitions and routines.

While you CAN access the Oracle tables on which you have PeopleSoft running from parallel jobs, there are no short cuts. You would have to import the Oracle tables' definitions and to analyze what is in each of the columns.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Regarding Connecting to PeopleSoft from Datastage Px

Post by chulett »

haimadhu3 wrote:I use DS Enterprise Edition(Px) and have Oracle as the underlying Database. I am using PeopleSoft as a FrontEnd Application .
In which stage of Datastage Px , can i use Connectivity to PEOPLESOFT CRM ?
Anything that can connect to Oracle - the Oracle Enterprise stage, for example. ODBC. DRS in Server jobs. Nothing magical about it, just another Oracle database. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You working with Lakshmi?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply