Appeon™ for PowerBuilder ® Taking PowerBuilder Applications to the Web

1. Appeon™ for PowerBuilder®Taking PowerBuilder Applications to the Web

2. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Product Futures and Summary

3. PowerBuilder-to-the-Web Options • Complete Rewrite in Java/J2EE, HTML, and JavaScript • Complete Rewrite in .NET, HTML, and JavaScript • PowerBuilder and EAServer Only • PowerBuilder and EAServer with Partner/SPS Frameworks • PowerBuilder and Appeon

4. PowerBuilder-to-the-Web Options • Complete Rewrite in Java/J2EE, HTML, and JavaScript • Complete rewrite of everything taking months or years and costs a lot • Complete Rewrite in .NET, HTML, and JavaScript • Complete rewrite of everything taking months or years and costs a lot

5. PowerBuilder-to-the-Web Options • PowerBuilder and EAServer Only • Reuse all DataWindows (60-95% of avg. app) and all Business Logic NVOs (0-15% of avg. app) • Rewrite user interface and navigation with JSPs and JavaScript taking months and suggest Partner/SPS Framework/Help on first project

6. PowerBuilder-to-the-Web Options • PowerBuilder and EAServer with Partner/SPS Frameworks • Reuse all DataWindows (60-95% of avg. app) and all Business Logic NVOs (0-15% of avg. app) • Rewrite portions of every window or web page taking weeks or months

7. PowerBuilder-to-the-Web Options • PowerBuilder and Appeon • Reuse all Windows (50-70% of avg. app), all DataWindows (60-95% of avg. app), all Menus/Toolbars, all User Objects & NVOs (30-60% of avg. app), and most PowerScript code • Rewrite or remove any unsupported features taking as little as weeks or days

8. Solution Landscape 2003 PowerBuilder with EAServer Partner or SPS Framework UI Sophistication PowerBuilder with EAServer Only Slow, Complex, Costly Effort/Time/Cost to Market(Objects to the right take more time and more effort)

9. Creation of Thin Client withPowerBuilder and Appeon • Fastest possible creation of Web apps w/ RAD/4GL tool and Rich-Client GUI • Remove the need for Screen-scraping Emulation Servers • Citrix, Windows Terminal Server, etc. • Reduce the network bandwidth resources required for applications • More scalable solution • Truly thin client • Support Web Standards dictated by architecture groups in the Marketplace, Corporation, Division, or Department

10. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Overview • Configuration and Update • Development and Deployment Environment • Miscellaneous • Security, Performance, Load Balancing and Failover • Product Futures and Summary

11. Appeon™ for PowerBuilder®RAD/4GL GUI Web Rich-Client GUI in Thin-Client Web-Faster Development Over J2EE/.NET • Appeon runs from the PowerBuilder IDE to deploy the vast majority of Client/Server PowerBuilder application code into a true Web Browser application with the same GUI interface through the click of a button and some PowerBuilder work-arounds

12. Demo

13. Appeon Business Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Best ROI

14. Appeon Business Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • For Businesses: • Leverages Dozens or Hundreds of Man-years of Client/Server Investment for Web Applications & Enterprise Portals • Extends Applications to remote End Users for 24x7 productivity over the Internet • Improve cash flow and transaction throughput by moving apps to remote employees, partners and customers • Improved Customer Satisfaction

15. Appeon Business Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • For End Users: • Increase User Productivity (Practically identical GUI in Web as in Client/Server) • No Re-Training Expenses • No User Frustration with Appeon whereas legacy web applications promote weak HTML user interface

16. Appeon Business Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • For Developers: • Fastest Way to move PB code to the Web • Focus on Business Issues not N-Tier, Architectural, and Technology problems – this is why PB C/S popular • Increases Productivity Tremendously with 4GL/RAD IDE – many times faster J2EE & .NET • Low Risk With Time-Tested Code, GUI, & Business Logic • Leverage existing investment and maturity of Client-Server apps for Web Applications & Enterprise Portals

17. Appeon Technical Benefits Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Code and Maintain with straight-forward PowerBuilder C/S coding • Single PowerBuilder Code Base • Client Server (PowerBuilder) • Web (Appeon) • Mobile (Pocket PowerBuilder) • Requires No Special Coding • in HTML, JavaScript, JSP, EJB, J2EE, or .NET • No need to Re-architect, Re-design and Re-write Business Logic or Navigational GUI • Deploy to a true web architecture quickly

18. Appeon Database Support • Sybase ASE 12.x • Sybase ASA 7.x and 8.x • Oracle 8i and 9i • Microsoft SQL Server 2000 • IBM DB2 UDB 8.1 • Informix (used by customers but not certified)

19. Unsupported PowerBuilder Functionality • Two Types of Unsupported Features • Web Browser Limitations or Standards • Unsupported PowerBuilder Functionality

20. Unsupported PowerBuilder Functionality • Web Browser Limitations or Standards Examples: • No JavaScript GOTO • Security paradigm dictates no Client OS access • External Applications to the PowerBuilder Application (Browser sandbox security limits this support)

21. Unsupported PowerBuilder Functionality • Unsupported PowerBuilder Functionality • Appeon supports a tremendous amount today but just like your apps have deadlines and cutoffs, Appeon has to stop coding at some point for each release like 2.5, 2.6, 2.7, 3.0, etc. • Miscellaneous Properties and Functions in the thousands of PowerBuilder features - See the Appeon Migration Guide and Appeon Supported Features Guide • e.g: THROWS PowerScript Statements • e.g: BringToTop Property, RightToLeft Property, Other Event, etc. • Miscellaneous system functions and objects

22. Event Driven Architecture Database Connectivity …and a Rich GUI!!! Supported features too numerous to list. PowerBuilder Supported Features

23. Apache, EAServer, iPlanet, Microsoft IIS or Netscape MS Win2000 SP3 or NT 4.0 SP6 Appeon™ 2.6 for PowerBuilder®Architecture & System Requirements • Sybase PowerBuilder 8.0.3 (Enterprise Edition) • Microsoft Windows 2000 SP3 or NT SP6 • Connectivity to Sybase EAServer 4.2 (Developer, Advanced, or Enterprise Edition) • IE 5.5 SP2, IE 6.0 SP1 • Optional: Adobe Acrobat Reader 4.0 or 5.0 for printing DataWindows • Any of the following: • MS SQL Server 2000 • Oracle 8i or 9i • Sybase ASA • Sybase ASE • Appeon Server • Sybase ASA 7.0.4 or ASA 8.0.2 or above • MS Win 2000 or NT 4.0 • Optional: Adobe Acrobat 4.0 or 5.0 for printing DataWindows

24. Appeon Server Runtime Server Components Appeon Server 6 Patents Pending • The run-time environment that supports a PowerBuilder-style graphical user interface (GUI) in a standard browser

25. Appeon Server Runtime Server Components • No client downloads for Plug-ins, Java applets, Java Virtual Machines, Flash, or ActiveX! • Entire Web Page (GUI) and its composite files (e.g. XML, HTML, JPG, PDF, JavaScript, JScript, etc.) • Downloaded by a standard HTTP request • NOT through any applets

26. Appeon Server Runtime Server Components On the Server: • Java and PowerBuilder Components and Servlets • Provide run-time services for the deployed Web application • Database Connectivity & Pooling • DataWindows Support • PowerBuilder Virtual Machine (PBVM) support • Transaction Management • Security • Printing

27. Appeon Server Runtime Server Components On the Server: • Stateless components for excellent N-Tier performance • Uses only web standards with HTML, XML, JavaScript, LDAP, and Web Security • Appeon removes printing issues with Adobe Acrobat PDF

28. Appeon at Runtime On the CLIENT: Appeon Web HTML, JavaScript, and XML files… • Cached on the client permanently • Except for Result Set XML • Not downloaded again unless there are enhancements at the server • Minimizes round-trips • Very little network bandwidth is used.

29. Appeon at Runtime • DataWindow result sets can also be cached locally for any length of time • Configured in Appeon Enterprise Manager • Extremely helpful for caching Code/Reference Tables • E.g.: DropDownDataWindows

30. Documentation Resources • Appeon Release Bulletin • Appeon Introduction Guide • Appeon Installation Guide • Appeon Developer User Guide • Appeon Demo Applications Tutorial • Appeon Enterprise Manager User Guide • Appeon Migration Guide • Appeon Supported Features Guide • Appeon What’s New Guide • Appeon Help File

31. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Overview • Configuration and Update • Development and Deployment Environment • Miscellaneous • Security, Performance, Load Balancing and Failover • Product Futures and Summary

32. Appeon Developer

33. Appeon Developer Toolbar • PowerBuilder IDE GUI Toolbar • Easy Wizard and Property Sheet Driven Dialog Windows • No Appeon Coding • PowerBuilder to Web Previews • Configure Web Application & Appeon Server Environment • Deploy Web Application • Run Web Application • Undeploy Web Application • DataWindow Repository (Automatic Reporting & Update Web Application) • AEM (Appeon Enterprise Manager) • Appeon Help

34. Demo • Getting around the Appeon Developer Toolbar. • Modify your web application • Deploy your modified web application. • Run the modified web application.

35. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Overview • Configuration and Update • Development and Deployment Environment • Miscellaneous • Security, Performance, Load Balancing and Failover • Product Futures and Summary

36. Step 1 – Analyze Appeon scans the entire PowerBuilder application, flagging any Web browser or Appeon unsupported incompatibilities found Three Steps to the WebExisting OR NEW Applications Convert Apps to Web – 100s or 1000s times faster dev than J2EE/.NET • Step 2 – Modify & Test • Rewrite or remove any unsupported PB features or code using standard PB programming • Test in PB IDE • Step 3 – Deploy • Click Appeon Wizard • Choose Deployment Profile (Local, Dev, Test/QA, Prod) • Choose Deployment Mode (Full, Incremental, Previous) • Auto-Create HTML, XML, and JavaScript

37. Appeon Deployment Process Button • Exports PowerBuilder objects into source code • Converts PowerBuilder source code into standard Unicode source code • Converts Unicode source code into XML files • Analyzes XML files for any unsupported features • Converts XML files into HTML, XML and JavaScript files • JavaScript has a 1-1 mapping with PowerScript statements as well as object and control properties • Compresses the files if desired • Deploys all Web Application files to the Appeon Server environments

38. Appeon Enterprise Manager (AEM)

39. Appeon Enterprise Manager (AEM) • A Web-based application • Manages the transformed Web applications and the Appeon Server • over the Internet • an Intranet • or an extranet • Includes a comprehensive set of easy-to-use tools for: • System configuration • System maintenance • Performance optimization.

40. Demo - Appeon Enterprise Manager

41. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Overview • Configuration and Update • Development and Deployment Environment • Miscellaneous • Security, Performance, Load Balancing and Failover • Product Futures and Summary

42. Security • Firewall Security • HTTP over Port 80 so Appeon can take advantage of Firewalls and does not propose a security threat • Authentication Security • LDAP Authentication Security – Applications, Groups, and Users • Appeon Authentication Security – Applications, Groups, and Users • SSL (HTTPS) Encryption Security • Digital Certificates Security

43. Security • Database Role Security • Application Timeout Security • Direct URLs Security • Built-in PowerBuilder Application Security • Business Logic Encryption Feature Security • Protects customer’s intellectual property and hacking

44. AppeonPerformance Example • DataWindow Result Set Data XML Files Size • Depends on the result set size being retrieved from the database • Retrieves 9,000 rows of data • Four columns • Converts them to XML • Downloads in about 3-4 seconds • Additional Download Size/Time • Adding many columns, edit masks, DDDW will slow it down

45. AS WS WS/AS WS WS/AS AS AS AS Load Balancing and High Availability • Appeon Server Supports load balancing and fail over Clients Production Appeon Server Farm Production Web Server Farm A Development Test B C D

46. Today’s Agenda • Current Options to the Web • Appeon™ for PowerBuilder® • Product Futures and Summary

47. Appeon™ for PowerBuilder®The Next Step - Portal Sybase Enterprise Portal

48. Appeon 2.7 Feature HighlightsBeta Under Way Now! Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • Enterprise Portal Portlet Support • Increase Deployment Performance Enhancements • Increase Overall Runtime Performance Enhancements • Several times faster for DataWindow retrieves

49. Appeon 2.7 Feature Highlights Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE N-Tier Server-side Integration… • Connectivity to Java/EJB, PB NVO, C/C++ DLL, COM/ActiveX Components on Application Servers • DataWindow Set/GetFullState & Set/GetChanges for Dynamic DataWindows, etc. via XML • Connectivity to Web Services • Connectivity to Messaging Queues (MQSeries, JMS, etc.) • PowerBuilder Non-Visual Object (NVO) Component Support • No Web Browser or Appeon limitations on PowerBuilder NVO code running inside Appeon Server

50. Appeon 2.7 Feature Highlights Rich-Client GUI in Thin-Client Browser with Fastest 4GL/RAD Dev IDE • PFC Support • Certified to 5 levels and tested to 10 levels of inheritance • DataWindow Result Set Compression • Custom Popup Menus • JavaScript Runtime Debug Log