100 likes | 358 Views
<Insert Picture Here>. Oracle Application Express Summary . Oracle APEX Roadmap. APEX 3.1.2 Introduced Interactive Reports Basis for Audit Vault Reporting APEX 3.2 – Latest Production Release Forms Conversion Enhanced Security features APEX 4.0 Websheets Oracle APEX Listener
E N D
<Insert Picture Here> Oracle Application Express Summary
Oracle APEX Roadmap • APEX 3.1.2 • Introduced Interactive Reports • Basis for Audit Vault Reporting • APEX 3.2 • – Latest Production Release • Forms Conversion • Enhanced Security features • APEX 4.0 • Websheets • Oracle APEX Listener • Improved Tabular Forms • Dynamic Actions Download from OTN © 2009 Oracle Corporation
Latest APEX Features • Forms Conversion [3.2] – Enables the loading of Oracle Forms source into an Oracle Application Express project and generate an initial APEX application. • Interactive Reports [3.1] – An innovative new technology that allows end users to customize reports. By putting more power in the hands of users it reduces development time and effort while simultaneously enhancing application functionality. • Web Services Integration [3.1] – Ability to easily integrate with services through either built-in Web service support or through lower level PL/SQL UTL_HTTP package calls. • Optional Runtime-Only Deployment [3.1] – Ability to install just a runtime APEX environment via SQL scripts for production environments, minimizing installed footprint and increasing security. • PDF Printing [3.0] – Integrate with Report Server (Oracle BI Publisher, Apache FOP, or XSL-FO) to produce PDF, XLS, HTML outputs. Can define multiple report queries and load custom RTF or XSL-FO templates. • Flash Charts [3.0] – Create professional charts using Adobe Flash • MS Access Migration [3.0] – Use SQL Developer Migration Workshop to migrate the Access schema and data. Then migrate the Access Forms, Reports and Queries using APEX to generate a first-cut design © 2009 Oracle Corporation
Oracle Application Express • Oracle 11g differentiator (Application Development framework) • Large and Rapidly growing APEX community • Dominating Oracle RAD development (Fast and easy) • Capitalizes on SQL and PL/SQL knowledge and popularity • Driving legacy conversion / consolidation • Web 2.0 capabilities – Interactive Reports, Flash, AJAX • Empowering technology – Scalable, Integrated and Secure • Integration – EBS, CRM On-Demand, etc. © 2009 Oracle Corporation
Oracle Application Express FUD • Only good for Excel / Access replacement • Successfully used to meet a large variety of use cases from small to very large, from simple to very complex • Simple architecture won’t scale • Single tier architecture results in fewer network traversals and CPU cycles per page request • Takes full advantage of Oracle Database capabilities and features as built 100% inside database • Proven by countless customer success stories and sites like ARIA, AskTom, ThinkQuest • APEX is not here to stay • APEX 3.2 represents the 8th major release since 2004 • Integrated into Oracle 11gR1 Seed Database (Part of the core database as a standard feature) • Oracle increasingly relies on APEX for internal applications to improve business processes • It’s free so it can’t be … • Oracle provides APEX, SQL Developer, etc. at no-cost to encourage development in Oracle Technologies and increase utilization of the Oracle Database • Dedicated APEX Oracle Support team available as part of standard Oracle Database license • Oracle will charge for APEX in the future • Oracle has no plans to charge for APEX • No precedent exists for Oracle charging for a database feature that is currently “no-cost” © 2009 Oracle Corporation
Next Steps Information: http://otn.oracle.com/apex Hosted Development: http://apex.oracle.com © 2009 Oracle Corporation
D E M O N S T R A T I O N Rapid Application Development © 2009 Oracle Corporation
Q & A © 2009 Oracle Corporation