Iowa State University Ames, Iowa Enrollment: 26,800 Public Land Grant University

1. Using WebSphere, Java and COBOL to Implement a Business Application Iowa State University Ames, Iowa Enrollment: 26,800 Public Land Grant University Larry Newhouse Information Systems Leader Iowa State University ADP Center 2nd Floor ASB Ames, IA 50011 (515) 294-8290 (515) 294-0290 (Fax) ldnewho@iastate.edu Andy Terry Systems Analyst II Iowa State University ADP Center 2nd Floor ASB Ames, IA 50011 (515) 294-8053 (515) 294-0290 (Fax) aterry@iastate.edu Iowa State University - ADP Center

2. Major Points • ISU and the ADP Center • Architecture Goals • Existing & New Architectural Model • Trials and Tribulations • Demo Iowa State University - ADP Center

3. ISU Statistics Established 1858 - 1st Land-Grant College • Fall 2000 Enrollment 26,800 • Total Faculty & Staff 6,200 • Number of Colleges 9 • 00-01 Revenues 690,000,000 • Campus Acres 2,000 Iowa State University - ADP Center

4. ADP Center Staff - 82 P&S, 14 Merit, 25 students Support - 43 Networks, 2730 PCs 120,000,000 records 10,000 programs Process daily: 250,000 On-line transaction 300 Batch jobs 100 Help Center Calls Iowa State University - ADP Center

5. I know how to code JSP’s, EJB’s, Servlets, and/or XML. • I lead/play key role in web development efforts. • I have some clue – want to learn more. Audience Quiz Iowa State University - ADP Center

6. Architecture/Technology Goals • Hardware independence • OS/390, Unix, Wintel(NT) • Access to data at its source • Application code on appropriate platform • Leverage/reuse … • Staff experience • Existing business logic • ADP Strategic directions Iowa State University - ADP Center

7. Architecture • Data Access / Application Model • Next Generation Criteria • New Model Iowa State University - ADP Center

8. NT 100+ Clients TN3270 1800+ clients UNIX 30,000+ clients Data Access Model Iowa State University - ADP Center

9. Web Applications • Financial Aid • Award Offer, Status, E-award, Loan History, Job Board • Registrar • Class Registration, Schedule, Transcript, General Info • Resident Hall & Dining Services • Contract, Room & Roommate Signup, Select Dining Service Options • University Bill • Advisee Information • Voting • Address Change • Benefits Sign-up Iowa State University - ADP Center

10. Web Information Requests • Delivered content is escalating each fiscal year Iowa State University - ADP Center

11. Architecture/Project Initiative • ‘Web’ System Development • Legacy System • Personal Web • Business Web • Interface with other legacy application processes • Upgrade Existing Legacy System • Mainframe terminal & Web support • Use / Integrate with Existing Web Architecture Iowa State University - ADP Center

12. Next Generation Platform Criteria • Who/where are the clients • Maintain transactional integrity • Interface requirements • Strengths: • staff • application systems • standards • vendor relationships • Training • Desktop requirements Iowa State University - ADP Center

13. Mindsets • Staff Mindset • Analyst • Designer • Client • Application Mindset • TN3270 Business Applications • Web ‘Request/View’ Applications • Web ‘Business’ Applications Iowa State University - ADP Center

14. Where do all the pieces fit? Object-Oriented Design (OO) Java Database Connectivity (JDBC) Java Beans Java Applets Java Server Pages (JSP’s) Java Servlets Enterprise Java Beans (EJB’s) CICS/COBOL Iowa State University - ADP Center

15. Iowa State University - ADP Center

16. The decisions were made! • WebServer: • WebSphere Application Server • Desktop • VisualAge for Java & WebSphere Studio • HomeSite/FrontPage 2000 • Business logic on the central system • Upgrade desktops as needed • Identify/develop training • Enhance support areas • Servers, desktop software, help desk, client Iowa State University - ADP Center

17. Architecture Model Iowa State University - ADP Center

18. Model Impact Areas • ADP Center • ADP Staff • Administrative Clients Iowa State University - ADP Center

19. Impact-ADP Center-Standards • History of Standards at the ADP Center • Balancing – Resources / Requirements • Application Environments • Procedural Processes • Source Control Iowa State University - ADP Center

20. Impact-ADP Center-Security • How to integrate with existing security on central system • Access to CICS programs. • Access to CICS systems. • Access to functions within CICS systems. • How to integrate with security process used in existing web model Iowa State University - ADP Center

21. Impact-Staff-Strengths • Assessed Strengths • Analytical / Business Logic • Integrated TN3270 Applications • Cobol / CICS / DB2 / ODBC • Complex Batch Processes • Host Centric • Editors, Debugging and control processes • “Additional” Skill Sets Required • Graphic Designers • Component / Object designers • Languages • Toolsets Iowa State University - ADP Center

22. Impact-Staff-Growth • Object Design • Legacy Mindset • Legacy/Web system integration • Refreshing Skills Iowa State University - ADP Center

23. Impact-Staff-Wizards • Why use code generators? • Pre-defined standards • Rapid application development • Shorter learning curve for staff • History of in-house developed code generators and standards • Our code generator • Input COBOL copybook • Generates XML or RecordBean • Generates JSP • Publishes generated code to work area. Iowa State University - ADP Center

24. Wizards – JSP/XML/Record Bean Generator Iowa State University - ADP Center

25. Wizards – JSP Code Iowa State University - ADP Center

26. Impact-Staff-Testing & Debugging • Server / Model • Site / Activity Analyzer • Bottlenecks in model • “The Pounder” (site stress testing tool) • Application • Understanding debugging points • End to end debugging Iowa State University - ADP Center

27. Architecture Model Iowa State University - ADP Center

28. Impact-Client • History with clients • Long-term • Positive • Committed • History of Initiative • Requisitioning design phase • Director’s retreat initiative Iowa State University - ADP Center

29. Impact-Client • Expectations • Functionality • More intuitive, more options, more access • Costs • Lower Iowa State University - ADP Center

30. Impact-Client • Outcome • Functionality • More intuitive, more options, more access • Costs • Not lower Iowa State University - ADP Center

31. Results • Success! • Positive • Satisfied • Excited Iowa State University - ADP Center

32. Today • What we learned • Complex • Commitment • Standardization • Modularization • Flexible Iowa State University - ADP Center

33. Future • What’s next? • Continue learning • Expand staff training • Add Web applications • Personalize Web experience • Include Wireless Technology Iowa State University - ADP Center

34. Application Demonstration Iowa State University - ADP Center

35. Application Demonstration Iowa State University - ADP Center

36. Application Demonstration Access Plus Navigation Key Fields Data Entry Reference Menu Iowa State University - ADP Center

37. Application Demonstration Iowa State University - ADP Center

38. Application Demonstration Iowa State University - ADP Center

39. Application Demonstration Iowa State University - ADP Center

40. DEMONSTRATION Iowa State University - ADP Center

41. Questions? Iowa State University - ADP Center