Transcript Building Enterprise Information Portal using Oracle Portal

Building Enterprise
Information Portal using
Oracle Portal 3.0
Rizwan Akhtar
703-568-3702
[email protected]
What will we cover today ?






Portal Products
Oracle Portal Architecture
Portlets
Database Applications,Content Area,
Page
Demo Database Portlets
Portal Administration Features
Internet Portals



If you are going to use internet , you
have to start somewhere.
A simplified gateway to the internet.
Provides commonly used internet
features such as searching ,
application integration,
personalization.
Types of Portals

Mega Portals
Business-to-Consumer web applications that can be
personalized.



Horizontal Portals (myYahoo, myExcite etc)
Vertical Portals (iVillage)
Enterprise Information Portals (EIP)
Applications that enable companies to unlock
internally and externally stored information, and
provide users a single gateway to personalized
information needed to make informed business
decisions.
Enterprise Information
Portal(EIP)

Internal World Wide Web


Enterprise portals use general-purpose
applications in addition to applications specific
to the enterprise or industry.



provides business users one-stop shopping for any
information object they need inside or outside the
corporation
Stock Ticker, E-mail, appointment Calendar
Enterprise related information tapping into
Corporate Database
Provides some level of customization
Portal Products (Web Site Building Tools)








Yahoo Corporate (Yahoo Portal Builder Software)
Autonomy Inc. (Portal in a Box)
BRIO Technology (Brio.Portal)
Epicentric ( Portal Server)
IBM EIP 7.1
Microsoft SharePoint Portal Server
Plumtree
Oracle Portal
Oracle Portal







Next Generation WebDB
Web Site Building Tool by Oracle
Links database technology with other
application suites and development tools.
Information stored entirely in Oracle 8i (much
like Oracle Designer)
Uses Web-base Components called portlets
Highly Customizable for the End User
Uses Single Sign-on
Oracle Portal Architecture
Client
Middle-Tier
Database
9i Application Server
Login
Server
SSO DAD
From IAS Portal Configuration User
manual by Oracle Corp
HTTP Listener
Browse
r
mod_plsql
Portal
Repository &
Databases
Providers
Portal DAD
mod_jserv
Parallel
Page
Engine
Page Cache
Session
Cache
Web
Provider
Portal Architecture

Client


Middle Tier




HTTP Listener (by Apache)
mod_plsql, mod_jserv (Parallel Page Engine Java Servlet)
Portal DAD, SSO DAD
Portal Server (running on Oracle 8i DB)



Netscape or Internet Explorer
Portal Repository
Login Server Repository
Highly Scalable


Multiple instances of IAS on the middle tier
Multiple nodes of Portal Server to distribute database load.
What is a Portlet



(Demo)
A Portlet is information that is placed
within a region on a page
All portlets come from a data source
registered with Oracle Portal, called a
Portlet Provider
Depending upon security a Portlet can
be customized by the Portal User
Oracle Portal Key Sources




Applications:Web-enabled applications built using
robust component-building wizards
Content Areas: Repositories of corporate information,
such as documents, spreadsheets, presentations and
even list of useful related Hyperlinks
External Sites (Portal Providers): content from any
external source (Web Site), such as stock quotes, or
important news information.
Custom-built Sources: content and application pieces
built using the special Portal Development kit PDK
Oracle Portal Developer
Interface (Demo)


Built using Oracle Portal Technology
Home



Used to perform Maintenance Tasks using various
portlets
Portlets available depends on user priviliges
Navigator




Build database portlets
Content area management
Design and Build Pages
Database Objects definition access and
modification
What are Portal Applications (Demo)


Group of integrated components and
shared components designed to solve a
business need or task.
Portal Developers can use wizards to
create and deploy Forms and Reports
application quickly
Oracle Portal Application Types

Form (demo)

Master-Detail
Simple




Report (demo)





Query Wizard
Manual Query
Chart
Calendar
Dynamic Page



Hierarchy
Menu
Frame Driver
Link
List of Values
What is Content Area ?




A content area is a collection of related information stored
completely within an Oracle database
Organized logically into Folders and sub Folders
Folder (Folder Area containing items, Banner, Navigation Bar) (Demo)
The basic unit of content is an item. Folder items may be of the
following types

Application component

PL/SQL

File

Image

Text

Java Application

URL

Zip File
What is a Page


Page is the place where the information
is brought together from all the sources
(portlets) is called a Page.
A typical Oracle Portal Page consists of




Content Areas
Portals
Tab Pages
Data from External Sources, URL’s
Database Portlets (Demo)

Reports

QBE (query by example report)


Query wizard


SQL is built manually
Forms



SQL is built using a wizard
Manual


Allows end users to query, insert, update and delete data in
table and views
Simple form based on a table or view
Master/detail form
Others
Oracle Portal Administration

Demo
Some Web-sites

Developer reference




http://technet.oracle.com/
http://www.testdrive.compaq.com/
http://portalstudio.oracle.com/
Sites using Oracle Portal





http://www.orca.tv/
http://www.mywebpartner.nl/
http://www.ixarm.com/
http://www.tomatoland.com
http://www.ncnielsen.com/
Questions ?