Hi,
i have read in the forums that normally people who work on ERP APPLICATIONS like peoplesoft integrated with datastage go for scheduling tool like peopletools process scheduler, why does they go for this particular scheduler, does it comes integrated with peoplesoft.
i have also read in the forum abt DRS PLUGIN where the datasource is a jobparameter, can we use jobparameters as datasource or target. can u plz specify which source and target stages are commonly used when u deal with ERP APPLICATIONS like PEOPLESOFT.
cheers;
saama
regarding peopletools process scheduler
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray,
what abt PEOPLE TOOLS PROCESS SCHEDULAR, does it has any advantages over other 3rd part tools like control-m, event coordinator, autosys.
and as we have default stages like ODBC STAGE OR OCI STAGE as source or target stage when we deal with oracle database, can i get some information as which source stage is used when we deal with peoplesoft.Atleast list of sample stages.
cheers;
saama
what abt PEOPLE TOOLS PROCESS SCHEDULAR, does it has any advantages over other 3rd part tools like control-m, event coordinator, autosys.
and as we have default stages like ODBC STAGE OR OCI STAGE as source or target stage when we deal with oracle database, can i get some information as which source stage is used when we deal with peoplesoft.Atleast list of sample stages.
cheers;
saama
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am completely agnostic about schedulers; whatever my clients choose is their call. I do not offer "this is better than that" advise ever, because such comparisons can change over time.
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.
And you really only have two choices when dealing with databases: Native or ODBC. Me, I always prefer a 'native' interface over something like ODBC, but that's just me.
For Oracle, the native stage is the Oracle OCI stage you mentioned. You will need an appropriate Oracle client installed on the DataStage server to use it, however. That's also true for any 'thick' ODBC drivers, i.e. that are not 'wire' drivers - wire drivers do not require the client in order to work.
The DRS stage does either, but I personally wouldn't use it because of the way it handles everything in an 'ODBC-centric' fashion.![Confused :?](./images/smilies/icon_confused.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
For Oracle, the native stage is the Oracle OCI stage you mentioned. You will need an appropriate Oracle client installed on the DataStage server to use it, however. That's also true for any 'thick' ODBC drivers, i.e. that are not 'wire' drivers - wire drivers do not require the client in order to work.
The DRS stage does either, but I personally wouldn't use it because of the way it handles everything in an 'ODBC-centric' fashion.
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers