1 / 28

University of Toronto Turning Data into Information

University of Toronto Turning Data into Information. Dr. Eva Swenson, University of Toronto Terry Riopelle, Software AG Nov. 2001. The Business. Higher Education 5 th largest university in North America Multiple IS groups reporting to multiple VPs

alexandra
Download Presentation

University of Toronto Turning Data into Information

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. University of TorontoTurning Data into Information Dr. Eva Swenson, University of Toronto Terry Riopelle, Software AG Nov. 2001

  2. The Business Higher Education 5th largest university in North America Multiple IS groups reporting to multiple VPs Multiple heterogeneous platforms (OS/390, Windows, UNIX) BUSINESS NEED – 1 Automate cross-functional processes through information sharingacross functional systems BUSINESS NEED – 2 Deliver services directly to 54,000 students on multiple channels while allowing 1,000 administrative staff to perform registrarial functions

  3. SAP- Financial System SAP- Human Resources Research System Development System SAP- Sales & Distribution Work Order other legacy systems .. Student biographic info Admissions Registration Fees assessment Student accounts receivable Awards Academic audit Transcripts Convocation Background - The Applications ROSI AMS

  4. Background - The Technology AMS ROSI AIX on IBM SP2 MVS on mainframe DB2 ORACLE ABAP Natural Software AG application SAP applications WEB SAP (client server) 3270 terminal (non client server)

  5. Business Need - 1 Cross-Functional Processes

  6. Business Need - 1 (Cross-Functional Processes) Initial Cross-Functional Process Institution needs to know all about an individual Functional Systems involved SAP/HR: all about employees ROSI: all about students Challenges Maintain data consistency between functional systems Enable SAP/HR to ask ROSI to validate student status and enable ROSI to ask SAP/HR to validate employee status Technical Environment Natural / DB2 on OS/390 with SAP R/3 on Unix

  7. AMS ROSI Common Data • Personnel number • Student number Linking the Data

  8. Business Need - 2 Multiple Delivery Channels

  9. Business Need - 2 (Multiple Delivery Channels) Channels involved Administrative staff access ROSI through 3270 terminal emulationStudents access their personal record on ROSI through the Web and the telephone (IVR) Functional Systems involved ROSI: Student data Challenge Achieve efficiency by using only one set of ROSI interfaces to feed all three access channels Technical Environment Natural / DB2 on OS/390 with Apache on AIX Unix

  10. Multiple Channels 3270 Screens Web Telephone Student Staff

  11. The Futures • Provide even more information that is focused on individuals regardless of the data sources. • Continue to adapt the ROSI application to meet new vehicles/channels of delivery of information.

  12. The Integration Solutions

  13. Data Consistency Multi-step Process Composite Application Orchestrator (Integration Broker) Communication Broker (Message Oriented Middleware) E.g. SAP HR/ROSI Integration E.g. ROSI Student Self Service Integration Broker Message Oriented Middleware (MOM) Three Forms of Integration Business Need - 2 Multiple Delivery Channels Business Need - 1 Cross-Functional Processes

  14. Message Oriented Middleware Programming Non-programming Application integration Solution Synch & Asynch Desktop integration Platform integration Application integ. Platform dependencies Integration Broker Data Management Programming Total integration solution Synch & Asynch Information integration Platform independent Application independant Integration Brokers vs. Message Oriented Middleware Business Need - 2 Multiple Delivery Channels Business Need - 1 Cross-Functional Processes

  15. The Business Need - 1 Cross-Functional ProcessesSolution

  16. ROSI & SAP R/3 HR Enterprise Application Integration

  17. ROSI - SAP HR Integration

  18. What is involved? • The Process • Business objects are defined as messages • Messages are associated with an application • Integration is described as integration flows • Integration flows are associated with application integration • by defining processing, routing and delivery rules for messages

  19. Scenario 1 Integration Problem: • Currently when an end user of the ROSI student information adds or modifies employee number information in the ROSI financial information screen, no validation of the employee number occurs. ROSI end users would like the ability to validate the employee number given. Solution: • Allow end users from within ROSI the means to validate that the employee number provided exists and that the student is a current employee. This will be achieved by propagating the SAP HR desired data asynchronously to a ROSI DB2 table whenever new employee information is added, or whenever an existing employee’s information is updated in the SAP HR system, which affects the applicable course fee discounts.

  20. Scenario 1 Integration Flow

  21. Scenario 2 Integration Issue: • The scope of this business process is to automate this validation process such that when a student number is added or modified in the SAP HR system. Currently when a student number added no validation of the student number occurs. HR IS end users would like the ability to validate the student number given. Solution: • To automate this validation process such that when a student number is added or modified in the SAP HR system, EntireX Orchestrator will asynchronously validate the student number in ROSI. Validation results will be stored for auditing by HR personnel. For this validation process to occur, some transformation and filtering of data will be necessary.

  22. Scenario 2 Integration Flow

  23. The Business Need - 2 Multiple Delivery ChannelsSolution

  24. Multiple Channels Solution 3270 Screens Web Telephone Student Staff

  25. What is involved? • The Process • Type of communication model chosen (RPC, ACI, event, polling, etc…) • Interfaces requirements defined (inputs, outputs) • Logical Services created • Servers created which perform the various work requested by clients for the defined Services • Clients are created in the desired languages and ask the various Services to do work.

  26. Multiple Channels Solution - Web Presentation/Business Services Tier Data Services Tier EntireX Natural Natural Natural Broker Program Logical Services Web DB/2 Apache Web Server usingCGI Browser OS/390 Mainframe TCPIP AIX Apache Web Server Logical I Physical

  27. Multiple Channels Solution - IVR Periphonics Presentation/Business Services Tier IVR Natural Natural Natural OS/390 Mainframe TCPIP AIX Data Services Tier EntireX Logical Broker Program Logical Services DB/2 I Physical

  28. Questions?

More Related