1 / 34

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

lpouliot
Download Presentation

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

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. How to Cut Costs with OracleAS and Integration Platform Higher Education Justin Lokitz & Delia Stevens Government, Education & Healthcare Oracle Corporation

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

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

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

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

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

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

  8. OracleAS 10g InterConnect & ProcessConnect Overview

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

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

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

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

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

  14. OracleAS 10g Portal Overview

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

  16. Summarize/Access External Data Sources

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

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

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

  20. Oracle10g Warehouse Builder Overview

  21. Why a Data Warehouse?

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

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

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

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

  26. OracleAS 10g BI and Reporting Overview

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

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

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

  30. Drill Everywhere DRILL DOWN DRILL OUT External Data

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

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

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

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

More Related