Automate

1. Banner® Automate with Mark Romeo Sr. System Engineer mromeo@appworx.com AppWorx Corporation

2. Agenda • Who is AppWorx? • AppWorx Value. • AppWorx SCT Banner Solution • Architecture.

3. Who is AppWorx Corporation? • Enterprise Scheduling and Application Automation Solutions Leader • SCT certified Product Solution • Founded in 1990 • HQ in Bellevue, WA • 500+ customers worldwide • 100+ SCT / Banner customers

4. AppWorx - SCT Customers George Washington University San Diego State Wayne State University William and Mary Montana State University University Of Chicago Kennesaw State University Georgia State Lansing Community College University of Maryland University of Illinois Ft Lewis College University of Texas, San Antonio Dartmouth University Eastern Michigan University Rensselaer Polytech Institute McGill University Western Washington University

5. Customer Quote “We were searching for a single job scheduler that could manage batch processes associated with existing distributed applications and integrate with our new SCT Banner solution. We determined that the AppWorx solution provided us everything we needed to achieve our long-term goals and still be able to grow and add new applications within our IT environment." Mary Ellen Gaughan, Director Ops Support Svcs. University of Illinois

6. Customer Quote "AppWorx has allowed us to empower our users by putting control of job automation, output viewing, printing and downloading directly into their hands. Its ease of use allows directors and clerical personnel alike to take control of their processes. In a large part, this is due to the sophistication of the error checking that we are able to build into the deployed processes. We have come to depend on it to simplify our jobs." Mark SullivanAssociate Director of Integrated Admin Computing Solutions Rensselaer Polytechnic Institute

7. AppWorx Value Proposition Through application automation and efficient workload balancing, the AppWorx scheduling solution will significantly reduce your IT operating expenses and greatly improve your IT operating efficiencies. Like most customers, you will see an immediate ROI within 3 months after going “live” with AppWorx. It’s more than just a scheduler………………..

8. How AppWorx adds Value • AppWorx Enterprise Scheduler automates and integrates SCT Banner application processing. • Schedules SCT Banner processes. • Control and monitor SCT Banner processes. • Enables event-based conditional logic. • Reduce processing time and errors by eliminating manual job submissions. • Simplify output management and distribution of SCT Banner reports. • Integrate SCT Banner with the enterprise.

9. Run every WEEKDAY but not on HOLIDAYS { Banner 1 SQR 2 Start these jobs when Job 1 finishes but only run two at a time Crystal 3 Banner 4 Start after operator responds “Yes” to “Are the tapes ready for backup?” Banner 6 Start after file is created Job 8 JOB 8 JOB 8 JOB 8 JOB 8 Schedule SCT Banner Processes Banner Job 5 Start when Tape 1 is available Banner Job 7

10. Manage SCT Processes • Manages dependent SCT Banner jobs. • Subsequent processes can be blocked if the preceding job does not complete successfully • Ensures the appropriate job submission order of SCT Banner jobs • Eliminates the need to rerun SCT Banner jobs • Easily create complex dependencies and job threading to ensure successful completion of a job before execution of the next

11. Submit and Monitor SCT Banner Processes SCT Banner Banner Business Process Step 1 Step 2 Step 3 Step 4 Step 5 Banner jobs submitted by AppWorx are viewable from the Banner Application. . Jobs submitted in the Banner Interface are viewable from AppWorx.

12. SCT Job Management • AppWorx provides the ability to capture “on-line” SCT Banner jobs submitted via Job Submission • Data center can better control the batch workload generation by the SCT Banner application • Shortens production cycle by efficient use of computing resources • Eliminates resource utilization spikes • Assists IT in meeting application performance

13. Manage SCT Banner Processes SCT Banner Submitted Banner Processes Ban 1 Ban 2 Ban 3 Ban 4 Ban 5 AppWorx On-line captures Banner submitted jobs. AppWorx Queues control total number of job executing and priority of execution. Queue A Queue B Queue C Ban 1 Ban 3 Ban 6 Ban 2 Ban 4 Ban 5

14. SCT Output Management • View SCT Banner reports & logs online • Print SCT Banner reports & logs to single or multiple printers automatically • FTP, rename, and/or email SCT Banner output files • Distribute SCT Banner reports & logs electronically • Full Integration with SCT ePrint application and the Ability to Automatically Transfer Output files to the ePrint Server • Full Integration with EVisions Form-Fusion and IntelliCheck

15. AppWorx Streamlines SCT Banner Job Flow Improving Overall Performance

16. AppWorx / Banner Solutions • Transcript Generation • Individual Request • Batch Processing • Admission Application Fees Requirement • Letter Generation • Students • Alumni • Government Financial Aid File Processing • Payroll Check Processing • Student Billing

17. SCT Banner Enterprise Integration

18. Enterprise Architecture

19. Chains and Modules