How to Cut Costs with
OracleAS and
Integration Platform
Higher Education
Justin Lokitz & Delia Stevens
Government, Education & Healthcare
Oracle Corporation
Agenda
y Introduction: Why Integrate?
y OracleAS Overview
y OracleAS Integration and Reporting Technologies
–
–
–
–
OracleAS InterConnect and ProcessConnect
OracleAS Portal
Oracle Data Warehousing
Oracle Business Intelligence and Reporting
y Summary
Key Information Management
Challenges in the “Web era”
y 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
y All sites and applications are different
–
–
Different logons
Different UI’s, different organization
y Content is quickly out-of-date or inaccurate
–
Content owners do not have ability to publish
y Difficult to manage the technology
–
–
Infrastructure is very fragmented and expensive
Myriad of isolated extranets and intranets
y Regulatory and industry pressures – RN, HL7, AS2
Solution: Campus Integration
Technologies
y OracleAS Integration
–
The most flexible and cost-effective way to manage
enterprise business processes.
y OracleAS Portal
–
A common, integrated starting point for personalized
access to enterprise information.
y Oracle Warehouse Builder
–
Enterprise business intelligence integration design tool
that manages the full life-cycle of data and metadata
for the Oracle 10g Database.
y Oracle BI and Reports
–
Ad Hoc and Enterprise Reporting tools to get the most
out of your Campus Data.
Agenda
y Introduction: Why Integrate?
y OracleAS Overview
y OracleAS Integration and Reporting Technologies
–
–
–
–
OracleAS InterConnect and ProcessConnect
OracleAS Portal
Oracle Data Warehousing
Oracle Business Intelligence and Reporting
y Summary
OracleAS 9i/10g
Complete, Therefore Simple
Java
Forms
OWB
BI
Reports
Portal
OracleAS 9i/10g
Management &
Security
e-Business
Integration
Portals
J2EE, &
Web Services
Business
Intelligence
Wireless
Performance &
Caching
Agenda
y Introduction: Why Integrate?
y OracleAS Overview
y OracleAS Integration and Reporting Technologies
–
–
–
–
OracleAS InterConnect and ProcessConnect
OracleAS Portal
Oracle Data Warehousing
Oracle Business Intelligence and Reporting
y Summary
OracleAS 10g
InterConnect &
ProcessConnect
Overview
OracleAS Integration
y 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.
Oracle Integration Spectrum
Level of
Abstraction Analyst
ProcessConnect
InterConnect
Developer
J2EE
Model Centric
WS
DBA
MG
AQ
TG
Code Centric
RPL
Database Centric
InterConnect – Message Broker
WS
– Web Services
J2EE
– Java 2 Platform EE
AQ
– Advanced Queuing
MG
– Messaging Gateway
TG
– Transparent Gateway
RPL
– Oracle Replication
Integration
Complexity
OracleAS Integration Platform
InterConnect &
ProcessConnect Workflow
Oracle
E-Business Suite
Oracle
Application
Adapters
XML Gateway
XML/AQ
Adapter
Business
Process
Management
Semantic
Transformation
OAG XML / AQ
Apps
Database
Oracle DB
Adapter
Triggers / SPs
Non-Oracle
Adapters
Application
Adapters
SAP R/3
Message
Gateways
Legacy
Apps
SDK
Other
Messaging
OracleAS
Visual Design Environment: iStudio
•
•
•
•
Import
Define
Map
Deploy
Supported Endpoints and
Adapter Development Kit
Applications
y Oracle 11.5.X
y Oracle 10.7
y SAP
y Peoplesoft
y JD Edwards
y Siebel
y Tuxedo
y Any J2C Application
B2B Protocols
y
y
y
y
RosettaNet
EDI
HL7
Web Services (SOAP,
WSDL, UDDI)
Databases
y Oracle7.3, 8.0, 8i, 9i
y MS SQL-Server
y IBM DB/2 UDB
y Sybase
y Informix
y JDBC
Messaging
y Oracle AQ
y MQ-Series
y JMS
Transports
y
y
y
y
HTTP, HTTP/S
SMTP
FTP, FTP/S
AS/2
Legacy
y CICS
y DB2
y IMS
y VSAM
y 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
y 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
y 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
Create a Single Starting Point, with
Multiple Views ….
Faculty/Staff View
Student View
Alumni View
Community View
Open & Extensible to Any Application
y Extend Java friendly applications
–
Servlet, JSP, EJB, XML, Web Services
y Proxy URL accessible applications
–
C++, CGI, ASP, HTML
y Transform ERP/CRM data
–
SAP, PeopleSoft, Siebel, SCT Banner, BlackBoard,
WebCT
y 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?
The Oracle “Butterfly” Slide
Student
Student &
& Financial
Financial Analyzers...
Analyzers...
Operational
Operational
Data
Data
ERP
ERP
Data
Data
Reports
Reports
Warehouse
Warehouse
Builder
Builder
OLAP
OLAP
External
External
Data
Data
Oracle10g
Application
Application
Server
Server
Data
Data Mining
Mining
Discoverer
Discoverer
Oracle9i/10g
Oracle9i/10g
BI
BI Beans
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 and Deploy
1
Design Target Objects
3
Map & Transform
4
2
•
•
•
•
5
Extract Source
Metadata
Relational
Flat Files
Applications
Mainframe
Generate & Validate
6
Run
Deploy Code
•
•
•
•
•
Oracle9i/10g
OLAP
Flat file
AQ
BI tools
Oracle Warehouse Builder:
Summary
y Warehouse Builder is an Open, complete,
Integrated, and affordable tool to build,
deploy and manage BI applications
y Leverages performance and scalability of
the Oracle9i database
y Provides lifecycle and deployment
managers
y 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
Business View of Database Information
Hiding the complexity
Database
SELECT CHANNELS,
SALES FROM
SH.SALES
WHERE
CHANNEL=‘Direct’
OR
CHANNEL=‘Indirect’
User’s View
Self Service Query over the Web
Drag & Drop
Scheduling
Web Access
Drill Everywhere
DRILL DOWN
DRILL OUT
External
Data
OracleAS Reports:
Enterprise Report Distribution and Bursting
y Multiple Sections with:
–
–
–
–
Different Layouts
Different Distribution
y Email
y Printer
y File
y Web
Different recipients
Different Output Formats
y Bitmap, HTML,
HTMLCSS, PDF, ASCII,
RTF, XML, delimited
Monthly Sales Report
West East West
Total _____
East
West
East
Agenda
y Introduction: Why Integrate?
y OracleAS Overview
y OracleAS Integration and Reporting Technologies
–
–
–
–
OracleAS InterConnect and ProcessConnect
OracleAS Portal
Oracle Data Warehousing
Oracle Business Intelligence and Reporting
y Summary
OracleAS Integration Key Messages
Enables users to better locate, understand,
manage & take action on critical information
y Provides integrated, secure access to all
information sources
y Supports personalized views configured for
multiple user communities
y Delivers self service tools for empowering
users to manage and report on data
Upcoming Related Oracle Technology Events
y Campus License Overview Internet Seminar
–
Thursday, March 4th
y High Availability and Disaster Recovery in HE- Maximum Availability
Architecture
–
Thursday, March 11th
y Integration and the Application Server in Higher Education
–
Tuesday, March 16th
y Empower your decision-making process by tapping into your SCT Banner
data
–
Thursday, March 18th
y Working Effectively With Support
–
Thursday, March 18th – I:00 PM EST
y Higher Education Portal & Content Management using Oracle 10g Solutions
–
y
y
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