1 / 31

Oracle Application Express 3.0

Oracle Application Express 3.0. Joel R. Kallman Software Development Manager.

noam
Download Presentation

Oracle Application Express 3.0

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. Oracle Application Express 3.0 Joel R. Kallman Software Development Manager

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remain at the sole discretion of Oracle.

  3. Agenda • Overview • Architecture • Release 3.0 New Features • Demonstration • Q & A

  4. Browser Based • Browser Based Application Development • No Client Software to Develop, Deploy, or Run Applications • Full Service: Application Building, SQL Workshop, Utilities

  5. Simplify Application Development on Oracle • PL/SQL Developers • Non-professional developers • Power users • Departments • Small enterprises

  6. Application Express – Declarative • No code is generated • You write some SQL and optionally PL/SQL snippets • Declarative development yields fewer differences between developers • Less risk for developer introduced security issues • Meta data driven

  7. Benefits • Development • Easy point-and-click • Reduces Time, Complexity and Expense • No Client Software • Leverages existing SQL Skills • Integrated SQL Workshop • Architecture • Integrated into Database • Multi Tenant Hosting • No extra cost (feature of the database)

  8. Standard App Dev Features

  9. With Oracle HTTP Server (Apache) and mod_plsql Architecture Overview With the Embedded PL/SQL Gateway (XE and 11g)

  10. Multi Tenant Hosting • Self Service Provisioning • Consolidate Applications

  11. Application Express Availability • Feature of the Oracle 10g Database • Supported on Oracle 9.2.0.3 and higher • Delivered on the Companion CD with 10gR1 and 10gR2 • Is the interface of Oracle Database 10g Express Edition (XE) • Standard database component in 11gR1 (installable via Database Configuration Assistant)

  12. Application Express 3.0 New Features • Key Changes and Enhancements • Declarative PDF Reporting Services • Flash Charts • Drag & Drop Item layout • Improved Web-Services • Access Migration Workshop • New Item types • Calendar Enhancements • Supporting objects enhancement • Page & Region Caching • Item Finder Enhancements • Application and Schema Comparison • Bookmark URL’s • Improved Workspace administration

  13. BI Publisher • Print PDF, Word, Excel, or HTML Reports • “High Fidelity” Printing • Seamlessly Integrated with Application Express • Develop RTF Templates using Word Plug-In • Full Oracle Support

  14. Declarative PDF Reporting Services • Select Report Document Formats

  15. Declarative PDF Reporting Services • Define Report Queries • Associate Report Layouts

  16. Flash Charts • 18 New Chart Types • Migrate existing SVG Charts

  17. Improved Web Services • Extended Support • Web Services created using JDeveloper • Oracle BPEL synchronous Web services • Interact with Web services over SSL (HTTPS) • Including services requiring basic authentication • Manually create Web service references

  18. Drag & Drop Item Creation • Quickly create and Delete items • Reorder and place items • Change selected item attributes

  19. Page & Region Caching • Improve Application Performance • Reduce Database Overhead • Ideal for Public Pages and Regions

  20. Access Migration Workshop • Migrate in 7 Easy Steps • Export Microsoft Access metadata • Migrate the Microsoft Access database to Oracle • Create an Oracle Application Express Workspace • Create a migration project • Analyze the Microsoft Access application • Generate the Oracle Application Express Application • Customize your Application Express application End-User 1 2 7 6 3 4 5

  21. Calendar Enhancement • Support for additional attributes • Weekly Calendar View • Daily Calendar View

  22. Schema Comparison • View Schema Comparison Reports • View Details • View Differences

  23. Application Comparison • View Application Comparison Reports • View Details • View Differences

  24. New Item Types • Shuttle • HTML Editor • Minimal • Standard • Date Picker (Customizable format mask)

  25. Item Finder Enhancement • Search now includes • Images • CSS files

  26. Improved Instance & Workspace Management • Configure Security Settings • Set rules for Password Expiry • Enforce “Strong” Password creation • Minimum characters • Numeric/Alphanumeric Characters • Change password on first use • Useful for system generated initial passwords • Account Locking Facility • Define Workspace sizes • Request for an email of your Workspace Names • Log containing of login attempts

  27. Packaged Applications • Project Tracking • People Search • Discussion Forum • Bug Tracker • Online Store • Ask the Expert • Issue Tracker • Document Management

  28. Packaged Applications - Coming Soon • Event Management • Asset Management • Loan Analyzer • Timesheets • Status Reports

  29. Next Steps http://apex.oracle.com

  30. Q & A

More Related