Insert Picture Here Oracle Application Express Summary Oracle

  • Slides: 10
Download presentation
<Insert Picture Here> Oracle Application Express Summary

<Insert Picture Here> Oracle Application Express Summary

Oracle APEX Roadmap • APEX 3. 1. 2 • Introduced Interactive Reports • Basis

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 © 2009 Oracle Corporation Download from OTN

Latest APEX Features • Forms Conversion [3. 2] – Enables the loading of Oracle

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 11 g differentiator (Application Development framework) • Large and

Oracle Application Express • Oracle 11 g 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

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, Ask. Tom, Think. Quest • APEX is not here to stay • APEX 3. 2 represents the 8 th major release since 2004 • Integrated into Oracle 11 g. R 1 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 ©

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

D E M O N S T R A T I O N Rapid Application Development © 2009 Oracle Corporation

Q& A © 2009 Oracle Corporation

Q& A © 2009 Oracle Corporation

© 2009 Oracle Corporation

© 2009 Oracle Corporation