RightNow and PeopleSoft

Business Challenge

Student records, and the application process are maintained in PeopleSoft, and marketing activity to attract new or repeat students is managed within RightNow. The challenge was that there was no way to tell what stage a student’s application was for the marketing team. This resulted in missed opportunities, or wasted calls to students who had already signed up. This resulted in data errors and inconsistency, as well as consuming a considerable amount of time for the staff involved. It also meant that the same student could be in both systems with different or duplicate details that were not linked.

Purpose	To synchronise Student Contact information between the PeopleSoft database and RightNow.
Applications	RightNow Peoplesoft
Versions	RightNow - Hosted Version Aug 09 Peoplesoft - SQL server 2008 staging table
Integration option	Boomi Atomsphere Boomi RightNow Connector Boomi Database Connector
Information	Student contact details
Data formats	No intermediate data format.
Data volumes	Batch process with ~200 records in each daily batch
Integration process	The process retrieves a "delta" of the daily changes in the Peoplesoft staging database, and then uses a combination of criteria including Student ID, emails etc to match, Create and update records in RightNow
Schedule	Daily
Time Spent	< 4 days
Complexity	Simple process with some complex matching filters.

RightNow and PeopleSoft

What is RIO

RIO ReadyMade

RIO In Action

Getting Started

Inside RIO