Integrating Oracle HTML DB with Oracle Application Server

Integrating Oracle HTML DB with Oracle Application Server 10 g

Scott Spendolini Senior Product Manager, Oracle HTML DB Oracle Corporation

Agenda • Oracle HTML DB Overview • Integration Points with Oracle Application Server 10 g • Summary • Q&A

Oracle HTML DB Overview

What is Oracle HTML DB? • A secure, web-based, metadatadriven, database-centric application development and deployment platform that resides in the Oracle Database

Portal vs. HTML DB • Oracle Portal Consolidated View of Personalized Data from Multiple Sources • Oracle HTML DB Secure, Scalable Platform for Web Application Development & Deployment

Availability • Release 1. 5 • Software ships on Oracle Database 10 g Companion CD • Release 1. 6 • Available as a Download from OTN • 1. 6. 1 Patchset Available via Metalink • Works & Supported in Oracle Database 10 g and Oracle Database 9 i. R 2 (9. 2. 0. 3+) • Included as a component of Standard One, Standard and Enterprise Editions • No Additional Charge

Demo Environment Physical Architecture Oracle HTML DB syracuse. us. oracle. com Browser orangemen. us. oracle. com

Demo Environment Physical Architecture Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Demo Environment Today’s Architecture Red Hat Advanced Server htmldb-demo. us. oracle. com

Oracle HTML DB Logical Architecture • Shared Workgroup Database Service • Ability to Host Many Users on a Single Instance • Centrally Deployed & Managed • Accessed anywhere via a Browser • Declarative development style • Pages & Objects Stored as Metadata • Wizard-Based Development

Oracle HTML DB Logical Architecture Workspace A Applications Schema A Workspace B Applications Schema B Workspace C Applications Schema C

Integration Points with Oracle Application Server 10 g

Oracle HTTP Server & mod_plsql Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle HTTP Server & mod_plsql Software & Editions Required • Software • Oracle HTTP Server • mod_plsql • Editions • Oracle AS Java Edition • Oracle AS Standard Edition • Oracle AS Enterprise Edition

Oracle HTTP Server & mod_plsql How it Integrates • Oracle HTTP Server & mod_plsql from Oracle AS can be used to serve Oracle HTML DB • A single instance of OHS & mod_plsql can point to multiple instances of Oracle HTML DB • Add entries to DAD configuration file • Cluster HTTP Servers for Failover

Oracle HTTP Server & mod_plsql Steps to Configure • Add an entry to your DAD configuration file for each instance of Oracle HTML DB: <Location /pls/htmldb> Set. Handler pls_handler Order deny, allow Allow from all Allow. Override None Plsql. Database. Username Plsql. Database. Password Plsql. Database. Connect. String Plsql. Default. Page Plsql. Document. Tablename Plsql. Document. Path Plsql. Document. Procedure Plsql. Authentication. Mode Plsql. NLSLanguage </Location> HTMLDB_PUBLIC_USER @BXUKp. Ch 0 pabn. Ac. DAE+X 2 P 9 w= localhost: 1521: sadler Service. Name. Format htmldb wwv_flow_file_objects$ docs wwv_flow_file_manager. process_download Basic AMERICAN_AMERICA. WE 8 MSWIN 1252

Oracle HTTP Server & mod_plsql Resources • OTN: Oracle HTTP Server http: //www. oracle. com/technology/products/ias/ohs/index. html • Studio: Install HTML DB into multiple Oracle Instances using a single Oracle HTTP Server http: //htmldb. oracle. com/pls/otn/f? p=18326: 54: : : P 54_ID: 481 • How To: Install and Configure Oracle HTML DB for use with Oracle Application Server 10 g http: //www. oracle. com/technology/products/database/htmldb/howtos/howto_useoas 10 g. html • How To: Install and Configure Oracle HTML DB for use by a 9 i. R 2 Oracle HTTP Server http: //www. oracle. com/technology/products/database/htmldb/howtos/howto_use 9 ir 2 ohs. html

Oracle HTTP Server & mod_plsql Demonstration

Oracle Single Sign-On Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle Single Sign-On Software & Editions Required • Software • Oracle Single Sign-On Server • Editions • Oracle AS Standard Edition • Oracle AS Enterprise Edition

Oracle Single Sign-On How it Integrates • Oracle HTML DB can integrate with Oracle Single Sign-on as a: • Partner Application • External Application • Signing on to the Oracle Login Server means you're authenticated to any Oracle HTML DB application using the SSO Authentication Scheme

Oracle Single Sign-On Steps to Configure • Download & Install the SSO SDK into your HTML DB Schema • Alternatively, you can install the SSO SDK into a separate schema, in order to preserve it when HTML DB is upgraded • Create an SSO Authentication Scheme in your HTML DB Application • Register Oracle HTML DB or a specific Oracle HTML DB Application as a Partner Application

Oracle Single Sign-On Resources • OTN: Oracle Single Sign-On http: //www. oracle. com/technology/products/id_mgmt/osso/index. html • How To: Configure an HTML DB Application as a Partner Application in Oracle AS Single Sign-On http: //www. oracle. com/technology/products/database/htmldb/howtos/sso_partner_app. html

Oracle Single Sign-On Demonstration

Oracle Portal Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle Portal Software & Editions Required • Software • Oracle Portal • Omni. Portlet • Oracle Single Sign-On Server • Oracle Internet Directory • Editions • Oracle AS Standard Edition • Oracle AS Enterprise Edition

Oracle Portal How it Integrates • Oracle Portal can be used as a launch point for Oracle HTML DB Applications which are integrated with Oracle SSO • The Omni. Portlet can display any Oracle HTML DB Report of type XML as a table, chart, news items, bullets, or in a form • Omni. Portlets can drill-down into Oracle HTML DB applications • Page Parameters can be passed to the Omni. Portlet in order to filter the results from Oracle HTML DB

Oracle Portal Steps to Configure • Create a SQL Report in HTML DB • Ensure the Report Title and Column Titles contain no spaces (Dept. No instead of Dept No) • Change the Report Template to export: XML • Create an Omni. Portlet of type XML • Supply the URL for the page with your Oracle HTML DB XML Report for the XML URL • Specify the Filter, View and Layout parameters • Under View, select "Don't Cache the Portlet Content" to ensure that you don't see stale data in Oracle Portal

Oracle Portal Resources • OTN: Oracle Portal http: //www. oracle. com/technology/products/ias/portal/index. html • How To: Publish an HTML DB Component as a Portlet in Oracle Application Server Portal http: //www. oracle. com/technology/products/database/htmldb/howtos/omniportlet_index. html • Publishing an HTML DB Report on a Portal Page • Publishing an HTML DB Report as a Chart on a Portal Page • Linking from an Omni. Portlet to an HTML DB Page • Making an Omni. Portlet Parameter-Driven

Oracle Portal Demonstration

Oracle Internet Directory Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle Internet Directory Software & Editions Required • Software • Oracle Internet Directory • Editions • Oracle AS Standard Edition with Identity Management Option • Oracle AS Enterprise Edition

Oracle Internet Directory How it Integrates • Oracle HTML DB Users & Groups can be stored in Oracle Internet Directory (OID) • OID can be synchronized with MS Active Directory • OID Groups can be referenced in Oracle HTML DB Authorization Schemes to restrict access to Oracle HTML DB applications and/or components • Users can manage their own account (change their password, edit their profile) via OID • Administrators can enforce security policies (password settings & expiration dates, etc) via OID

Oracle Internet Directory Steps to Configure • Create an Authorization Scheme based on a PL/SQL Function Returning BOOLEAN • Associate the Authorization Scheme with a page or page component in HTML DB • Sample function call: return wwv_flow_ldap. is_member (: APP_USER, null, 'cn=users, dc=somedomain, dc=com', 'oidserver. somedomain. com', '389', 'SAMPLE_APP_ADMINS', 'cn=Groups, dc=somedomain, dc=com');

Oracle Internet Directory Resources • OTN: Oracle Internet Directory http: //www. oracle. com/technology/products/oid/index. html • Studio: How to use OID Groups to Manage HTML DB Security http: //htmldb. oracle. com/pls/otn/f? p=18326: 54: : : P 54_ID: 281

Oracle Internet Directory Demonstration

Oracle Reports Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle Reports Software & Editions Required • Software • Oracle Reports Services • Editions • Oracle AS Business Intelligence • Oracle AS Enterprise Edition

Oracle Reports How it Integrates • Oracle HTML DB applications can directly call Oracle Reports to produce PDF output • Parameters can be passed to the Report

Oracle Reports Steps to Configure • Create and deploy and Oracle Report on your Oracle AS server • Build an HTML DB Application that will call the Oracle Report • /reports/rwservlet? module=orders. rdf&userid=sspendo l/oracle@syracuse&destype=cache&desformat=PDF&p _order_id=&P 29_ORDER_ID. • You can optionally secure the report and not pass username & password via the URL • You can optionally store parameters in a table to prevent URL tampering

Oracle Reports Resources • OTN: Oracle Reports http: //www. oracle. com/technology/products/reports/index. html • How To: Integrate Oracle Reports with Oracle HTML DB http: //www. oracle. com/technology/products/database/htmldb/howtos/howto_integrate_oracle_reports. html

Oracle Reports Demonstration

Web. Services on Oracle AS Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Web. Services on Oracle AS Software & Editions Required • Software • Oracle AS Containers for J 2 EE (OC 4 J) • Editions • Oracle AS Java Edition • Oracle AS Standard Edition • Oracle AS Enterprise Edition

Web. Services on Oracle AS How it Integrates • Web. Services can be built using Oracle JDeveloper and Deployed in an OC 4 J container in Oracle AS Containers for J 2 EE • Oracle HTML DB can consume Web. Services • Web. Service must have valid WSDL document • Both Input & Output parameters supported

Web. Services on Oracle AS Steps to Configure • Build & Deploy a Web. Service and associated WSDL document with Oracle JDeveloper & Oracle AS • Consume the Web. Service with Oracle HTML DB • Build a report and/or a form based on the in/out parameters of the Web. Service

Web. Services on Oracle AS Resources • OTN: Oracle AS Containers for J 2 EE http: //www. oracle. com/technology/tech/java/oc 4 j/index. html • How To: Develop a Web Service From a Web Service Description Language (WSDL) Document http: //www. oracle. com/technology/tech/java/oc 4 j/1013/howtos/how-to-ws-topdown/doc/how-to-ws-topdown. html • Publish a JAX-RPC Web Service http: //www. oracle. com/technology/tech/webservices/htdocs/series/jaxrpc 1/index. html

Oracle AS Containers for J 2 EE Demonstration

Oracle AS Map. Viewer Oracle HTML DB syracuse. us. oracle. com Single Sign-On Portal Internet Directory Reports OC 4 J Map. Viewer HTTP & mod_plsql orangemen. us. oracle. com

Oracle AS Map. Viewer Software & Editions Required • Software • Oracle AS Map. Viewer • Oracle AS Containers for J 2 EE (OC 4 J) • Editions • Oracle AS Java Edition • Oracle AS Standard Edition • Oracle AS Enterprise Edition

Oracle AS Map. Viewer How it Integrates • Oracle Map. Viewer can be embedded in an Oracle HTML DB application • PL/SQL APIs will be released with the How To • Functions Supported: • Zoom In & Out • Zoom Box • Pan

Oracle AS Map. Viewer Steps to Configure • Install PL/SQL API • Download data from Nav. Teq or OTN • Sample data for both Washington, DC & San Francisco • Spatially Index your Data • Build required HTML DB components or Download Template App from HTML DB Studio

Oracle AS Map. Viewer Resources • OTN: Oracle AS Map. Viewer http: //www. oracle. com/technology/products/mapviewer/index. html • OTN: Nav. Teq Map Data http: //www. navteq. com/oracle-download/index. jsp • OTN: Map. Viewer Quick Start http: //download. oracle. com/otn/other/mapviewer 1012_demo. zip • How To: Coming Soon

Oracle AS Map. Viewer Demonstration Launch Viewlet

Oracle HTML DB How To's • Step-by-Step instructions on how to configure/build/integrate Oracle Technologies • Each one of these Integration Demos has a corresponding How To Document http: //htmldb. oracle. com/howtos

Summary

Summary • Oracle HTML DB and Oracle Application Server 10 g are designed to work together • Oracle HTML DB can easily leverage many of Oracle Application Server 10 g's features • Combining Oracle HTML DB & Oracle Application Server 10 g make a powerful development platform

More Technical Information • Visit Oracle Technology Network http: //otn. oracle. com • Oracle HTML DB Home page http: //htmldb. oracle. com/otn • Oracle HTML DB Studio http: //htmldb. oracle. com/studio • Discuss Oracle HTML DB in the Forums http: //htmldb. oracle. com/forums

Q& A QUESTIONS ANSWERS