Justin Lokitz & Delia Stevens Government, Education & Healthcare Oracle Corporation

How to Cut Costs with OracleAS and Integration Platform Higher Education Justin Lokitz & Delia Stevens Government, Education & Healthcare Oracle Corporation

Agenda • Introduction: Why Integrate? • OracleAS Overview • OracleAS Integration and Reporting Technologies • OracleAS InterConnect and ProcessConnect • OracleAS Portal • Oracle Data Warehousing • Oracle Business Intelligence and Reporting • Summary

Key Information Management Challenges in the “Web era” • Difficult to access and find information • Applications and content from multiple, disparate sources • If you don’t know where to look, how do you find it? • Personalization/dynamic content doesn’t scale • All sites and applications are different • Different logons • Different UI’s, different organization • Content is quickly out-of-date or inaccurate • Content owners do not have ability to publish • Difficult to manage the technology • Infrastructure is very fragmented and expensive • Myriad of isolated extranets and intranets • Regulatory and industry pressures – RN, HL7, AS2

OracleAS 9i/10gComplete, Therefore Simple Forms Java OWB BI Portal Reports

OracleAS 9i/10g Management &Security e-Business Integration Portals J2EE, & Web Services BusinessIntelligence Wireless Performance & Caching

OracleAS 10g InterConnect & ProcessConnect Overview

InterConnect (Connect Applications) & ProcessConnect (Connect Business Processes) Out of the box adapters for connectivity to disparate information sources that includes databases, legacy, and packaged applications (ERP, CRM, etc). Point and click data mapping tools for translations, transformation and validation. Visual Business Process Management tool for defining, coordinating and monitoring enterprise processes. Business Activity Monitoring via features that include logging, auditing, and reporting. Integrated Trading Partner Management for managing partner profiles and agreements. A scalable deployment architecture that is easily configured for departmental, regional, or enterprise-wide deployment on a variety of configurations. OracleAS Integration

Oracle Integration Spectrum Level of Abstraction Analyst ProcessConnect InterConnect Developer J2EE Model Centric WS InterConnect – Message Broker WS – Web Services J2EE – Java 2 Platform EE AQ – Advanced Queuing MG – Messaging Gateway TG – Transparent Gateway RPL – Oracle Replication DBA MG AQ TG Code Centric RPL Integration Complexity Database Centric

AppsDatabase OracleAS Integration Platform InterConnect & ProcessConnect Workflow Non-OracleAdapters OracleApplicationAdapters OracleE-Business Suite BusinessProcessManagement SAP R/3 ApplicationAdapters XML Gateway XML/AQAdapter SemanticTransformation LegacyApps MessageGateways OAG XML / AQ Messaging Oracle DBAdapter Other SDK OracleAS Triggers / SPs

Visual Design Environment: iStudio • Import • Define • Map • Deploy

Supported Endpoints and Adapter Development Kit • Applications • Oracle 11.5.X • Oracle 10.7 • SAP • Peoplesoft • JD Edwards • Siebel • Tuxedo • Any J2C Application • B2B Protocols • RosettaNet • EDI • HL7 • Web Services (SOAP, WSDL, UDDI) • Databases • Oracle7.3, 8.0, 8i, 9i • MS SQL-Server • IBM DB/2 UDB • Sybase • Informix • JDBC • Messaging • Oracle AQ • MQ-Series • JMS • Transports • HTTP, HTTP/S • SMTP • FTP, FTP/S • AS/2 • Legacy • CICS • DB2 • IMS • VSAM • 3270/5250 Screen Scraping

OracleAS 10g Portal Overview

Oracle Portal:The Great Integrator • A self-service web publishing and content management solution - 100 % in the Browser • Integrate and Secure Online Content and Applications without re-writing • Build, maintain and deploy Dynamic web sites • Integrated with the Database and Identity Management System (LDAP) -Create and manage users with customized content • Single Sign-On

Summarize/Access External Data Sources

Example: my.oracle.com • Free, high quality business portal • Target : 1.5 million OTN members • Customizable pages, by industry and geography • Integrate Oracle and 3rd party content and services • Oracle employee’s home page • Target : 40,000 Oracle employees worldwide • Single sign on to all self service applications • Aggregate view, and access point, to all intranet content

Student View Faculty/Staff View Create a Single Starting Point, with Multiple Views …. Alumni View Community View

Open & Extensible to Any Application • Extend Java friendly applications • Servlet, JSP, EJB, XML, Web Services • Proxy URL accessible applications • C++, CGI, ASP, HTML • Transform ERP/CRM data • SAP, PeopleSoft, Siebel, SCT Banner, BlackBoard, WebCT • Access 3rd party partner applications • 100+ partners, 1000+ portlets • Business intelligence, content management, collaboration, search, syndicated content

Oracle10g Warehouse Builder Overview

Why a Data Warehouse?

Data Mining The Oracle “Butterfly” Slide Student & Financial Analyzers... Operational Data Reports Oracle10g Warehouse Builder Application Server ERPData Discoverer OLAP Oracle9i/10g External Data BI Beans Common Warehouse Metadata

Oracle Warehouse Builder What is Oracle Warehouse Builder? A GUI business intelligence integration and design tool that manages the full life-cycle of data and metadata for the Oracle Database.

Design Target Objects 1 Map & Transform 3 Generate & Validate 4 Extract Source Metadata Deploy Code 2 5 Run 6 Design and Deploy • Oracle9i/10g • OLAP • Flat file • AQ • BI tools • Relational • Flat Files • Applications • Mainframe

Oracle Warehouse Builder: Summary • Warehouse Builder is an Open, complete, Integrated, and affordable tool to build, deploy and manage BI applications • Leverages performance and scalability of the Oracle9i database • Provides lifecycle and deployment managers • Provides complete services for metadata management and reporting

OracleAS 10g BI and Reporting Overview

OracleAS Discoverer:Easy to Use Ad Hoc Reporting Tool • One Click Operations • Wizard Driven • Tutorials • Reduced Learning Curve • Drag & Drop Layout • Interactive Dialogs

SELECT CHANNELS, SALES FROM SH.SALES WHERE CHANNEL=‘Direct’ OR CHANNEL=‘Indirect’ Business View of Database InformationHiding the complexity Database User’s View

Self Service Query over the Web Drag & Drop Scheduling Web Access

Drill Everywhere DRILL DOWN DRILL OUT External Data

Monthly Sales Report West East West East Total _____ East West • OracleAS Reports: • Enterprise Report Distribution and Bursting • Multiple Sections with: • Different Layouts • Different Distribution • Email • Printer • File • Web • Different recipients • Different Output Formats • Bitmap, HTML, HTMLCSS, PDF, ASCII, RTF, XML, delimited

OracleAS Integration Key Messages Enables users to better locate, understand, manage & take action on critical information • Provides integrated, secure access to all information sources • Supports personalized views configured for multiple user communities • Delivers self service tools for empowering users to manage and report on data

Upcoming Related Oracle Technology Events • Campus License Overview Internet Seminar • Thursday, March 4th • High Availability and Disaster Recovery in HE- Maximum Availability Architecture • Thursday, March 11th • Integration and the Application Server in Higher Education • Tuesday, March 16th • Empower your decision-making process by tapping into your SCT Banner data • Thursday, March 18th • Working Effectively With Support • Thursday, March 18th – I:00 PM EST • Higher Education Portal & Content Management using Oracle 10g Solutions • Tuesday, March 23rd • All events held at 1:00pm Pacific, 3:00pm Central, 4:00pm Eastern • For complete event description and to register go to: http://cyber.oracle.com

Justin Lokitz & Delia Stevens Government, Education & Healthcare Oracle Corporation