My Cal Poly

1

• My Cal Poly
• uPortal Channel Technologies

Chris StavrosWeb Strategist
Ken SperowApplication Developer
California Polytechnic State University San
Luis Obispo, CA
2
Cal Poly WebInfrastructure Goals

• Provide easier, more intuitive access to
  university applications and services (user
  benefit)
• Facilitate rapid application development and
  provide centralized developer resources
  (developer benefit)
• Build an infrastructure that guarantees the
  accuracy, availability and extensibility of
  disparate university data (everyone benefits)
• Establish a Web application infrastructure to
  guarantee interoperability and extensibility of
  future applications (everyone benefits)

3
(No Transcript)
4
(No Transcript)
5
Student Account Transactions Provides students
an up-to-date statement (24/7) of their account
for the currently active term. Uses a type 4
JDBC driver (HiT JDBC/DB2 v2.6) to read data
directly out of the Student Information System
(SIS) (DB2 on an IBM mainframe). Fast with
minimal impact on the mainframe Required some
configuration (TCP port/ enable DDF listener) on
the mainframe and granting user certain
privileges (CREATE IN COLLECTION, BINDADD) Db2
tables can be locked in off hours code catches
exception and reads data from the campus data
warehouse (updated nightly)
6
Personal Information Personal Information
channel was part of a larger project to make
username_at_calpoly a viable e-mail address for
conducting all University business. SIS address
different than address in LDAP (no
synchronization) Two versions of channel.
7
Personal Information The first channel allows
students to view and change physical addresses
(local, permanent, diploma mailing, and billing)
and students/faculty/staff to update e-mail
addresses. The second channel allows the
campus Help Desk to change e-mail addresses (they
did not want the ability to change physical
addresses). Batch Updates used to update SIS
(No relational integrity constraints in
DB) Used Oracle packages to limit access to DB
tables.
8
(No Transcript)
9
(No Transcript)
10

• Questions?

California Polytechnic State University San
Luis Obispo, CA