Rich Web App Development using Oracle & AJAX

1. Rich Web App Development using Oracle & AJAX Presented By: John Krahulec WebEx Demonstration September 9, 2009

2. Agenda • Company Overview • Features Overview • Install & Configure • Demo Application

3. Company Overview • Who we are Headquartered in Reston, Virginia Spun off from a consulting services practice in 2008 Oracle Database Experts Oracle DBAs PL/SQL Developers Web UI Specialists Featured in IOUG SELECT Magazine Presented at local, regional & national conferences

4. Company Overview • Who we are • How it started Problems We Noticed Constantly changing UI and middle-tier languages Increased complexity of architectures Decreased use of Oracle database features Solution We Chose Disruptive Approach using Stable Technology

5. Company Overview • Who we are • How it started • Implementations Cyber Security Management System Campaign Management, Marketing Intelligence and Data Warehouse FAA/DHS/SecretService/NORAD - SkyWatch FAA/DoD - Military Operations Special Use Airspace Scheduling SMB ERP, Sales Pipeline, Intranet

6. Features • PL/SQL based APIs for HTML, AJAX and FLASH • Apps work in Firefox, IE, Safari, etc • Development Toolkit & Framework • Application Platform • Social Enterprise features • View TURBOKit to “see” individual components

7. Benefits • Begin developing immediately • No need to build complex architectures, add expensive hardware or recruit hard-to-find, expensive talent • With shrinking and overworked IT staff, businesses can't expect to have experts in every technology. Do more with less

8. TURBOKit Demo

9. Architecture Overview Oracle HTTP Server or OAS with mod_plsql LOGIN OPS DATA ORACLE GUI

10. 1) Install Oracle Database Install 2) Install Oracle HTTP Server (with mod_plsql) 3) Install TURBOEnterprise

11. Virtualn-Tier Architecture (Patent Pending) TURBO TURBO_GUI TURBO_DATA TURBO_OPS Purpose: Contains non-customizable core TURBO objects. TURBO source code is encrypted to protect the intellectual property Application APP_USER APP_WEB APP_DATA APP_ETL Purpose: Contains applications built using TURBO Build all apps in this layer or create additional layers for functional areas (i.e. HR, Sales, etc) Login GUI Data Operational Database schemas xxxx Purpose: Rendering packages for creating the graphical user interface in the web browser. Purpose: Database login via Oracle Apache. Purpose: Database tables and the packages to handle DML actions against the tables. Purpose: Specialized data processing. Layers: Vertical – virtual tier Horizontal – core/custom/app

12. TURBO Install Demo

13. 1) Copy HTDOCS folder to your Apache server Configure Oracle HTTP Server 2) Modify httpd.conf for security # Override default error documents ErrorDocument 400 /turbo/te_pages.p_error?i_code=400 ErrorDocument 401 /turbo/te_pages.p_error?i_code=401 ErrorDocument 402 /turbo/te_pages.p_error?i_code=402 ErrorDocument 403 /turbo/te_pages.p_error?i_code=403 ErrorDocument 404 /turbo/te_pages.p_error?i_code=404 ErrorDocument 405 /turbo/te_pages.p_error?i_code=405 ErrorDocument 406 /turbo/te_pages.p_error?i_code=406 ErrorDocument 407 /turbo/te_pages.p_error?i_code=407 ErrorDocument 408 /turbo/te_pages.p_error?i_code=408 ErrorDocument 409 /turbo/te_pages.p_error?i_code=409 ErrorDocument 410 /turbo/te_pages.p_error?i_code=410 ErrorDocument 411 /turbo/te_pages.p_error?i_code=411 ErrorDocument 412 /turbo/te_pages.p_error?i_code=412 ErrorDocument 413 /turbo/te_pages.p_error?i_code=413 ErrorDocument 414 /turbo/te_pages.p_error?i_code=414 ErrorDocument 415 /turbo/te_pages.p_error?i_code=415 # Security Lockdown ServerTokens Prod ServerSignature Off

14. 1) Copy HTDOCS folder to your Apache server Configure Oracle HTTP Server 2) Modify httpd.conf for security <Location /turbo>  SetHandler pls_handler  Order deny,allow  Allow from all  AllowOverride None  PlsqlDatabaseUsername         app_user  PlsqlDatabasePassword         app_user_password  PlsqlDatabaseConnectString   HOST:PORT:SERVICE_NAME PlsqlAuthenticationMode       CustomOwa  PlsqlSessionStateManagement   StatelessWithFastResetPackageState  PlsqlExclusionList            sys.*, dbms_.*, utl_.*,owa_.*, owa.*, htp.*,  htf.*  PlsqlDefaultPage               te_pages.p_home  PlsqlDocumentTablename     turbo_data.global_documents  PlsqlDocumentProcedure      turbo_data.te_docload.process_download  PlsqlDocumentPath              docs PlsqlNLSLanguage              American_America.WE8ISO8859P1   PlsqlErrorStyle                ApacheStyle </Location> 3) Modify dads.conf

15. 1) Copy HTDOCS folder to your Apache server Configure Oracle HTTP Server 2) Modify httpd.conf for security 3) Modify dads.conf 4) Restart Apache HTTP listener

16. Verify TURBO Install

17. 1) Install Oracle Database Install 2) Install Oracle HTTP Server (with mod_plsql) 3) Install TURBOEnterprise

18. Company Name, Address, Logo Configure TURBO Password Policies SetupUsers Logo Name & Address

19. Demo Rich Web Apps from the ORACLE database

20. Leverage Oracle features for scalability and performance Technical Benefits • Build Enterprise-class Rich Web Apps right out of the database using existing skills and infrastructure • AJAX and Flash stored in the database • Just use PL/SQL to call the APIs to build RWA components • Authenticated AJAX calls from browser to database • Flexible and open standard for customization and third party tool integration

21. Value Proposition For Developers… TURBOEnterprise offers an environment in which you can quickly create Rich Web Applications using the Oracle PL/SQL skills you already have.

22. Value Proposition For Managers… TURBOEnterprise allows you to provide more for your customers with your existing resources. TURBOEnterprise runs inside your existing Oracle database, so you already have all the hardware, OS, and database ready to go.

23. Value Proposition For End Users… TURBOEnterprise gives you what you've come to expect from other consumer web sites, but for the Enterprise…Web 2.0 functionality, great looks, intuitive design, minimal training, etc. Youget all those features when you surf the web. Now you can have it at work too.

24. We can provide personalized sessions We can help get you started

25. Questions and Answers

26. Contact Information John Krahulec Executive VP & COO 703-889-8430 John.Krahulec@TURBO-enterprise.com Mark Eddy Account Executive 703-889-8452 Mark.Eddy@TURBO-enterprise.com