How to Build an IT Portal withOracle Application Server
Allan L HaensgenSenior Principal Instructor
Oracle Corporation
Session id: 40111
What Is a Portal Page?
• A portal page is an interface that brings information sources together in one place and serves as a starting point for Web applications.
• The layout of portal pages is defined through regions.
• Regions contain portlets or items.
My Portal Page
MyCompanyBenefit Plans download this file to learn more about 2002 benefits.
What Is a Region?
Portlet TypeRegion
Item TypeRegion
Oracle Application Server Portal Pages
Shortcut Bar
Tool Tabs
Configuring a Region
Add Columns: Adds a column to the
right or left of the current column
Add Rows: Adds a row beneath or
above the current row
DeleteEdit Region
Add Tab Icon
Arrange Tab Icon
Edit Tab Wizard
Actions Icon
Creating Tabs
Adding Content to a Portal Page
Items– Basic unit of content within a page– It holds content to be displayed on the
Oracle9iAS Portal page– Two types of item types exist:
Content items, such as files, text, URLs Navigation items, such as smart links and page
paths
Adding Content to a Portal Page
Portlets– Areas within a portal page that display
information– Form complete stand alone fragments of content
that can be included on any page– Can be developed externally, then registered with
Oracle Portal– Can be built through a wizard or
programmatically
Selecting the Item Type
• File• URL• Text• Zip file• Image• Component• Image map• Java application• PL/SQL
Adding a Simple Text Item– Displays static text – Provides text editor
Managing Items
• Items can be edited, deleted, moved, or reordered.
• The icons which you use to manage an item are located next to the item.
Edit
Action
Anatomy of a PortletTitleTitle Header
Border
Text
Image
Customize Help, AboutMinimizeHide
Populating Portal Pages with Portlets
Select a portlet from the list. More than one portlet can be selected to fill a region.
Data-driven portlets
Use data-driven portlets to display, create, or update data stored in objects in the Oracle database
Defining a Chart Name
Selecting a Table or View
Use list of tables and views to which you have access.
Selecting the Label and Value Columns
You define the bars and bar size coordinates for the chart by using the Label and Value fields.
Setting the Chart Column Conditions
You set the conditions that limit the data displayed in the chart by using the Column Name, Condition, and Value fields.
Setting the Chart Common Display Options
– Order By Value Value Desc Label Label Desc
– Include Null Values– Treat Null Values as– Expire After (minutes)
Setting the Chart Full-Page and Portlet Display Options
– Control font, color, and size of the chart text and bars
– Govern presentation of the chart
Chart Type = HorizontalAxis = Average ValueBar Image = green.gifSummary Options = Average ValueMaximum Rows Per Page = 5
Setting the Display Options of the Chart Customization Form
Formatting options
Button options
Writing a SQL Query
– The SQL query must select three columns: the_link (optional) the_name (required) the_data (required)
– Bind variables are prefixed by colons.
select null the_link, ENAME the_name, SAL the_datafrom EMPwhere DEPT = :P_DEPTorder by SAL desc
Storing a Data-driven Portlet
– Data-driven portlets are stored as packaged PL/SQL procedures in the database.
– The PL/SQL package has the same name as the data-driven portlet.
Portlet Name = ORA00_CHARTCreate package ORA00_CHART . . .Create package body ORA00_Chart . .
Example
Managing Data-driven Portlets
Adding Discoverer Portlets
Other terms you need to know
• Page Groups - An Oracle Application Server Portal object that groups related pages together
• Styles - Defines a look and feel of portal pages• Templates - A reusable page definition which
can include styles and items• Categories – A method used to classify content
on the pages• Perspectives – A cross-category grouping
Next Steps….
Recommended sessions– Simplify and Strengthen Security with Oracle Application
Server Session ID: 40112 See Your Business in Our Software
– Visit the DEMO grounds for a customized architectural review, see a customized demo with Solutions Factory, or receive a personalized proposal. Visit the DEMO grounds for more information.
Relevant web sites to visit for more information– http://portal.oracle.com– http://portalstudio.oracle.com– http://portalcenter.oracle.com
AQ&Q U E S T I O N SQ U E S T I O N S
A N S W E R SA N S W E R S