Building Enterprise Information Portal using Oracle Portal 3.0 Rizwan Akhtar 703-568-3702 [e-mail]

1
Building Enterprise Information Portal using
Oracle Portal 3.0Rizwan Akhtar
703-568-3702rakhtar_at_tangible-tech.com
2
What will we cover today ?

• Portal Products
• Oracle Portal Architecture
• Portlets
• Database Applications,Content Area, Page
• Demo Database Portlets
• Portal Administration Features

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

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

5
Enterprise Information Portal(EIP)

• Internal World Wide Web
• provides business users one-stop shopping for any
  information object they need inside or outside
  the corporation
• Enterprise portals use general-purpose
  applications in addition to applications specific
  to the enterprise or industry.
• Stock Ticker, E-mail, appointment Calendar
• Enterprise related information tapping into
  Corporate Database
• Provides some level of customization

6
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

7
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

8
Oracle Portal Architecture
Client
Middle-Tier
Database
From IAS Portal Configuration User manual by
Oracle Corp
9
Portal Architecture

• Client
• Netscape or Internet Explorer
• 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)
• Portal Repository
• Login Server Repository
• Highly Scalable
• Multiple instances of IAS on the middle tier
• Multiple nodes of Portal Server to distribute
  database load.

10
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

11
(No Transcript)
12
(No Transcript)
13
Oracle Portal Key Sources

• ApplicationsWeb-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

14
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

15
(No Transcript)
16
(No Transcript)
17
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

18
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

19
(No Transcript)
20
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
21
(No Transcript)
22
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, URLs

23
(No Transcript)
24
Database Portlets (Demo)

• Reports
• QBE (query by example report)
• Allows end users to query, insert, update and
  delete data in table and views
• Query wizard
• SQL is built using a wizard
• Manual
• SQL is built manually
• Forms
• Simple form based on a table or view
• Master/detail form
• Others

25
Oracle Portal Administration

• Demo

26
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/

27
Questions ?