1 / 61

Integrating Oracle HTML DB with Oracle Application Server 10g

Integrating Oracle HTML DB with Oracle Application Server 10g. Scott Spendolini Senior Product Manager, Oracle HTML DB Oracle Corporation. Agenda. Oracle HTML DB Overview Integration Points with Oracle Application Server 10g Summary Q & A. Oracle HTML DB Overview.

parson
Télécharger la présentation

Integrating Oracle HTML DB with Oracle Application Server 10g

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Integrating Oracle HTML DB with Oracle Application Server 10g

  2. Scott SpendoliniSenior Product Manager, Oracle HTML DB Oracle Corporation

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

  4. Oracle HTML DB Overview

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

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

  7. Availability • Release 1.5 • Software ships on Oracle Database 10g Companion CD • Release 1.6 • Available as a Download from OTN • 1.6.1 Patchset Available via Metalink • Works & Supported in Oracle Database 10g and Oracle Database 9iR2 (9.2.0.3+) • Included as a component of Standard One, Standard and Enterprise Editions • No Additional Charge

  8. Browser Oracle HTML DB syracuse.us.oracle.com Demo EnvironmentPhysical Architecture orangemen.us.oracle.com

  9. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Demo EnvironmentPhysical Architecture

  10. Demo EnvironmentToday’s Architecture Red Hat Advanced Server htmldb-demo.us.oracle.com

  11. Oracle HTML DBLogical 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

  12. Oracle HTML DBLogical Architecture Workspace A Applications Applications Schema A Workspace B Applications Applications Schema B Workspace C Applications Applications Schema C

  13. Integration Points with Oracle Application Server 10g

  14. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Oracle HTTP Server & mod_plsql

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

  16. Oracle HTTP Server & mod_plsqlHow 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

  17. Oracle HTTP Server & mod_plsqlSteps to Configure • Add an entry to your DAD configuration file for each instance of Oracle HTML DB: <Location /pls/htmldb> SetHandler pls_handler Order deny,allow Allow from all AllowOverride None PlsqlDatabaseUsername HTMLDB_PUBLIC_USER PlsqlDatabasePassword @BXUKpCh0pabnAcDAE+X2P9w= PlsqlDatabaseConnectString localhost:1521:sadler ServiceNameFormat PlsqlDefaultPage htmldb PlsqlDocumentTablename wwv_flow_file_objects$ PlsqlDocumentPath docs PlsqlDocumentProcedure wwv_flow_file_manager.process_download PlsqlAuthenticationMode Basic PlsqlNLSLanguage AMERICAN_AMERICA.WE8MSWIN1252 </Location>

  18. Oracle HTTP Server & mod_plsqlResources • OTN: Oracle HTTP Serverhttp://www.oracle.com/technology/products/ias/ohs/index.html • Studio: Install HTML DB into multiple Oracle Instances using a single Oracle HTTP Serverhttp://htmldb.oracle.com/pls/otn/f?p=18326:54:::::P54_ID:481 • How To: Install and Configure Oracle HTML DB for use with Oracle Application Server 10ghttp://www.oracle.com/technology/products/database/htmldb/howtos/howto_useoas10g.html • How To: Install and Configure Oracle HTML DB for use by a 9iR2 Oracle HTTP Server http://www.oracle.com/technology/products/database/htmldb/howtos/howto_use9ir2ohs.html

  19. Oracle HTTP Server & mod_plsqlDemonstration

  20. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Oracle Single Sign-On

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

  22. Oracle Single Sign-OnHow 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

  23. Oracle Single Sign-OnSteps 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

  24. Oracle Single Sign-OnResources • OTN: Oracle Single Sign-Onhttp://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

  25. Oracle Single Sign-OnDemonstration

  26. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Oracle Portal

  27. Oracle PortalSoftware & Editions Required • Software • Oracle Portal • OmniPortlet • Oracle Single Sign-On Server • Oracle Internet Directory • Editions • Oracle AS Standard Edition • Oracle AS Enterprise Edition

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

  29. Oracle PortalSteps to Configure • Create a SQL Report in HTML DB • Ensure the the Report Title and Column Titles contain no spaces (DeptNo instead of Dept No) • Change the Report Template to export: XML • Create an OmniPortlet 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

  30. Oracle PortalResources • OTN: Oracle Portalhttp://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 OmniPortlet to an HTML DB Page • Making an OmniPortlet Parameter-Driven

  31. Oracle PortalDemonstration

  32. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Oracle Internet Directory

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

  34. Oracle Internet DirectoryHow 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

  35. Oracle Internet DirectorySteps 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');

  36. Oracle Internet DirectoryResources • OTN: Oracle Internet Directoryhttp://www.oracle.com/technology/products/oid/index.html • Studio: How to use OID Groups to Manage HTML DB Securityhttp://htmldb.oracle.com/pls/otn/f?p=18326:54:::::P54_ID:281

  37. Oracle Internet DirectoryDemonstration

  38. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com Oracle Reports

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

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

  41. Oracle ReportsSteps 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=sspendol/oracle@syracuse&destype=cache&desformat=PDF&p_order_id=&P29_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

  42. Oracle ReportsResources • OTN: Oracle Reportshttp://www.oracle.com/technology/products/reports/index.html • How To: Integrate Oracle Reports with Oracle HTML DBhttp://www.oracle.com/technology/products/database/htmldb/howtos/howto_integrate_oracle_reports.html

  43. Oracle ReportsDemonstration

  44. InternetDirectory Single Sign-On Reports Portal HTTP & mod_plsql Oracle HTML DB syracuse.us.oracle.com MapViewer OC4J orangemen.us.oracle.com WebServices on Oracle AS

  45. WebServices on Oracle AS Software & Editions Required • Software • Oracle AS Containers for J2EE (OC4J) • Editions • Oracle AS Java Edition • Oracle AS Standard Edition • Oracle AS Enterprise Edition

  46. WebServices on Oracle AS How it Integrates • WebServices can be built using Oracle JDeveloper and Deployed in an OC4J container in Oracle AS Containers for J2EE • Oracle HTML DB can consume WebServices • WebService must have valid WSDL document • Both Input & Output parameters supported

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

  48. WebServices on Oracle AS Resources • OTN: Oracle AS Containers for J2EEhttp://www.oracle.com/technology/tech/java/oc4j/index.html • How To: Develop a Web Service From a Web Service Description Language (WSDL) Documenthttp://www.oracle.com/technology/tech/java/oc4j/1013/howtos/how-to-ws-topdown/doc/how-to-ws-topdown.html • Publish a JAX-RPC Web Servicehttp://www.oracle.com/technology/tech/webservices/htdocs/series/jaxrpc1/index.html

  49. Oracle AS Containers for J2EE Demonstration

More Related