Building Enterprise Information Portal using Oracle Portal 3.0 Rizwan Akhtar 703-568-3702 rakhtar@tangible-tech.com

1. Building Enterprise Information Portal using Oracle Portal 3.0Rizwan Akhtar 703-568-3702rakhtar@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. 9i Application Server Login Server HTTP Listener mod_plsql SSO DAD Browser Portal Repository & Databases Providers Portal DAD mod_jserv Parallel Page Engine Web Provider Page Cache Session Cache 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

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

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

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. Form (demo) Master-Detail Simple Report (demo) Query Wizard Manual Query Chart Calendar Dynamic Page Hierarchy Menu Frame Driver Link List of Values Oracle Portal Application Types

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

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, URL’s

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 ?