Question Re: Integration with PeopleSoft in Technology Q&A

Integration with PeopleSoft

Former Member — Thu, 14 Jul 2005 16:14:28 GMT

Hi All,

I wanna know whether i can integrate PeopleSoft into SAP EP.

I wanna read some records from PeopleSoft HRMS

and display that in my Portal as an iview.

Do i need to create some system to read the data.

of corse it will be then what is the template i shud use.

what are the parameters?

Regards,

Joshua Kiran.

Re: Integration with PeopleSoft

Former Member — Fri, 15 Jul 2005 02:57:42 GMT

Kiran,

To my knowledge..

There is no predelivered template for peoplesoft system. However depends on the data you are trying to retrive you have the following options.

1. The data trying to access is already available through Peoplesoft webclient interface. In this scenario

probably by using the appintegrator/URL iview with usermapping you can integrate into portal.

2. You want to read some custom data then probably you can create a database connectionpool and access the data directly by using JDBC API (DAO) as a custom IVIEW.

Again the other factors to consider are if the portal is external facing portal etc.

Hope this helps.

Regards

-Venkat Malempati

Re: Integration with PeopleSoft

Former Member — Mon, 18 Jul 2005 08:57:29 GMT

Thank you Venkat,

>>2. You want to read some custom data then probably you can create a database connectionpool and access the data directly by using JDBC API (DAO) as a custom IVIEW

Little more explanation is appreciated.

Do you mean that i dont require any system for this.

Kindly send me piece of code so that i can understand it precisely.

<b>My requirement is : I have to read a record from PeopleSoft HRMS and display that as an iview in EP</b>

Thanks and Regards,

Joshua Kiran

Re: Integration with PeopleSoft

Former Member — Mon, 18 Jul 2005 23:20:42 GMT

Joshua,

You can write a custom iView to read data from HRMS database. When it comes to the code it is java code using JDBC API.

If you need an example send me an e-mail.

Regards

-Venkat Malempati

Re: Integration with PeopleSoft

Former Member — Thu, 21 Jul 2005 11:10:52 GMT

Hi venkat,

You did not respond to the mail i've sent to ur personal mail-id.

Please do explain me about How to read data from PeopleSoft HRMS by using JDBC API.

Thanks and Regards

Joshua Kiran

Re: Integration with PeopleSoft

Former Member — Thu, 21 Jul 2005 12:15:29 GMT

Hi Kiran,

Sorry I couldn't respond earlier. This week has been extremely hectic and have to catch up on lot of SDN.

I am sending the the par file use this as a reference.

Please don;t share it with anybody and I appreciate the respect for privacy.

Regards

-Venkat Malempati

Re: Integration with PeopleSoft

Former Member — Thu, 04 Aug 2005 22:34:15 GMT

Can you also please send the par file to me? Thanks.

Re: Integration with PeopleSoft

Former Member — Fri, 05 Aug 2005 04:37:50 GMT

Hi Anderson ,

Could u plz send me ur mail-id so that i can send the par file which Venkat had send it to me.

cheers,

Joshua Kiran

Re: Integration with PeopleSoft

Former Member — Tue, 09 Aug 2005 22:44:48 GMT

Hi Venkat: I found your post very useful. Could you please help me with a step further. I am looking to build iViews in EP to point to Peoplesoft's Travel and Expense page. I understand the following steps are useful:

1. create peoplesoft as a data source, and enable user mapping

2. create URL iView in EP and point to Peoplesoft.

First, could you pleaes veridy whether this is accurate? Second, what is the structure of the URL iView that will pull Peoplesoft's T&E page?

Thanks!

Re: Integration with PeopleSoft

Former Member — Tue, 16 Aug 2005 19:07:31 GMT

Hi Manish,

Can I get your email address. I need your help.

Thanks in advance.

Rana

Email: rana_kp@hotmail.com

Re: Integration with PeopleSoft

Former Member — Thu, 18 Aug 2005 06:34:14 GMT

Hi Venkat,

We are also having the same problem in transfering data from our peoplesoft system to SAP system.

In this regard we need your valuable suggestions.You have already given some suggestions to Mr. Kiran but we couldn't follow it. Can you please explain it to us in details.

Regards,

Sathish Selvarajan.

Re: Integration with PeopleSoft

Former Member — Wed, 11 Jan 2006 05:52:50 GMT

Hello Venkat,

I need to integrate Peoplesoft into EP and dispaly some iviews also..i saw your answers could u plz help me if have any procedure to Integrate this is my client new requirement..

Thanks in Advance ........

plz send to personal ID : yamsanisridhar@yahoo.com

Bye

Sreedhar

Re: Integration with PeopleSoft

Former Member — Wed, 11 Jan 2006 10:53:32 GMT

Hi Kiran,

This is jagadish, here my client have also same requirement is there, i don't know what are the prerequisites for integration of peolesoft with portal, pls tell,

Regards,

Jagadish Babu Kanikanti