Oracle Application Express 3.0 New Features

1
Oracle Application Express 3.0 New Features
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
Oracles products remain at the sole discretion
of Oracle.
3
Agenda

• Overview
• Benefits
• Architecture
• Release 3.0 New Features
• QA

4
Oracle Application Express

• Browser Based
• Declarative
• Robust Framework
• Multi-Tenant Hosting
• MS Access Replacement
• Packaged Applications
• Feature of the Oracle database
• Community Focused

Free
5
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)

6
Standard App Dev Features

7
Architecture Overview
With the Embedded PL/SQL Gateway (XE and 11g)

8
Multi Tenant Hosting

• Self Service Provisioning
• Consolidate Applications

9
Consolidation with Application Express
10
Application Express 3.0 New Features
March 2007

• 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 URLs
• Improved Workspace administration

11
BI Publisher

• Declarative PDF Reporting Services
• Create Professional looking Reports
• Range of Document Formats

12
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

13
Declarative PDF Reporting Services

• Enable Report Print Attributes

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
Supporting Objects Enhancement

• Add Upgrade Scripts
• Provide Upgrade patches to your packaged
  applications

20
Page Region Caching

• Improve Application Performance
• Reduce Database Overhead
• Ideal for Public Pages and Regions

21
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
22
Calendar Enhancement

• Support for additional attributes
• Weekly Calendar View
• Daily Calendar View

23
Schema Comparison

• View Schema Comparison Reports
• View Details
• View Differences

24
Application Comparison

• View Application Comparison Reports
• View Details
• View Differences

25
New Item Types

• Shuttle
• HTML Editor
• Minimal
• Standard
• Date Picker (Customizable format mask)

26
Item Finder Enhancement

• Search now includes
• Images
• CSS files

27
Friendly URL Syntax

• Ideal for Public Pages
• Facilitate Bookmarks
• Index for Search Engines

28
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

29
Review of Oracle Application Express 2.2 New
Features

• Packaged Application
• Wizard based install of a complete Application
• Access Control Wizard
• Include an Admin Page for added Application
  security
• Dictionary Views
• View Application Metadata
• New Item Finder Search Tool
• Quickly search for Application Database objects
• Copy pages
• Within the Application or to another Application
• Component-level Export
• Read about other 2.2 Specific New Features

30
Conclusion

• Improved Reporting and Charting
• Access Migration Consolidation
• Additional Item Types
• Better ability to incorporate Web Services
• Enhancements for Developers
• Improved Administration

31
Next Steps

• More information and downloads
• otn.oracle.com/apex
• Oracle Application Express 2-Day Developer
  tutorial
• otn.oracle.com/apex
• Download pre-built applications
• Packaged Applications
• APEX Studio (apex.oracle.com/studio)

32
Q

A
33
(No Transcript)