Oracle Openworld Directory Index

What Portal is NOT!
Versioned content management tool
No content check-in and check-out
A comprehensive development tool
It has its limits
At least within the tool
Can use any tool to extend Portal
How Would I Use Portal?
Development Foundation
Main menu
User specific content
Quick/easy component development
Super-user tool (with views)
Single Sign-on
Authentication
Authorization
Oracle Portal Background
9iAS Portal Architecture
Oracle Portal Installation
Series of components
Configuration assistant creates several schemas
Six schemas created in Portal 3.0.9 installation
PORTAL30
Primary Portal product schema
Contains Portal DB objects
Base schema name can be changed at install time
Additional Portal Schemas
PORTAL30_PUBLIC
Users map to this schema
PORTAL30_SSO
Login Server schema
PORTAL30_SSO_PS
Password store for external applications
As of version 3.08
PORTAL30_SSO_PUBLIC
Users signing on map to this schema
PORTAL30_DEMO
Demonstration applications
Portal Accounts (not Schemas)
PORTAL30
Highest privileges
Portal Administrator
PORTAL30_ADMIN
Administrator account
No DBA features
PORTAL30_SSO
Public users
Unauthenticated sessions
PORTAL30_SSO_PS
Used by Login Server
PORTAL30_SSO_PUBLIC
Administrative account
Login Server privileges
No Portal administrative privileges
PORTAL30_DEMO
Demonstration application user
Oracle Portal Home Page
Portal Pages for presentation
Represent the canvas
Blank HTML documents are pages
Oracle Portal Home Page is default
Page has four tabs
Build - Create Portal components
Administer - Portal administration
Administer Database – for DBAs
Monitor – to monitor components within Portal
Oracle Portal Home Page
Oracle 9iAS Portal Basics
Portlets
Pages
Content Areas
Applications
Application Components

Portlets
Reusable content areas
Can be placed on one or more pages, and can be moved around the page for that “customized feel”
You can make some application components into Portlets and place them on a page
Pages
Pages are the canvas for your application
They are what the user sees when they login
They can contain your forms, reports, etc
They can be customized by group, or user
Content Areas
Content Areas are one way of deploying your data (the other being Pages)
Support version control
Support check in/check out
Can upload a variety of things (files, text, etc)
Application Components
12 application components
Form, Report, Chart, Calendar, Dynamic Page, XML Component, Hierarchy, Menu, URL, Frame Driver, Link, List of Values, Data Component
2 beta components
Image Charts From Query Wizard
Data Component
Created via wizards
Application Components
Forms Component
Forms wizard
Create form
Custom layout
3 types of Forms
Form based on table or view (easiest form)
Build a form based on a database table or view.
Master-detail form
Build a master-detail form based on two tables or views.
Form based on procedure (very cool)
Build a form based on a database stored procedure.
Forms Component
Reports Component
Query By Example (QBE) Reports (easiest)
Build a QBE Report that allows end users to query, insert, update and delete data in table and views
Reports From Query Wizard (2nd easiest)
Let the wizard build the SQL query for you
Reports From SQL Query
Write your own SQL Query
SELECT * FROM SCOTT.EMP WHERE deptno = :department_number
Guided by a Wizard
Reports Component
Chart Component
Charts From Query Wizard
Let the wizard build the SQL query for you
Charts From SQL Query
Write your own SQL query
select [the_link], [the_name], [the_data]
from [table]
Image Charts From Query Wizard
Build Image Charts using Query Wizard
Chart Component
Sample Application
Oracle Portal and Beyond
Summary
Portal Overview
9iAS Portal Architecture
Oracle Portal Basics
Portal Home Page
Portlets
Pages
Content Areas
Applications
Application Components
Forms
Reports
Charts
Sample Application


Fill Out a Survey and Get a Chance to Win a Compaq iPAQ!
We want to know what you think! Fill out the survey that was handed out at the beginning of the session for a chance to win a Compaq iPAQ. Remember to include your name and email in the available section and we will enter your name into two daily drawings to win an iPAQ

Tony Catalano, Vice President
catalanoa@tusc.com
377 E. Butterfield Road
Suite 100
Lombard, IL 60148

630-960-2909
800-755-TUSC
www.tusc.com
Copyright Information
Neither TUSC or the author guarantee this document to be error-free. Please provide comments/questions to catalanoa@tusc.com.
TUSC © 2001. This document cannot be reproduced without expressed written consent from an officer of TUSC
For More Information
www.tusc.com
metalink.oracle.com
technet.oracle.com
portalstudio.oracle.com
www.orafaq.org
www.revealnet.com
www.odtug.com