Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICA

Third Party and Custom-Built Application Integration with PeopleSoft Enterprise Portal

June 2007

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAToday’s Presenters

Jim Gallamo Director

Sonya Hughes Web Specialist

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAPresentation Overview

Catholic University uses the PeopleSoft Enterprise Portal to deliver custom, third- party and PeopleSoft applications to the end user community.

This presentation highlights our experience in delivering this service.

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAOutline

• CUA • Technology Environment• Goals• Key Considerations• Systems• Snapshots• Questions

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAOverview

• Located in Washington, DC • Founded in 1887• 6000 Students• 1500 Faculty and Staff• Undergrad, Grad and Doctoral programs• 12 Schools including Law School• Research – Tier II

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICATechnology Environment

• PeopleSoft systems– SA/HRMS v8.0 SP1, Financials v8.4, EPM v8.8– Enterprise Portal v8.8

• Oracle and MS SQL Server databases• Dell and Sun Microsystems servers• Windows and Solaris operating systems• ASP, Cold Fusion, WebLogic and PeopleTools• Cisco Content Server Switches (CSS)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICA

Goals• One stop for all administrative systems• Minimize individual user accounts• Provide role based content• Centralized communication mechanism• Tie into campus central directory

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAIntegrated Systems• PeopleSoft Enterprise Portal• PeopleSoft Student Administration• PeopleSoft Human Resource Management• PeopleSoft Enterprise Performance

Management• Adirondack Solutions MyHousing• Degree Audit System (DAS)• Judicial Affairs Management (JAMS)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAKey Considerations

• Integrating a diverse set of products• Secure connections, data and access• Providing unique user authentication • Establishing specific methods for passing

authentication tokens• Validating the source of authentication

tokens• Making these methods reusable

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAApplication Connectivity

• PeopleSoft– Single Sign-on connectivity between platforms– Validation of user in Enterprise Portal only– Successful for SA/HRMS, EPM, Financials

• Non-PeopleSoft Products– Use iScript to provide an authentication token of

EMPLID via hidden URL parameter

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Station – Enterprise Portal

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Station – Enterprise Portal

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Students

• Student Administration System (SR, FA, SA, AD)• Full site within Enterprise Portal• Available to Applicants, Faculty, Students, Staff

and Alumni• Provide consolidated navigation in an organized

manner• Role-based security controlling the availability of

Homepage tabs, CREFs and Pagelets• Contains navigation to other SA/HRMS integrated

third-party products

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Students (SA/HRMS) (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Students (SA/HRMS) (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Students (SA/HRMS) (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICACardinal Students (SA/HRMS) (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAEnterprise Performance Management

• Store legacy Student Administration system data

• Versioning difference issues:– Secure to un-secure site messages– Drill down connectivity– Consistent connectivity

• Create direct CREFs to specific components

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAEPM (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAEPM (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAEPM (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAEPM (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAMyHousing

• Third party residential self-service system• iScript functionality is used to create a single

signon environment• Additional HTTP referrer validation is done• Access is available only to students who can

participate in the lotteries or dining plans

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAMyHousing (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAMyHousing (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAMyHousing (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICADegree Audit System

• Custom built system tracking degree progress

• Developed using ASP • iScript functionality is used • Additional HTTP referrer validation is done• Access is available only to active students

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICADegree Audit System (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICADegree Audit System (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAJudicial Affairs Management

• Administrates and tracks student infractions • Custom-built using ColdFusion• Integrated with Enterprise Portal, Student System,

and Housing Director• Authentication by iScript functionality • Additional HTTP referrer validation is done• Access is available only to authorized users

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAJudicial Affairs Management (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAJudicial Affairs Management (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAJudicial Affairs Management (cont’d)

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAOther Applications

• Co-curricular Transcripts• CollegeNET Online Payments• Chickering Student Health Insurance• Future

– PeopleSoft Financials system– Learning Management system– E-mail– University Development– One-Card system– Bookstore – Data Warehouse

Center for Planning and Information TechnologyTHE CATHOLIC UNIVERSITY of AMERICAPoints of Contact

• Live Demo and Questions

• Jim Gallamo (gallamo@cua.edu)• Sonya Hughes (hughess@cua.edu)