1	AcademicEdge Build a comprehensive information system using best-in-class software for colleges and universities. Siba Mohanty, Ph.D.
2	Colleges & Universities Diverse student population Intellectual staff Multiple regulatory requirements Non-Profit Status Limited budget
3	Colleges & Universities Use home grown or multiple third-party software systems to teach, administer and manage their institution Have complex system integration requirements
4	Buy, Make or Integrate? For Enterprise Applications and Data, the Question Is Not Make versus Buy … because, while we can do both, we really need to be good at “assemble” if we’re to own our own application and data destinies. Bob Weir & Rick Mickool VP & Exec. Dir. Information Services Northeastern University EDUCAUSE Quarterly, (Number 1, 2003)
5	Buy: Pros & Cons One-stop shopping “…implicit assumption that solution vendors have every thing you need. This is rare in industry and impossible in higher education given the diversity of needs & institutions.” Forced release migration
6	Make: Pros vs. Cons Making provides ultimate in control Investment Discipline Support
7	Assemble: Ideal middle ground – buy some and integrate
8	Northeastern University 50,000 customers PeopleSoft, SCT, CA, College Board, home grown legacy apps DB2, Oracle, SQL Server, IDMS IBM, Sun, Compaq servers 11 terabytes of data
9	Univ. of California "Buy versus build" is a decision that campus computing officials face each time they must upgrade any component of their administrative-computing systems. "It's a constant thing," and "nothing is pure buy-or-build anymore" John W. McCredie, associate vice chancellor for information technology. Univ. of California, Berkeley
10	Yale University Yale … never had great confidence in E.R.P. vendors who promised "a unified, soup-to-nuts system" for higher education. The university has stuck to a strategy of buying and integrating what it considers to be "the best of breed" business software. Mr. Daniel Updegrove, CIO
11	Independent Systems
12	Independent Systems
13	Independent Systems
14	Installed Independent Systems MIP (Fund Accounting) – 100 Best (Fund Raising) – 150 Blackbaud (Institutional Advancement) – 300 Power FAIDS (Financial Aid/college Board) - 500 Recruitment PLUS (Recruitment/College Board) – 150 SAFE (Financial Aid) – 250 Grate Plains (Accounting/HR/Payroll) – 100
15	Installed Integrated Systems SunGard SCT (Banner, SIS, ABT Campus) – 2000 Jenzabar (CARS, Quodata, Campus America, CMDS) – 700 Datatel – 600 PeopleSoft – 400 BiTech – 100 Oracle SAP DAG (mostly in Canada)
16	Student & Faculty Requirements Learning Tools/Technology for student & faculty On-line student services/functions Application, registration, course catalog grade reports, financial aid reports Student/staff/faculty collaboration
17	Institutional Business Requirements General Ledger Bank Reconciliation Fixed Asset Management Payable/Receivables Management Purchase Order Processing Human Resources Payroll Grants Management Fund Accounting Project Accounting Financial Statements Financial Reporting Secured, web access to business information
18	AcademicEdge^® SIS AcademicEdge SIS has the required functionalities It can integrate with third party software systems Java/J2EE Technology Infrastructure is used for deployment & integration
19	AcademicEdge SIS A comprehensive student information systems that includes: Recruitment Admission Registration Financial Aid Bursar/Business Office Alumni Housing, Mentoring
20	AcademicEdge Functions
21	AcademicEdge Functions
22	Sample Screen Shots The following screen shots are example of current templates in the system. All existing templates will be used as a basis for customizing your application.
23	Application – Personal data
24	Application – Educational data
25	Application – Employment history
26	Application - Degree
27	Application – Prior degree attempts
28	Application – Transfer credit
29	Financial Aid information
30	Import Financial aid data from EDExpress
31	Financial aid award report
32	AcademicEdge SIS A J2EE IDE is used to design/customize AcademicEdge system The system is deployed in industry standard J2EE environment The system can be developed individually or as an integrated unit
33	AcademicEdge Java/J2EE Deployment Requires: Java Runtime Environment Web Application Server Relational Database Server LDAP Directory Server
34	Web Application Server Handle mapping requests to specific servlet instances, accommodate html and JSP pages for static & dynamic content.
35	Relational Database Server Required to store XML documents and field values. Users can choose any of the following: Oracle Database Server MySQL Server IBM DB2 Server
36	Web Application Server choices The system can be deployed in any of the following Application Servers Oracle Application Server 10g JBoss IBM WebSphere
37	Choice of Application Servers, Data bases AcademicEdge SIS can be deployed in Oracle Application Server/Oracle DBMS The system can be deployed in JBoss Application Server and MySQL DBMS Other combinations of Application Servers/DBMS are feasible.
38	AcademicEdge SIS on open source infrastructure We can deploy AcademicEdge on available open source infrastructure. A possible deployment configuration: Linux operating system JBoss Application Server MySQL database
39	AcademicEdge Java/J2EE SIS Deployed application will have same (or similar) user interface as shown in various images at this web site. The Forms can be opened in a browser, filled out, submitted and the results are displayed in the browser. Admission, Registration, financial aid, bursar, COD, Alumni functions are all performed over the web using a browser.
40	AcademicEdge Web Services Certain services of AcademicEdge can be exposed as Web Services so that other applications can access those services using appropriate methods. Lets us take a quick tour of Web Services and related technologies.
41	Typical Web Services Scenario An application sends a request to a service at a given URL using the SOAP protocol over HTTP. The service receives the request, processes it, and returns a response.
42	XML and Java in Web Services XML is used for data representation Java is used for processing logic.
43	J2EE Platform for Web Services For enterprises, Web Services need to be scalable, Secure and efficient. Java 2 Enterprise Edition (J2EE) is especially designed to meet these requirements.
44	XML XML is an industry-standard, system-independent way of representing data. XML encloses data in tags, that relate to the meaning of the enclosed text. An example: Mocha Java 11.95
45	XML Schema Describes the structure of a XML document. For the previous example, XML schema specifies the location of coffee name, coffee price and their attributes. Any XML document that follows the constraints established in a schema is said to conform to that schema.
46	JAX - RPC Java API for XML – Remote Procedure Call (JAX-RPC) is a collection of procedures that can be called by a remote client over the Internet. A typical RPC uses SOAP (Simple Object Access Protocol) to request a service (e.g, student grade) and the result is returned via SOAP.
47	Creating Web Service using RPC The service requires interface definition -- that declares service’s remote procedures and implementation class -- that implements those procedures.
48	Web Service Example For an University book store, some available services are: Public getBookPrice (String Author) Public orderBook (String Author, int quantity) A student can get a price by using getBookPrice method and order books using orderBook method.
49	Accessing the Web Service via a browser A browser client application for a Web service has code that invokes the desired method to request a service and receives a response.
50	All services can be accessed as Web Services As discussed in previous example, all required services at an University or College can be made available as Web Services and accessed by others via a browser. Student services performed by AcademicEdge HR/Finance/Accounting services, and Services from other applications.
51	Web Portal is the gateway to all institutional services Increasingly, web portal is used as the self-service gateway to access all services provided by a college or an university. uPortal, open source, is designed to provide such services to higher education community.
52	uPortal Overview uPortal is a free, sharable portal under development by JA_SIG for institutions of higher-educations. (http://www.uportal.org) uPortal is an open-standard effort using Java, XML, JSP and J2EE. uPortal is a framework, consisting of a set of Java classes and XML/XSL documents that is used to produce a campus portal. Customization allows each user to define a unique and personal view of the campus Web.
53	uPortal Deployment & Customization Requires: Application Servers: JBoss, Oracle 10g, IBM WebSphere, … Relational Database Server LDAP Server for authentication
54	uPortal Student Web Site
55	uPortal Faculty Web Site
56	uPortal Staff Web Site
57	uPortal Content Integration Through uPortal Channels or Portlets Web application, which requires user interaction, would use a Channel or Portlet as its user interface to deliver content to the portal.
58	uPortal Developer Web Site – Channel Integration
59	uPortal @ Arizona State Univ.
60	uPortal @ Cal Poly
61	uPortal @ Columbia
62	uPortal @ Cornell
63	uPortal @ Roanoke College
64	uPortal @ Virginia Tech.
65	uPortal @ Yale Univ.
66	AcademicEdge Application Integration with uPortal AcademicEdge application services are J2EE applications These services can be easily integrated with uPortal Channels and Portlets to provide a unique, personalized view to the users – students, faculty, staff, parents and alumni.
67	uPortal and other Application Integration Other campus applications will have to be web enabled to integrate with uPortal Application vendors can provide the necessary services and support for this effort.
68	Our Strengths
69	Key Benefits Seamless integration with the Web Short implementation cycle Cost effective solution with high payoff Enables group collaboration Independent system modules Comprehensive system features Easy to customize, use and maintain.
70	Conclusion AcademicEdge is a comprehensive SIS Its technology infrastructure allows integration with best-in-class software It is web centric It is secure, affordable and scalable Contact – [email protected]