1 / 30

Enterprise Schedule

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

dana
Download Presentation

Enterprise Schedule

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Enterprise Schedule Using Appworx to Orchestrate Banner, ODS and Cognos scheduling Shaun H. Cooper NMSU NM TIE 2007

  2. Outline • ERP support systems at NMSU • Process Scheduling tasks • Appworx • Banner Processing • ODS Processing • Cognos Process • Conclusions NM TIE 2007

  3. 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

  4. 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

  5. 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

  6. Appworx NM TIE 2007

  7. 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

  8. Appworx Agent Process X Master Agent Please Run Process X Updates on Process X Standard Output Standard Error NM TIE 2007

  9. AppworxAgents NM TIE 2007

  10. Appworx BacklogWhat is running NM TIE 2007

  11. Appworx State InformationRuntime, dependencies and output NM TIE 2007

  12. Appworx Output filesStandard Out (SQL too) NM TIE 2007

  13. Appworx – Example output file NM TIE 2007

  14. Appworx ModulesBaseline work elements NM TIE 2007

  15. Appworx Module Details NM TIE 2007

  16. Appworx ChainsPutting Modules Together NM TIE 2007

  17. Finance Month End Close Banner Reports NM TIE 2007

  18. 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

  19. FIN_FGRBDSC_PARSE_EPRINT NM TIE 2007

  20. UNIX scripts used to postprocess NM TIE 2007

  21. Postprocessing with PERL NM TIE 2007

  22. Finished output of FGRBDSC in Eprint NM TIE 2007

  23. 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

  24. ODS Web Tailor Job Scheduler NM TIE 2007

  25. Finance Month End with ODS NM TIE 2007

  26. 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

  27. Appworx Benefits • Chain prompts pass down • One prompt change is all that is needed NM TIE 2007

  28. 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

  29. New Appworx Initiatives • Cognos Cube refresh run after ODS refresh. • HR Payroll processing NM TIE 2007

  30. 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

More Related