Automate Banner®
with
Mark Romeo
Sr. System Engineer
mromeo@appworx.com
AppWorx Corporation
Agenda
Who is AppWorx?
AppWorx Value.
AppWorx SCT Banner Solution
Architecture.
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
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
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
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 Sullivan
Associate Director of Integrated Admin Computing Solutions
Rensselaer Polytechnic Institute
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………………..
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.
Schedule SCT Banner Processes
Run every WEEKDAY
Banner 1
but not on HOLIDAYS
{
Start these SQR 2
jobs when
Job 1 finishes Crystal 3
but only run
two at a time Banner 4
Start after operator responds “Yes”
Banner Job 5 to “Are the tapes ready for backup?”
Banner 6 Start when Tape 1 is available
Start after
file is
created Banner Job 7
Job 8 JOB 8 JOB 8 JOB 8 JOB 8
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
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.
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
Manage SCT Banner Processes
SCT Banner
Submitted Banner Processes
Ban 1 Ban 2 Ban 3 Ban 4 Ban 5
AppWorx On-line
captures Banner Queue A Queue B Queue C
submitted jobs. Ban 1 Ban 3 Ban 6
AppWorx Queues Ban 2 Ban 4
control total number
of job executing and Ban 5
priority of execution.
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
AppWorx Streamlines SCT Banner Job Flow
Improving Overall Performance
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
SCT Banner Enterprise Integration
Enterprise Architecture Help Desk
Systems Management
Printer Pager Fax EMAIL
SNMP
HP/ITO
Tivoli
Patrol
NetCool
UNIX UNIX
Production Development
AppWorx Master AppWorx Master
AppWorx Agent AppWorx Agent
Oracle Oracle
DataBase DataBase
AppWorx Client
Java
Command Line AppWorx AppWorx
Import Export
TCP/IP
AppWorx Agent AppWorx Agent UNIX
NT 4.0 Windows 2000 AppWorx Agent
FTP Server Reporting Server SCT Banner
Chains and Modules
Chain Header: GLDYV5
Scheduling:
Cyclical 2. FTP_GRANT 1. FTP_STUDENT Before Conditions:
On Demand Check File
Calendar 3. COMBINE_AR_PAY Check History
SQL Based Current Time
API Module Running
4. ABORT_MODULE
uvariable value
5. SCHED_DW_GL_LOAD 6. BANNER_FINAID
Dependencies:
Order During Conditions:
Time Since
Threading 1. SQL_LOADER 1. FA_DATE Request
Abort Blocking Run Time
Script 2. DW_TRANSFORM 2. RPEDISB
uvariable value
Elimination
After Conditions:
3. DW_LOAD 3. RPBDDRV Status
Return Code
uvariable value
Input Parameters: 4. RPELIST
E-MAIL, PAGE
Character, Date,
Number
7. FINAL_REPORT
List of database Output Management:
Print
values E-mail
8. CRYSTAL_REPORT
Referential list of Fax
values On-line viewing
uvariable