Transcript PPT - SUNY Technology Conference

XE, SQR AND JAVA OH MY!
WHAT WE KNOW, DON’T KNOW AND WHAT WE WILL
JUST PLAIN LIE ABOUT!
STC 2016 SESSION 1622
SICAS CENTER
BILL GRAU, EXECUTIVE DIRECTOR
WILL WEIR, CHIEF TECHNOLOGY OFFICER
PETE ANDRUSYSZYN, CHIEF COOK AND BOTTLE WASHER
NATE TROST, SOFTWARE ARCHITECT
SICAS UPDATE
• Staff
•
•
32 currently
•
21 in Oneonta
•
11 at other SUNY sites
2 searches for 3 people in motion
• Training
• On Demand Subscription Library
• Service Now
•
We need your help
• Budget
• Ellucian Contract
SICAS UPDATE
CURRENT PROJECTS
• Financial Literacy Initiative
• NYC Electronic Transcripts
• Enhancements to FA Certification
• Enhancements to FA Good Academic Standing Application
• DW/SOT Integration with Ellucian Course Program of Study
• Converting SQR’s
• Moving retirement reporting to new form
• TRS Part Time reporting changes
• Auto refunding Enhancements
SICAS UPDATE
DELIVERED ENHANCEMENTS
• Student Outcome Tracking (SOT) for Degree Works
• NYS Standardized FA Award Info Sheet
• FA Remittance Advice Reconciliation– Phase 2
• Prior- Prior FA Processing
• Additional SUNY HR feedback file columns
• Multiple updates to SIRIS processes
• ASC Pipe Delimited file load
SICAS UPDATE
RELEASE SCHEDULE
• Finaid 8.26S1
June 2016 DELIVERED
• ARSYS 8.5S1
Aug. 2016 Dependent on Auto Refunding beta
• General 8.8S2
Aug. 2016
• Student 8.10S1
Aug. 2016
• Stuweb 8.7S2
Aug. 2016
• Finance 8.5S1
Sept. 2016
THE POWER OF SICAS
• 38 different applications currently available
• 4 Specifically for Community Colleges
• 5 Specifically for State Operated Campuses
• 29 applicable to all campuses
• Developed once and distributed centrally to 44 campuses
SICAS REMOTE SERVICES
Currently 34 of the 44 SUNY campuses running banner also use SICAS remote
services for the installation of Banner upgrades. How come your campus is not?
If you subscribe to SICAS remote services we will:
•
Perform all Banner upgrade and patch installation
•
Provide assistance in the installation and/or configuration of the Banner
Application
•
Provide support to your technical team
•
Perform any appropriate after-clone work
•
Participate in bi-weekly conference calls
•
Provide documentation and expertise
Our team members have a built in redundancy. If your primary person is out sick,
we have someone backing them up, and someone backing up the back up.
SICAS SUMMIT 2016
• September 29-30
• Villa Roma Resort in Calicoon, NY
• Call for presentations is out
• Registration will open at the end of this month
• Bus transportation from Port Authority Terminal to front door
SQR
• Oracle has announced an end of support as of April 2018
• CCIO “Future Meeting”
•
Argos
•
Non Argos
SQR
SICAS DIRECTION
Step 1-Inventory your SQR’s to determine what function they perform
Why Java & PL/SQL
• PL/SQL - All process specific programming will be done in PL/SQL
•
SICAS already has a large code base in PL/SQL
•
As SQRs are converted we will add to our library of common PL/SQL functionality
•
Many of the SQRs to be converted rely heavily on PL/SQL
• Java – Any common processes (applicable to all reports) will be done in Java
•
All member campuses can use Java
•
New processes from Ellucian for INB forms are being written in Java (rather than
PRO*C, Groovy, etc)
SQR
SICAS DIRECTION
• Advantages
•
Maintainability
•
Ease of conversion
•
Builds on existing PL/SQL libraries
•
Skill base
• Disadvantages
•
Does not fully take advantage of new technologies
•
Does not significantly change or improve the reporting process
• Shell scripts
•
One new script for each converted process
SQR
SICAS DIRECTION
• PL/SQL packages
•
One new package for each converted process
• One Java program
•
Manage any processing that can be done in a default way for all jobs
•
This program will call the correct PL/SQL package for the job, print the output file,
write to the log file
•
If applicable, this program will open any input files and bring that data into the
database
•
Having only one program means less code to maintain and simplifies
packaging/shipping of report processes
SQR
SICAS DIRECTION
• Tables
•
GOTYREP – Global temporary table containing report lines for printing
•
GOTYPAM – Global temporary table containing all job parameters in a default
format
•
GORYLOD – Table containing any data loaded from an input file
XE
• Banner XE
• Transformed Banner
• Banner 9
• Webinars
•
http://www.ellucian.com/Events/Extra/Banner--by-Ellucian-raises-the-bar-forhigher-education/
WHAT IS AVAILABLE?
• Student Advisor Profile
• Attendance Tracking
• Faculty Grading
• Event Management
• Employee Profile
• Banner HR Position Description (Requires ESM)
• Banner HR Transformation 9.0 (these are the transformation of the HR INB
forms) (Requires ESM)
• Banner Finance Purchase requisition (Requires ESM)
• XE Registration for campuses not using SOT OR running SOT in batch mode
only
WHAT CAN YOU DO?
• Inventory your Banner modifications and add on applications
•
Retire what is no longer needed
•
Upload your code to the XE Guide website for a work assessment
• Apply the DBEU II upgrade
• Install SSO
• Sign up for the XE Registry on the Ellucian Hub
• Submit your mods to Ellucian for Evaluation
• Sign up for and frequently visit eCommunities
• Read
WHAT DO YOU NEED TO KNOW?
• Java
• Eclipse
• Groovy on Grails
• pl/sql
• SQR (JUST KIDDING)
XE ROADMAP
XE/TRANSFORMATION TOOLS
•
SICAS has source code from all released baseline Transformation applications and is
experimenting with the extensibility tools.
•
Currently the source code repository contains Solution Center modifications
complicating its use. These packages do provide samples of the java required to
implement extension triggers which is informative.
•
Documentation for setting up and using the Foundations and Frames plugins on Eclipse
to support extending Transformation Applications are incomplete and at times
inaccurate which makes using the tools somewhat frustrating.
•
Currently the documentation only supports use of a VM which requires very powerful
PCs configurations. SICAS is working with the native PC Eclipse setup using additional
notes from the Ellucian development team. This setup performs well on reasonable
PCs. Ellucian is working on improved documentation and it will include the Native
Eclipse setup option.
•
Installation of the Transformation Applications for local use requires ESM which does not
yet support the SICAS modifications. SICAS built extensions could not currently be
shipped even if they are built.
XE PAGEBUILDER
•
Initial release of PageBuilder will be limited to creating new Self-Service Pages; not
modifying baseline pages.
•
PageBuilder hints at baseline extensibility features (Extends field on Page Composer).
•
PageBuilder runs in a browser; you basically build new pages in Self-Service.
•
Tools include Domain Composer (including Domain Roles), CSS Manager for styling and
Visual Page Composer (including Page Roles)
•
Page Composer builds your page in a Page Tree View; also provides Source Code and
Visual Preview options. Not drag and drop but it looks like a very productive
environment.
XE PAGEBUILDER
•
Page Composer also provides a Component Property View for setting labels, style and
events like “On Load”, “On Save” and “On Error”.
•
Wide variety of components available including Editable Grids providing more powerful
interfaces than our current Self-Service pages support.
•
Pages supporting Search and Result Filtering can be built using this tool. All without
significant programming.
•
Available in June 2016
ENTERPRISE SERVICE MANAGER (ESM)
• Used to Download/Install Releases/Patches
•
optionally can be used to provision Banner servers
• Required for Java Forms releases
• Working with Ellucian on a Consortium Model
•
will be needed for processing SICAS Releases/Patches
•
SICAS Master server will provide SICAS releases and SICAS modified Ellucian
releases
•
un-modified baseline releases will download from Ellucian
ENTERPRISE SERVICE MANAGER (ESM)
• Each Campus will have an ESM Server
•
configure instances
•
server queries SICAS ESM
•
software will download from SICAS or Ellucian(if baseline)
•
install software
•
dependencies will be checked and installed if appropriate
ENTERPRISE SERVICE MANAGER (ESM)
•
QUESTIONS?
CONTACT INFORMATION
• Don’t call us, we’ll call you.
• Oh wait, no we won’t. 
CONTACT INFORMATION
• [email protected]
• [email protected]
• [email protected]
• [email protected]