Yeah I too did a pull from a PS datasource although the SQL was
written in an asp page and all I did was pull it into CF with a few
minor modifications. It can be done if you know the PS schema. As
Precia mentioned though it is a nightmare. Thats why there are people
who do nothing but peoplesoft. I worked for a company that just
outsourced their peoplesoft DBA so when we needed something done they
had to contact him. Getting at the data isn't a problem it is figuring
out where to select stuff from and how to form all your joins across
many many tables that is the difficult part.
-Steven
On 2/6/07, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
I do this daily. Besides the group I'm in interfacing with PS, our HR IT
department uses CF for all the custom people forms. Think employees ids,
position numbers, and reporting trees...yeehaw
DK
On 2/6/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED] > wrote:
>
> Anyone ever connected ColdFusion to PeopleSoft? I know squat about PS,
and there is the small potential that my app could connect with it one day.
This might be nice to connect to the payroll system to validate if contacts
still work here. But this was just tossed out there today as a way to
accomplish, "Periodic queries of external systems and comparison with
existing contact list identifies discrepancies to be investigated"
(beginnings of BRD).
>
> Mary-Catherine
>
-------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink
>
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 267-482-4364
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
