Re: [ACFUG Discuss] PeopleSoft?
Sounds like a good idea for this. Was this export done via PS or on the application/ db side? Thanks mcg [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/07/2007 05:06 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] PeopleSoft? Mary: We have a nightly dump from PeopleSoft into a seperate database. We use this information to power our phone book and other human resources related applications. This approach allows the applications that need this information to access it without worrying about secure info (like salaries) leaking out. Since PS is a relational db application, this is fairly easy to set up. Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2007 03:43 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] PeopleSoft? 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 gif2cktkeGZB3.gif Description: GIF image
Re: [ACFUG Discuss] PeopleSoft?
Sounds like all you need is a view created... On 2/8/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Sounds like a good idea for this. Was this export done via PS or on the application/ db side? Thanks mcg [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/07/2007 05:06 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] PeopleSoft? Mary: We have a nightly dump from PeopleSoft into a seperate database. We use this information to power our phone book and other human resources related applications. This approach allows the applications that need this information to access it without worrying about secure info (like salaries) leaking out. Since PS is a relational db application, this is fairly easy to set up. Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2007 03:43 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] PeopleSoft? 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 - --_alternative 0056725E8525727C_-- -- 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 -
Re: [ACFUG Discuss] PeopleSoft?
Yes, I have connected it 3 years ago. It's been quite some time since I have visiting that information. Precia 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.edituserformhttp://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 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 -
Re: [ACFUG Discuss] PeopleSoft?
Can you access the Oracle db PS sits on? Precia On 2/6/07, Precia [EMAIL PROTECTED] wrote: Yes, I have connected it 3 years ago. It's been quite some time since I have visiting that information. Precia 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.edituserformhttp://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 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 -
Re: [ACFUG Discuss] PeopleSoft?
Yeah you will just need a peoplesoft dba to write your queries... wacky stuff that people soft. On 2/6/07, Precia [EMAIL PROTECTED] wrote: Can you access the Oracle db PS sits on? Precia On 2/6/07, Precia [EMAIL PROTECTED] wrote: Yes, I have connected it 3 years ago. It's been quite some time since I have visiting that information. Precia 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 - - 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 -
Re: [ACFUG Discuss] PeopleSoft?
So it can be done. How painful was this? Is it just a data source or are there square shaped, moving hoops you have to jump through? mcg Precia [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/06/2007 03:55 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject Re: [ACFUG Discuss] PeopleSoft? Yes, I have connected it 3 years ago. It's been quite some time since I have visiting that information. Precia 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 - - 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 - - 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 -