Transcript Student Information System Technology Migration

Student Information System
Technology Migration
Goals
Background
Position MIT so that we can strategically evaluate the
long term direction of the Student Information System.
•Establish management processes to support
migrated applications
•Minimize impact to the overall user community
•Refresh SSIT systems with a supportable platform
with clear upgrade paths
3
4/26/2020
Major Deliverables
Background
• Project Management and Coordination
– Processes and documentation
– Trained staff
• Infrastructure/Administration
–
–
–
–
Hardware platforms up to date
Server Software up to date
Support processes in place
Clear upgrade paths
• Application/Software Development
– Tested and approved software
– Applications on new hardware and software platforms
4
4/26/2020
Why?
Background
• Oracle, Hyperion, Weblogic, and other 3rd Party Vendors no
longer supporting versions of software
– Database (MITSIS Data)
– Forms
– Reports (SQR)
• System reliability increasingly at risk
• Access to MITSIS cumbersome
• Future enhancements are increasingly difficult to
implement
5
4/26/2020
Benefits
Background
• Aligned with vendor support of software and hardware with
upgrade paths
• System reliability maximized
– Parts more available
– Engineers readily available
• Easier access to interfaces
– All web based
– Integrated with J2EE and Websis applications
• More flexible for future enhancements
– Possibilities completely open
– No barriers with database
6
4/26/2020
Criticality to MIT
Background
• Core System for Student Information
–
–
–
–
–
–
–
Biographic information
Registration
Financial information
Loans processing
Housing
Dining
Many more ….
• System reliability and integrity crucial
– Loss of system for prolonged time damaging
• Getting information processed
• Ensuring smooth operation of academic experience
– Perception of a technological institute
7
4/26/2020
Quick Overview
Background
Why
Sponsor
Major Systems
Users
Admissions
Undergraduate Recruitment
Graduate Admissions
MIT Applicants, Admissions,
Educational Counselors, Academic
Departments
Registrar; Academic Services
Student Record, Registration, Degree
Audit, Catalog, Scheduling (students,
classrooms, exams), Advising,
Commencement, Tuition Assessment,
Communications Req.
Students, Faculty, Academic
Departments, Advisors,
Housemasters, Registrar’s Office,
Academic Services, Alumni, World
Student Life
Housing, Dining, Medical, Athletics,
Student Activities
Students, Housing, Dining, Medical,
Athletics
Financial Services
Student Accounts, Federal Work Study,
Financial Aid
Students, Student Financial Services
Provost
Graduate Aid
Provost’s Office, Academic
Departments
SSIT FTE 25
Systems: MITSIS, WebSIS, Other
include ~ 60+ applications
Technologies: UNIX, VAX/VMS, C,
Cobol, Java, Perl, SQR, Oracle
databases (7.3 and 9), Oracle Forms,
PowerBuilder, Web, J2EE
Users: ~15,000 faculty, students, staff;
~30,000 potential applicants
8
4/26/2020
Major SIS Modules
Background
•
–
–
–
–
•
•
•
Scheduling
Class Scheduling
Classroom Scheduling and
Management
Final Exam Scheduling
Event Management
•
Student Subjects
Degree Maintenance
–
Degree Audit – Grad and UG
–
Enrollment and Degree Certification
–
Graduation, Diplomas
Miscellaneous
–
Transcript Requests
–
Grade Processing
–
Housing
–
Registration
–
Dining
–
Student Enrollment Maintenance
–
Medical
–
Subject Maintenance
–
Admissions
–
Tuition
–
–
Academic and Biographic Record
Advisor Assignment
Financial Services
–
–
–
Loans
Student Accounts
Financial Aid
9
4/26/2020
Changes to User Experience
Changes to User Experience
• MITSIS Forms
– User Interfaces
• Interfaces will be browser enabled
– No more Host Explorer
– No more Citrix
• Different color schemes than text based interfaces
• Datafeeds and Batch Processes
–
–
–
–
New server names
Manual batch processes on new operating systems
File transfer mechanisms (Kermit)
Reviewing and editing files
10
4/26/2020
Changes to User Experience
Changes to User Experience
• Business Logic
– All business logic maintained
– Upgrade as quickly as possible, then re-assess
• Navigation
– Current keyboard use will be maintained
– End up trading frustrations
11
4/26/2020
Current Forms Look
Changes to User Experience
12
4/26/2020
New Forms Look
Changes to User Experience
Changes to User Experience
13
4/26/2020
Websis
Changes to User Experience
Look and Feel Not Changing
14
4/26/2020
Project Framework
Project Approach
Using IS&T Project Framework
Where we are
15
4/26/2020
Project Leaders Team
(Analysis and Design)
Project Approach
Sponsors: Jerry Grochow VP Information Services & Technology
Mary Callahan Registrar
Betsy Hicks Executive Director, Student Financial Services
Process/Project Management
Sub-Project
Phoebe Minias
Support &
Training
MITSIS
Migration
Leo Larson
Joanne Stevenson
Project
Infrastructure/
Administration
Infrastructure
Dan Hart
Application Development
Database
Data Feeds
Websis
Raisa Budman
Shawn Dunn
Andrea Collins
COM/DCL
Pro*c,SQR
Diane Belford
Current J2EE
Olu Brown
16
Powerbuilder
Leo Larson
Misc. User
Access
Andrea Collins
Forms
Migration
Roles
Diane Belford
Roberta Crumrine
4/26/2020
Project Structure
(Development, Integration, and Test)
Project Approach
Sponsors: Jerry Grochow VP Information Services & Technology
Mary Callahan Registrar
Betsy Hicks Executive Director, Student Financial Services
Project Management and Coordination
Phoebe Minias
Infrastructure/
Administration
Infrastructure
Dan Hart
Database
SIS Tech
Migration
Support and
Training
Joanne Stevenson
Leo Larson
Application/Software Development
Schedules
Admissions
Financial
ARC
Registrar
Catalog Dev
Student Load
Donor Relat.
Subfund Proc
Fund Mgmnt
PowerFaids
AP Tests
Acad. Advis.
UROP
IAP
DataFeeds
Eligibility
Pre Reg.
Holds
Raisa Budman
Schedules
Stud. Loans
Datafeeds
User Representatives
Peter Hayes
Rick Rosa
Testing Leaders
Andrea Collins
Leo Larson
Diane Belford
Olu Brown
Gregory Che
Neeta Purohit
Shawn Dunn
Janet Sahlstrom
Misc.
Student Bio
Acad. Record
Student Addr
Sys Control
Special
Projects
Exp.Subject
Advisor Mess
Fifth Week
FEE
Registration
Tuit Assmnt
Term Info
Grading
Degree Audit
End of Term
External
Rept.
Datafeeds
Grad Admiss
Final Exams
Student
Accounts
Acct Setup
Tbraccd Updt
Disbursement
Stud. Billing
DataFeeds
Michael Bergren
Leo Larson
Olu Brown
Graduate Aid
ISO
Athletics
General
HouseMaster
Peter Hayes
Gregory Che
Neeta Purohit
Peter Hayes
Anna Frazer
Andrea Collins
Diane Belford
Shawn Dunn
Janet Sahlstrom
Andrea Collins
Diane Belford
Leo Larson
Olu Brown
17
Housing
Dining
Medical
Janet Fischer
Alison Knot
Dennis Collins
Alicia Hunt
Robin Smedick
James Walsh
Mark Reagan
Daniel Michaud
Carol Elder
Leo Larson
Olu Brown
Shawn Dunn
Janet Sahlstrom
4/26/2020
Initiate
Prepare
Execute and Control
Analyze
Close
Develop
Desktops
Release
Mgmt
Design
QA Checkpoint
Develop
Servers
Integrate
Development
Project Team Control
Project Team Control
Servers
UA-Test
Integration
Release/Inf Control
UA-Test
Servers
Release/Inf Control
User Acceptance
Release
Mgmt
Release
Mgmt
Test Cases
Bug Tracking
Test Plan
QA Checkpoint
Release
Mgmt
Project Team Control
Release
Mgmt
Integrate
Test Cases
Bug Tracking
Development Plan
QA Checkpoint
Production
Release/Inf Control
QA Checkpoint
Current High Level Systems
Major Components
Websis
MITSIS Forms &
Batch Processes
Netscape Commerce Server
CGI-Bin, Shell Scripts, SQR 4.3
MITSIS Data
Federal Work Study
MITID
Grade 20
Powerbuilder
Test Scores,
Degree Tracking
Reg. Control List
SISTIM Etc.
Oracle 7.3.4
Forms 3.0,
VMS COM/DCL,
SQR 4.3
J2EE Weblogic
Power User
Tools
19
File Feeds
TestScores,HASS,
Medical…
50 Known Feeds
4/26/2020
Current Software Used
Major Components
•
546 VMS Com/DCL (Job Execution)
•
873 SQR Version 4.3 (Reporting and programming tool)
–
–
•
Latest version - Hyperion 9
Includes WEBSIS and VMS versions
70 Forms Version 3.0 (User Interfaces to MITSIS)
–
Latest version - Forms10g
•
100 Pro*c, Pro*cobol programs (Code in 3GL Legacy programs)
•
2805 Database objects Oracle 7.3.4
–
Latest Oracle Database 10g
•
3 Powerbuilder 5.4
•
18 J2EE applications (Java Web applications
–
Weblogic 6,7,8 (Current application server)
20
4/26/2020
Future High Level Systems
Major Components
Elements in blue represent changes to current state
No major changes to Powerbuilder (FWS,Grade20,MITID)
Websis
Oracle Apache
CGI-Bin, Shell Scripts, SQR 8
MITSIS Forms &
Batch Processes
MITSIS Data
Forms 10g, Shell
Scripts,
SQR 8
Oracle 10g AS
Forms Services
Federal Work Study
MITID
Grade 20
Powerbuilder
Test Scores,
Degree Tracking
Reg. Control List
SISTIM Etc.
Oracle 10g
J2EE Oracle 10g AS
File Feeds
TestScores,HASS,
Medical…
50 Known Feeds
Power User
Tools
21
4/26/2020
Current Architecture
Architecture
Application
users
MITNET
SD
CONSOLE
WIC 0 OK
FDX 100 LNK
DSU
CPU
S3
LP
OK
B2
B1
LOOP
BRI
S/T
AUX
WIC 1 OK
Cisco 1720
Skyweb
solaris
Weblogic server
webgradaid/sistem
email &
some encrpted
printing
Mitsis
VMS Alphaserver
front end server
Banner
Oracle Forms
com/dcl/pro-c/pro-cobol/
sqr
Axplor
tru64
Dropbox
Fleagle
Tru64 Alphaserver
used as telnet server
to frontend VMS server
Mitsts
skydrop
solaris
dropbox
MitVMC
VM
PrintServer
misc printing and
data feeds
Forkball
Windows NT
PrintServer
encrypted printing
Student
Tru64 Alphaserver
Websis webserver
Running Netscape
Sisdb
Tru64 Alphaserver
Database Server
Oracle
FDDI Ring
sisjajp
Tru64 Alpha
MIT Confidential
22
4/26/2020
Future Architecture
Architecture
Netra
10 t1
Sun
FAN
STATUS
5
1
2
Firesafe
SSIT CVS Server
Code Repository
Sky-gate-1
F5 Big-IP
Load balancer
3
x8
Catalyst 3970
1X
11X
13X
23X
2X
12X
14X
24X
Catalyst 3970
S ER IE S
SYST
RPS
1X
11X
13X
23X
2X
12X
14X
24X
S ER IE S
SYST
RPS
STAT
STAT
DUPLX
SPEED
MODE
Sky-gate-2
F5 Big-IP
Load balancer
x8
DUPLX
SPEED
MODE
p5
p5
Sky-app-1
Oracle Application Server
High Availability Cluster
Sky-app-2
Oracle Application Server
High Availability Cluster
Linux OS:
Forms Services
HTTP Server
Oracle J2EE Container
Sky-chart
Production Oracle
Application Server
Infrastructure Database
Components
SSO etc...
SunFire V1280
Sun
SunFire V880
sky-vault-2
Production Database Sever
Oracle 10g
Sun
23
4/26/2020
Technologies Used
Architecture
•
Oracle Application Server Release 2
– Oracle Forms Services
• SIS Forms
– Oracle HTTP Server
• Apache foundation
• WEBSIS
– Oracle Containers For Java
• J2EE Applications
•
Oracle Database 10g
•
Hyperion SQR
•
X.509 certificates with Oracle Infrastructure
– Single Sign on
– All technologies use single sign on
24
4/26/2020
Major Challenges
•
Code Migration
–
–
–
–
Forms
Pro*C
Pro*Cobol
COM/DCL
• To Linux Bourne shell
•
Batch processing
•
X.509 Certificates
•
Output from reports and logs
25
4/26/2020
Code Migration
Major Challenges
Challenge: Code written in old versions of software
To many programs to convert without help
•
3rd party vendor offshore
•
Conversion Tools
– Forms 3.0 to Forms 10g
– Pro*C to latest version
– Pro*COBOL to latest version
•
COM/DCL conversion to Linux Bourne
– VMS Commands in Linux
• Finding issues
• Creating workarounds
26
4/26/2020
Code Migration (Cont.)
Major Challenges
•
SQR Deprecated features
– In house with SSIT staff
– Most taken care of by conversion scripts
– Minimal manually changes
•
Programs in user accounts
– Migrate in house with SSIT staff
– SQR can be converted with minimal changes
– All COM/DCL converted to Linux Bourne
• Used as training and familiarization with technology
• Establish development and release plans
27
4/26/2020
Batch Processing
Major Challenges
Challenge: All code currently executed as VMS user
Code logs onto database as operating system user
•
New platform runs on Oracle Application Server
– Operating system user will be the same user who started
application server
– User rights not setup correctly
– Don’t want Oracle account executing user programs
•
LDAP Server used
– Log into server as user
– Execute code as LDAP user
– Keep database and file system access based on operating system
user
– Setup OS environment as if user logged in directly
28
4/26/2020
X.509 Certificates
Major Challenges
Challenge: How will users use MIT certificates
• Oracle Single Sign On
– Uses Oracle Application Server Infrastructure
• Built into product suite
• Map x.509 certificate to Oracle database account
•
All components under single sign on
•
•
•
•
•
WEBSIS
MITSIS
J2EE
Request certificates once
Netscape Commerce server (WEBSIS)
– Problems with new certificates
– Needed to modify to handle changes
29
4/26/2020
Output from Reports and Logs
Major Challenges
Challenge: How to troubleshoot problems in environment
Application servers load balance
Where to look for output
•
Shared directories between application servers
•
One area to put all output
– Reports
– Data files
– Logs
30
4/26/2020
MITSIS Migration
Questions?
http://earth-app-1.mit.edu:7778/forms/frmservlet?form=GUAINIT
31
4/26/2020