1 / 36

Integrating Disparate Systems to Support the Online Campus

Integrating Disparate Systems to Support the Online Campus. Becky King Baylor University. Baylor University is…. Located in Waco, Texas The oldest institution of higher learning in the state, founded in 1845 Affiliated with the Baptist General Convention of Texas

kaden
Download Presentation

Integrating Disparate Systems to Support the Online Campus

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrating Disparate Systems to Support the Online Campus Becky King Baylor University

  2. Baylor University is… • Located in Waco, Texas • The oldest institution of higher learning in the state, founded in 1845 • Affiliated with the Baptist General Convention of Texas • The largest Baptist University in the world Integrating Disparate Systems to Support the Online Campus

  3. The Mission of the University To educate men and women for worldwide leadership and service by integrating academic excellence and Christian commitment with a caring community. Integrating Disparate Systems to Support the Online Campus

  4. Other Baylor Info: • 13,719 students in Fall 2000 • Emphasis on undergraduate education • Highly ranked Law School • George W. Truett Seminary • 1,700+ fulltime faculty and staff • Only private school in Big 12 athletic conference Integrating Disparate Systems to Support the Online Campus

  5. Campus Technology Organization Integrating Disparate Systems to Support the Online Campus

  6. Changes in Progress • Windows 2000 implementation • IIS Web server • Internet Explorer browser • Outlook mail client • Exchange e-mail & calendaring system • SQL Server departmental databases Integrating Disparate Systems to Support the Online Campus

  7. In other words… Microsoft! Integrating Disparate Systems to Support the Online Campus

  8. Other Campus IT Stuff • Wired dorms • AirBear • Computer labs • Internet filtering • Student kiosks • Technology classrooms Integrating Disparate Systems to Support the Online Campus

  9. Baylor Information Systems • IBM OS/390, DB2 • AIX, Oracle • COBOL, C, SQL • Crystal Reports, FOCUS • SCT, PeopleSoft, Diebold, Paciolan, Noel-Levitz, etc. • Web services Integrating Disparate Systems to Support the Online Campus

  10. Anarchy is the stepping stone to absolute power. - Napoleon I Integrating Disparate Systems to Support the Online Campus

  11. Our solution… Integrating Disparate Systems to Support the Online Campus

  12. A Little History • Late 1980’s needed online directory • VSAM SIS on IBM mainframe • Homegrown CODASYL HRS on Honeywell • Had to have data from both • Created COBOL extract/load programs • Loaded indexed file in VMS on VAX • New campus ID card system Integrating Disparate Systems to Support the Online Campus

  13. More History • 1991 conversion to Rdb Person Database • Administrative Information Systems upgraded & converted • Person Database enhanced as needed • Person Database converted from Rdb to Oracle Integrating Disparate Systems to Support the Online Campus

  14. The Database • Oracle 7.3.4 (soon 8.1.6) • AIX Unix on 8-way RS/6000 J50 • Shares server with SCT Banner HRS & ADS • Stores these categories of data: • Personal info • Class enrollment info • Validation/rule info • Authorization info for faculty evaluation & advisement data access Integrating Disparate Systems to Support the Online Campus

  15. Database Processing • Nightly updates 5:30 p.m. – 7:00 a.m. • From SIS (SCT Plus2000, DB2) • From Housing (Homegrown, DB2) • From HRS (SCT Banner, Oracle) • From ID System (Diebold ICAM, RMS) Integrating Disparate Systems to Support the Online Campus

  16. Database Processing(continued) • Nightly updates 5:30 p.m. – 7:00 a.m. • To E-mail System • To Library System • To Student Life Center System • To ID System • To LDAP files • To Kerberos • To other stuff Integrating Disparate Systems to Support the Online Campus

  17. Integrating Disparate Systems to Support the Online Campus

  18. Time for a break? Integrating Disparate Systems to Support the Online Campus

  19. When a new “person” added: • Nine digit PID created • Network ID (Bear ID) created • Initial settings for ID System determined • Initial settings for directory information release flags established… Integrating Disparate Systems to Support the Online Campus

  20. Directory Information Release Flags Maintained for these data items: Name Salutation Suffix E-mail Dorm address Dorm phone Local address Local phone Perm address Perm phone Classification Major Office address Office phone Home address Home phone Employee type Job/Position Web homepage Picture Integrating Disparate Systems to Support the Online Campus

  21. Values for Information Release Flags: • N - No Access • B - Baylor business (employee) access only • C - Campus (employee & student) access only • I - Open Internet access Integrating Disparate Systems to Support the Online Campus

  22. Integrating Disparate Systems to Support the Online Campus

  23. Also when Person Database updated: • Person’s changing role with the University updated… • Admittee • Student • Faculty • Staff • Auxiliary personnel • Special (exception) • Alumni (planned for future) Integrating Disparate Systems to Support the Online Campus

  24. Class Info by Term • Includes all critical data fields (bldg, room, time, instructor(s), max, etc.) • Supports printed & Web class schedules • Enrollments loaded daily, or twice daily • Supports Web applications Integrating Disparate Systems to Support the Online Campus

  25. OK, tell me more. Integrating Disparate Systems to Support the Online Campus

  26. The Person Database is centralized point of creation of a unique network ID. This Bear ID is username for… • e-mail • calendaring • most Web applications • network access Integrating Disparate Systems to Support the Online Campus

  27. Nightly files from Person Database flow to: LabLog E-mail Kerberos (e-mail) Kerberos (fac/staff dial-in) Library System Student Life Center System ID System Mainframe authorization database LDAP (e-mail) LDAP (authentication) Integrating Disparate Systems to Support the Online Campus

  28. Regular and ad hoc batch jobs run from the Person Database. Integrating Disparate Systems to Support the Online Campus

  29. Web Applications Supported • Web Directory • Web White Pages • Information Release • Resnet Signup • E-mail Forwarding • BearAdvice • Chapel Attendance Integrating Disparate Systems to Support the Online Campus

  30. Web Apps (continued) • Electronic Forms • IT Seminars • Web for Employees • Set PIN • Faculty Evaluations • Course Listings • Electronic Grade Submission • PL/SQL routines Integrating Disparate Systems to Support the Online Campus

  31. The Future? Integrating Disparate Systems to Support the Online Campus

  32. Plans Include… • Extension of network IDs to alumni • Active Directory support • Additional e-business & Web applications • “My Baylor” student portal • Conversion of Student Information System Integrating Disparate Systems to Support the Online Campus

  33. Staff resources dedicated to the Integrating Disparate Systems to Support the Online Campus

  34. Biggest Day-to-Day Issues • Coordination & timing of jobs & file transfers • ID changes in SIS & HRS • New critical field values • Term rollover coordination • Research of questions Integrating Disparate Systems to Support the Online Campus

  35. students staff faculty parents donors alumni prospects contractors retirees Integrating Disparate Systems to Support the Online Campus

  36. Integrating Disparate Systems to Support the Online Campus Becky King Baylor University

More Related