DBA BOF Allison Levin Temple University Maureen Castaldi

DBA BOF Allison Levin, Temple University Maureen Castaldi, The University of Scranton

Temple University • Founded in 1884 • Located in the heart of Philadelphia • 38 th largest university in the U. S. • 5 th largest provider of professional education in the nation • 17 schools and colleges • 9 campuses including Rome and Tokyo The University of Scranton • Founded in 1888 • Catholic and Jesuit identity • Northeastern PA • 3800 full-time undergrad

Scranton Ellucian Environment Overview • Long standing customer – Banner 1. 3 – 1989/1990 go live • Banner Admin – all modules - 6 pages transformed, we do not maintain code or extend the Banner Pages • Banner 8 SS (SSOManager) • Banner 9 Student SS • Banner 9 Employee SS (planned 3/20) and Student Registration (planned 12/19) • Luminis 5. 4, Imaging, Banner Workflow, Mobile, e. Transcripts • Degree. Works (Implementation phase) • Many add-on in-house developed applications (sql, pl/sql, php, . net, sharepoint) • Argos, Power. BI • 3 rd party integrations: Slate CRM, Nelnet, Alumni. Q, Symplicity (Residence, Advocate) • Oracle 12 c. R 2: DB and Banner 8 SS Middleware • Tomcat: Banner 9, Workflow, BEIS SSOManager • JAMs – Job Scheduler

Temple Ellucian Environment Overview • • • Banner client since 2008 Banner Admin – all modules - 18 pages transformed of which 9 are custom forms Banner 8 SS (SSOManager) Banner 9 Self. Service (with quite a few in house mods) • Went live with Banner 9 Employee SSB & Student SSB June 2018 • Went live with Faculty Grading and Student Registration June 2019 • Opened for priority reg Nov 2019 Luminis 5. 4, Imaging, Banner Workflow, Mobile, e. Transcripts, CRM Recruit, BRM, ODS/EDW with Cognos • Upgrade to CRM Recruit 5. 3 scheduled for Dec 2019 u. Achieve (DARS) Many add-on in-house developed applications (sql, pl/sql, php, . net, sharepoint) Many 3 rd party integrations Oracle 12 c. R 2: DB and Banner 8 SS Middleware Currently weblogic shop – looking to move to Tomcat and/or Kubernetes UC 4 Job Scheduler

Scranton Current Initiatives • Identity and Access Management • Current: custom scripts for account management with CAS/ADFS and DUO authentication • Future: use baseline features, BEIS to replace current scripts, EIS with ADFS • Reduce Banner Access • Past: Let’s give access to everything that may be needed • Current: Evaluate what has been used using security audit tables • Reduce in-house custom code and local modifications • Current: Evaluate need and usage of custom code and local modifications • Prepare for Cloud • Data Analytics and Reporting • Current: ARGOS Reporting Tool against “live” tables and data marts • Future: ARGOS and Power. BI with additional data marts, data warehouse • Student Centered Focus • Banner 9 SS Registration – Soft Launch December 2019 • Degree. Works - Implementation Phase, Go-Live Fall 2020 • Compliance Focus • Time. Clock Plus – Implementation Spring 2020 (includes Banner Event Publisher installation) • Moving ahead • Banner 8 SSB to ORDS to Tomcat • Banner 9 SS Employee Profile – Implementation Spring 2020

Temple Current Initiatives • Banner Access • Reviewing/Exploring the new BAM – Banner Access Management • In out test environment • Reduce in-house custom code and local modifications • Extensibility being tested • Moving ahead • Hoping to avoid Banner 8 SSB to ORDS to Tomcat • Is Banner 8 SSB really going away June 2020? • Moving all Banner to Tomcat/Kubernetes - Spring 2020 • Upgrading to Oracle 18 – Spring/Summer 2020

Areas of Concern • Security Alerts: • Oracle Quarterly and one-off Releases; Increasing high vulnerabilities for weblogic. • Ellucian Alerts; • Application Security • Ellucian; Web sessions and cookies • In-house; Accunetix and Visual Code Grepper • Ellucian Communication • Support Matrix What version of what is supported with what? RH, Tomcat, JDK, ojdbc#. jar • Communication Channels – too many, what is official? • Data Integrations – Waiting and Watching • Slow adoption of Ethos by 3 rd party vendors • Banner Upgrades – When will Banner 8 go away? • Roadmaps • Portal • Mobile

Open to the Floor • Questions • Comments

Thank Your input matters! Please submit a session evaluation. PABUG Mobile App Session Browser http: //pabug. venudeskapp. com/sessionlist/? 2019 PABUG For CPE credits, visit our website: http: //pabug. org/events/cpe-credits/