Appeon 2.1 PowerBuilder® Edition

1. Appeon 2.1 PowerBuilder® Edition • Rex Geissler • Principal Systems Consultant • Liaison for eBD Product Management • Sybase, Inc. • Rex.Geissler@sybase.com

2. Appeon Overview Moving PowerBuilder Applications to the Web In 3 Easy Steps…

3. Takes many PowerBuilder Applications and moves the application to n-tier while preserving the original UI Converts most PB objects to HTML, JavaScript, Servlets, and XML Convert apps to web in days vs. other technology’s years or months Plug-in to PB IDE to leverage existing skill set Appeon PB to Web ConversionAppeon PowerBuilder Edition

4. Appeon PB to Web Conversion SuiteUser Interface Before & After Migration Client/Server UI HTML UI for Standard MS Browsers • Complex; Interactive; Stateful & Stateless • HTML based – No Java Applet, ActiveX, Browser Plug-in, or client download Complex; Interactive; Stateful

5. Demonstrate PowerBuilder PBDemo Client/Server Application noting GUI MDI characteristics and features Demonstrate Appeon/EAServer PBDemo Web Application noting GUI MDI characteristics and features Appeon PB to Web Conversion

6. Traditionally, in order to move a PowerBuilder application onto the Web, additional code is written to rewrite every single PB Window and some DataWindows one at a time. Such “piece by piece” methodology means that your Web projects will take months or years to complete However, with the Appeon Web Conversion Suite, entire PowerBuilder applications can be moved to the web in a few days or a few hours, following three easy steps … Appeon PB to Web Conversion

7. 3 Easy Steps… 1) Remove or rewrite unsupported Web Features 2) Preview HTML versions of PowerBuilder objects and modify PowerBuilder GUI if necessary 3) Deploy the entire PowerBuilder application to the Web, at the push of a button! Appeon PB to Web Conversion

8. Multiple Document Interface (MDI) and Single Document Interface (SDI) ·    Menu objects and Toolbars Window objects for all window types: Child, Main, MDI, Popup, and Response windows All core PowerBuilder visual controls including CheckBox, CommandButton, DataWindow, DropDownListBox, DropDownPictureListBox, EditMask, Graph, GroupBox, Line, ListBox, ListView, MultiLineEdit, Picture, PictureButton, PictureListBox, RadioButton, Rectangle, SingleLineEdit, StaticText, Tab Folder, and TreeView Tabular, Freeform, Grid, Nested, Graph, Label, N-Up, Group, Composite and Crosstab DataWindows in HTML All DataWindow column style types except Edit Mask: Edit, CheckBox, DropDownDataWindow, DropDownListBox, and RadioButtons All DataWindow controls except OLE for Nested, Graph, Label, N-Up, Group, Composite and Crosstab DataWindows Column and Text DataWindow controls for Tabular, Freeform, and Grid DataWindows DataWindow printing (from Adobe PDF format) Standard Visual Objects Custom Visual Objects Custom Class Non Visual Objects (NVO) Many embedded SQL statements Most common PowerScript statements Vast majority of important and commonly-used system and user events, system and user functions, and system and user properties Object Oriented programming - including inheritance, encapsulation, polymorphism, function overloading and overriding PFC support coming soon PowerBuilder Supported Features by Appeon

9. PowerBuilder has thousands of features, many of which are not commonly used or relevant to a Web-based application. Some of these features will be incorporated into future releases of the Appeon PowerBuilderEdition The primary PowerBuilder features not currently supported include: Drag n' Drop functionality Least commonly used System Objects, Controls, Events, Functions, and Properties External objects and functions OLE objects and controls Windows API calls (unless the middle tier is Windows-based and the API calls are not specific to the current user since the Windows API calls may be added to EAServer through C DLL Components) GOTO and other uncommon PowerScript statement For more information see: http://www.appeon.net/product/faq.html PB Features Not Currently Supported by Appeon

10. Step 1 - Analyze Remove unsupported features not practical for the Web.

11. Snapshot - Analyze

12. Snapshot - Analyzing

13. Snapshot – Unsupported Feature Report

14. Step 2 – Preview HTML Preview, within the PowerBuilder IDE extended with the Appeon Developer, all the visual objects of the PB applications in HTML through a standard Microsoft IE browser, without writing a single line of HTML, XML, JavaScript, Java, or .NET code.

15. Snapshot – Preview HTML Preview HTML versions of entire windows within PowerBuilder

16. Web Window Preview

17. Snapshot – Preview PDF Preview PDF versions of DataWindows within PowerBuilder

18. Snapshot – View PDF of a report

19. Snapshot – Preview GIF Preview GIF versions of Graphic DataWindows within PowerBuilder

20. Snapshot – View graphical DW as GIF

21. Snapshot – Preview HTML of DW Preview HTML versions of DataWindows within PowerBuilder

22. Snapshot – View of DW in HTML

23. Step 3 – Deploy to Web Deploy from the PowerBuilder IDE, by pushing the “Deploy” button. Now a bona fide web application that is a precise replica of the PB application has been created and deployed.

24. Snapshot – “press button”

25. Snapshot – Application Deployment Wizard

26. Snapshot – Done Transferring Web files

27. Snapshot - Finished

28. CONGRATULATIONS!! Now a bona fide web application that is a precise replica of the PB application has been created and deployed. Your original Fat Client PB Application…

29. Snapshot - Before

30. CONGRATULATIONS!! has been transformed into an N-tier Web Application that looks like this…

31. Snapshot - After

32. Enables the entire PB-to-Web conversion process to be executed within the PowerBuilder IDE Requires only PowerBuilder skills for application conversion, deployment, maintenance and upgrade Offers the most graphical, user-friendly UI on the Web in HTML and standard IE browser, which is virtually identical to the UI of the original PB application Does not require the programmer to write a single line of HTML, XML, JavaScript, Java, or .NET code Appeon Web Conversion Suite

33. Demonstrate adding a Close button with PowerScript Close(Parent) to Master/Detail w_master_detail window Demonstrate running the Appeon Web Conversion Process Demonstrate the new Appeon Master/Detail Web Application with the added Close button and test the PowerScript running behind the button Appeon PB to Web Conversion

34. Appeon DeveloperAn extension to PowerBuilder that enables the Web conversion and application maintenance to be executed within the PowerBuilder IDE. Appeon Web LibraryThe run-time environment that supports a PowerBuilder-style GUI within standard Microsoft Web browsers. Appeon ServerEAServer components that provide run-time services for the deployed Web application, such as database connectivity, transaction management, printing, and security. What’s under the covers?

35. The Conversion Methodology

36. Appeon EAServer Architecture

37. <% // this JSP can be used to wrap any standard web application // set the url value here to point to that application // String url = "http://157.133.40.207:8080/pbdemo/"; // String url = "http://rgeissle-pc.sybase.com:8080/masterdetail/"; String url = "http://rgeissle-pc.sybase.com:8080/pbdemo/"; %> <html> <head> <title>Redirector Portlet</title> <noscript> <%-- JavaScript disabled fail-safe --%> <meta HTTP-EQUIV="refresh" CONTENT="0;URL=<%=url%>" /> </noscript> </head> <body onLoad="document.forms['loginform'].submit();" > <form name="loginform" method="get" action="<%=url%>"></form> </body> </html> Running Appeon Web Apps in EPTry using a JSP Wrapper

38. Build, maintain and upgrade with PB Deploy to client/server and/or Web at the push of a button Customers continue enhancing the application in what they know - client/server PowerBuilder - while avoiding the complexities of the n-tier architecture and Web technologies. As such, the solution is intended to be a black box and all development work is done in PowerBuilder. Appeon Strategy

39. Client PC Microsoft Internet Explorer 5.5 or above Microsoft Windows 98 or above Adobe Acrobat Reader 4.0 or above for printing reports Developer PC Sybase PowerBuilder 8.0.2 (Enterprise Edition) Sybase EAServer 4.1.3 (Free Developer Edition) Microsoft Windows NT 4.0 or Windows 2000 or Windows 98 connecting to EAServer on another machine Microsoft Internet Explorer 5.5 or above Adobe Acrobat 4.0 or above Deployment Server Sybase EAServer 4.1.3 (Advanced or Enterprise Edition) Microsoft Windows NT 4.0 or Windows 2000 Adobe Acrobat 4.0 or above System Specifications

40. What if you could turn those PB applications of yours into N-tier Web Applications running on the web at the click of a button just like you create Client/Server Applications? How much would that save you in deployment costs and maintenance of two tier apps? How much money would that save you re-writing code? How much time would that save you re-writing code? How much more revenue could you bring to your company by opening up those apps to the Intranet, Extranet, or Internet? So the business questions are…

41. Beta #1 – September 30th for interested companies with NDA Beta #2 – For Beta #1 companies and selected Sybase internal Appeon 2.1 PowerBuilder® Edition Demonstration Software – October 24-25 at 2002 Sybase Asia Pacific User Conference in Beijing, China PFC Support – Q1 2003 PB 9.0 support shortly after PB 9.0 (GA) Appeon PowerBuilder Edition Plan

42. See www.appeon.net FAQ - http://www.appeon.net/product/faq.html Contact Omkhar Bhongir or Jeremy Scheffel or Rex Geissler More Information

43. Statements in this presentation concerning future prospects, business outlook, operating results, and product availability are forward looking statements that involve a number of uncertainties and risks. Factors that could cause actual events or results to differ materially include: sales productivity; possible disruptive effects of organizational changes; shifts in customer demand; perceptions of the Company and its prospects; technological changes; competitive factors; unanticipated delays in scheduled product availability dates; general business conditions; and other factors described in the Company's most recent Annual Report on Form 10-K. Sybase, Inc. F O R W A R D L O O K I N G S T A T E M E N T S “Sybase PowerDesigner, Adaptive Server, PowerBuilder, Replication Server, Direct Connect, Enterprise Connect, DataWindow, PowerJ, and Everything Works Better When Everything Works Together are trademarks or registered trademarks of Sybase, Inc. Financial Fusion is a registered trademark of Financial Fusion, Inc. Java and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. Other trademarks, product names or company names may be trademarks of the respective companies with which they are associated."