How to fetch the data from peoplesoft and update to Servicenow?

[singhkuldeep]

We have a requirement, where we need to get the real time data from peoplesoft to ServiceNow.

if new user gets created on peoplesoft,his/her information should be update in Servicenow.

[zica]

Kuldeep,

You can use the Mid Server to integrate with PeopleSoft.   create a probe that runs a poweshell script at the mid server and returns all your users and their attributes from the common table. it should Work great.

I also found this thread : Integration with Peoplesoft

[Harsh Vardhan]

Hi Kuldeep,

Just want to add another link. hope it will help you.

Servicenow Integration with PeopleSoft

Regards,

Harshvardhan

Hit Like/Helpful/Correct if applicable

[singhkuldeep]

Hello AKb and Harsh, thanks for reply.

PeopleSoft is an inhouse application where Snow is in cloud, i was trying to check if it is possible to get the data sync in a real time on both platform.

I was planning to create a staging table in servicenow where peoplesoft can send the data on hourly basis or whatever looks feasible.

would webservice be best solution for this? considering there are users around 4500..

appreciate your response on this..

[TrevorK]

Sync'ing of users can be done multiple ways. You could just schedule a job to run on ServiceNow and query the PeopleSoft database server (via the ServiceNow MID Server) on a regular basis. You would look for new user profiles and either create or update SN accordingly. Because this is a read-only view (or should be), there should be no problems in terms of voiding your PeopleSoft support or scaring your PeopleSoft developers.

Another way would be to have a database trigger on your PeopleSoft database server. When a record is inserted or updated, have the database trigger call a web service that communicates with ServiceNow. The big question around this is What will your PeopleSoft developer think of such a customization? I imagine if I asked a question like this of our PeopleSoft developers it would take at least 5 minutes to calm their laughter down before I am told No.

No matter what you do, this is really a conversation for you to have with your PeopleSoft development team. In our company, we read the database directly.   In some companies they may build an actual integration to read off of. ServiceNow is not your limitation, what your PeopleSoft team will support is. I would urge you to talk to them about what they are willing to offer you for reading the data you want, and then you can just build your solution around what they are willing to give you. They are the best people to tell you what PeopleSoft can do to provide you the data (and what they are willing to do), not a group of ServiceNow developers.

Sorry it's not the answer you are looking for, but I think it's the best course of action.