Building Enterprise Information Portal using Oracle Portal 3

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

What will we cover today ? n n n Portal Products Oracle Portal Architecture Portlets Database Applications, Content Area, Page Demo Database Portlets Portal Administration Features

Internet Portals n n n 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.

Types of Portals n Mega Portals Business-to-Consumer web applications that can be personalized. n n n Horizontal Portals (my. Yahoo, my. Excite etc) Vertical Portals (i. Village) 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.

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

Portal Products (Web Site Building Tools) n n n n Yahoo Corporate (Yahoo Portal Builder Software) Autonomy Inc. (Portal in a Box) BRIO Technology (Brio. Portal) Epicentric ( Portal Server) IBM EIP 7. 1 Microsoft Share. Point Portal Server Plumtree Oracle Portal

Oracle Portal n n n n Next Generation Web. DB Web Site Building Tool by Oracle Links database technology with other application suites and development tools. Information stored entirely in Oracle 8 i (much like Oracle Designer) Uses Web-base Components called portlets Highly Customizable for the End User Uses Single Sign-on

Oracle Portal Architecture Client Middle-Tier Database 9 i Application Server Login Server SSO DAD From IAS Portal Configuration User manual by Oracle Corp HTTP Listener Browse r mod_plsql Portal Repository & Databases Providers Portal DAD mod_jserv Parallel Page Engine Page Cache Session Cache Web Provider

Portal Architecture n Client n n Middle Tier n n HTTP Listener (by Apache) mod_plsql, mod_jserv (Parallel Page Engine Java Servlet) Portal DAD, SSO DAD Portal Server (running on Oracle 8 i DB) n n n Netscape or Internet Explorer Portal Repository Login Server Repository Highly Scalable n n Multiple instances of IAS on the middle tier Multiple nodes of Portal Server to distribute database load.

What is a Portlet n n n (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

Oracle Portal Key Sources n n 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

Oracle Portal Developer Interface (Demo) n n Built using Oracle Portal Technology Home n n n Used to perform Maintenance Tasks using various portlets Portlets available depends on user priviliges Navigator n n Build database portlets Content area management Design and Build Pages Database Objects definition access and modification

What are Portal Applications n n (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

Oracle Portal Application Types n Form (demo) n Master-Detail Simple n n Report (demo) n n n Query Wizard Manual Query Chart Calendar Dynamic Page n n n Hierarchy Menu Frame Driver Link List of Values

What is Content Area ? n n 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 n Application component n PL/SQL n File n Image n Text n Java Application n URL n Zip File

What is a Page n n 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 n n Content Areas Portals Tab Pages Data from External Sources, URL’s

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

Oracle Portal Administration n Demo

Some Web-sites n Developer reference n n http: //technet. oracle. com/ http: //www. testdrive. compaq. com/ http: //portalstudio. oracle. com/ Sites using Oracle Portal n n n http: //www. orca. tv/ http: //www. mywebpartner. nl/ http: //www. ixarm. com/ http: //www. tomatoland. com http: //www. ncnielsen. com/

Questions ?