Jerry Held

1
(No Transcript)
2
How to Build an IT Portal withOracle Application
Server
Session id 40111

• Allan L HaensgenSenior Principal Instructor
• Oracle Corporation

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

4
What Is a Region?
My Portal Page
MyCompany Benefit Plans download this file to
learn more about 2002 benefits.
Portlet TypeRegion
Item TypeRegion
5
Oracle Application Server Portal Pages
Shortcut Bar
Tool Tabs
6
Configuring a Region
Add Rows Adds a row beneath or above the current
row
Delete
Edit Region
Add Columns Adds a column to the right or left
of the current column
7
Creating Tabs
Add Tab Icon
Arrange Tab Icon
Actions Icon
Edit Tab Wizard
8
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

9
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

10
Selecting the Item Type

• File
• URL
• Text
• Zip file
• Image
• Component
• Image map
• Java application
• PL/SQL

11
Adding a Simple Text Item

• Displays static text
• Provides text editor

12
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
13
Anatomy of a Portlet
Header
Customize
Title
Help, About
MinimizeHide
Text
Image
Border
14
Populating Portal Pages with Portlets

• Select a portlet from the list. More than one
  portlet can be selected to fill a region.

15
Data-driven portlets

• Use data-driven portlets to display, create, or
  update data stored in objects in the Oracle
  database

16
Defining a Chart Name
17
Selecting a Table or View

• Use list of tables and views to which you have
  access.

18
Selecting the Label and Value Columns

• You define the bars and bar size coordinates for
  the chart by using the Label and Value fields.

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

20
Setting the Chart Common Display Options

• Order By
• Value
• Value Desc
• Label
• Label Desc
• Include Null Values
• Treat Null Values as
• Expire After (minutes)

21
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
22
Setting the Display Options of the Chart
Customization Form
Button options
Formatting options
23
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_data from EMP where
DEPT P_DEPT order by SAL desc
24
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.

Example
Portlet Name ORA00_CHARTCreate package
ORA00_CHART . . .Create package body ORA00_Chart
. .
25
Managing Data-driven Portlets
26
Adding Discoverer Portlets
27
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

28
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

29
A
30
(No Transcript)