300 likes | 583 Views
Enterprise Schedule. Using Appworx to Orchestrate Banner, ODS and Cognos scheduling Shaun H. Cooper NMSU. Outline . ERP support systems at NMSU Process Scheduling tasks Appworx Banner Processing ODS Processing Cognos Process Conclusions. ERP Support Systems at NMSU. SUNGARDHE Banner
E N D
Enterprise Schedule Using Appworx to Orchestrate Banner, ODS and Cognos scheduling Shaun H. Cooper NMSU NM TIE 2007
Outline • ERP support systems at NMSU • Process Scheduling tasks • Appworx • Banner Processing • ODS Processing • Cognos Process • Conclusions NM TIE 2007
ERP Support Systems at NMSU • SUNGARDHE Banner • HR (Jan 2005) • Finance (July 2005) • Admissions (Sept 2006) • Student/AR (Nov 2006) • Financial Aid (March 2007) • SUNGARDHE • Workflow • Extender • ODS • Eprint • Cognos NM TIE 2007
Process Scheduling Tasks • Finance • Run month end close • Set of “massaged” reports • Daily • Load daily feeds from external systems • HR • Daily loads of “positive pay” NM TIE 2007
Process Schedule Tasks (cont) • Financial Aid • Daily financial aid disbursement and feeds • Student • Daily summary data for Business Intelligence • Weekly runs of “advising docs” for entire campus NM TIE 2007
Appworx NM TIE 2007
Appworx • Enterprise Scheduling Application • UNIX • Windows • Others • Agent based application where master agent sends requests to slave agents to perform work on “local” host. NM TIE 2007
Appworx Agent Process X Master Agent Please Run Process X Updates on Process X Standard Output Standard Error NM TIE 2007
AppworxAgents NM TIE 2007
Appworx BacklogWhat is running NM TIE 2007
Appworx State InformationRuntime, dependencies and output NM TIE 2007
Appworx Output filesStandard Out (SQL too) NM TIE 2007
Appworx – Example output file NM TIE 2007
Appworx ModulesBaseline work elements NM TIE 2007
Appworx Module Details NM TIE 2007
Appworx ChainsPutting Modules Together NM TIE 2007
Finance Month End Close Banner Reports NM TIE 2007
Appworx +Banner + UNIX = Success! • Appworx orchestrates the steps to run a sequence of elements • Banner writes baseline reports • UNIX scripts allow for postprocessing of elements • UNIX places output file on eprint! NM TIE 2007
FIN_FGRBDSC_PARSE_EPRINT NM TIE 2007
UNIX scripts used to postprocess NM TIE 2007
Postprocessing with PERL NM TIE 2007
Finished output of FGRBDSC in Eprint NM TIE 2007
Appworx Engages Dependencies • ODS requires refresh and then freeze events • ODS scheduler has no dependencies • What happens when a refresh runs beyond the time a freeze occurs? NM TIE 2007
ODS Web Tailor Job Scheduler NM TIE 2007
Finance Month End with ODS NM TIE 2007
Appworx Benefits • One Corporate Scheduling System • Maintains dependencies for dependent systems. • Has a sophisticated calendar system • Program university calendar and holidays • Has sophisticated prompts • Using SQL determine first day of semester • No more hand edit of many processes needing current semester. NM TIE 2007
Appworx Benefits • Chain prompts pass down • One prompt change is all that is needed NM TIE 2007
Appworx and Cognos • Can run cognos reports via Cognos SDK and save to local windows server • Appworx is used to transport PDF file to UNIX • UNIX is used to convert to Text • Appworx transports text to eprint • Eprint indexes form for quicker use for end customer NM TIE 2007
New Appworx Initiatives • Cognos Cube refresh run after ODS refresh. • HR Payroll processing NM TIE 2007
Conclusions • Appworx is used to orchestrate a number of processes spread across disparate systems (and operating systems) • Appworx provides a consolidated view of all scheduled jobs • Appworx WORKS! NM TIE 2007