Thanks everyone. Contact information will be in my db, but I am just looking to verify if people are still working here. So read only names and possibly IDs is all I'm going to be asking for. Hopefully that won't be too painful.
Thanks! mcg Steven Ross <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/06/2007 09:27 PM Please respond to [email protected] To [email protected] cc Subject Re: [ACFUG Discuss] PeopleSoft? 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------
