Title: Arial 28pt.

1
PWB502 Appeon for PowerBuilder Technical Overview
Rex GeisslerSybase Appeon Product
ArchitectRex.Geissler_at_sybase.com /
303-409-7887 August 15 19, 2004
2
The Enterprise. Unwired.
3
The Enterprise. Unwired.
Industry and Cross Platform Solutions
Unwire People
Unwire Information
Manage Information

• Adaptive Server Enterprise
• Adaptive Server Anywhere
• Sybase IQ
• Dynamic Archive
• Dynamic ODS
• Replication Server / Conn.
• OpenSwitch
• Mirror Activator
• PowerDesigner
• Appeon for PowerBuilder
• EAServer
• Industry Warehouse Studio

• Unwired Accelerator
• Unwired Orchestrator
• Unwired Toolkit
• Enterprise Portal
• Real Time Data Services

• SQL Anywhere Studio
• M-Business Anywhere
• Pylon Family (Mobile Email)
• Mobile Sales
• XcelleNet Frontline Solutions
• PocketBuilder
• PowerBuilder Family
• AvantGo

Sybase Workspace
4
Sybase Leadership 24 Straight Quarters Profit

• Design, Development, Mobile Wireless
• 1 Design Modeling
• 1 Client/Server, Web, and PocketPC Development
• 1 Mobile Middleware
• 1 Mobile Database 73 Market Share
• 1 Wireless Portal (MyAvantGo)
• Integration
• 1 Largest B2B Portal in the U.S.
• 1 Selected/Evaluated Vendor for HIPAA Compliance
• 1 Online Banking Solution For Tier 1 Banks
• Database
• 1 Linux Database
• 1 Data Modeling
• 1 Data Warehouse 100 times faster, compressing
  not exploding data
• 1 Production Database on Wall Street handling
  more than half of trades
• 1 Mobile Database 73 Market Share
• 1 Telco (42) and Transportation (36) Database
  in China

Recognized Sybase iAnywhere Solutions as the
leader in mobile middleware technology with
higher revenues and market share than nearly 20
competitors. The company with the strongest
financial and marketing muscle -IDC Report,
July, 2003
5
How do I get to the Web in the Fastest Way?

• Appeon for PowerBuilder Transforms a high
  percentage (usually 85-98) of entire
  PowerBuilder Client/Server existing apps or 100
  of new PowerBuilder applications into N-Tier Web
  apps, automatically
• Offers same Rich-Client GUI in standard IE Web
  Browser (97 users)
• Enables developers to begin building NEW Web
  applications overnight (using only 4GL/RAD
  PowerBuilder) and with unparalleled productivity

6
Appeon for PowerBuilder - RAD/4GL GUI Web
Rich-Client GUI in Thin-Client Web Faster
Development Over J2EE/.NET
7
Appeon for PowerBuilder - The Next Step - Portal
Sybase Enterprise Portal
8
Appeon for PowerBuilder - RAD/4GL GUI Web
Rich-Client GUI in Thin-Client Browser with
Fastest 4GL/RAD Dev IDE

• Test Appeon web apps at http//www.trysybase.com
• Demo Appeon end user web applications and the
  power of the Rich-Client, Event-Driven GUI
  Architecture in a Thin-Client Web Browser

9
Pet World Lines Of Code Study For New
DevelopmentFaster New Development Than J2EE or
.NET Tools http//www.appeon.net/petworld/
http//www.trysybase.com

1. How many more mistakes would be made in coding?
2. How much longer would debugging take?
3. How much longer would routine maintenance take?
4. How much longer would enhancements take?
5. How much longer would rewriting business logic
   take?
6. How much extra ROI would there be for existing
   code?
7. How much more user friendly apps and productive
   would users be?

10
Future-Proofing Your Investments

• Future-proof your investments with Sybase/Appeon
• Architecture - Powered by an infrastructure that
  uses only industry standards and integrates with
  leading platforms, including .NET/J2EE Web
  Services
• Project - Deploy one project to all
  platforms/devices instead of having the expense
  and risk of 3 projects
• Developers - Unbeatable PowerBuilder Productivity
  for Web, Mobile, and Client/Server development
• Users - Incomparable Rich Client GUI that
  promotes end user productivity
• Why end up stranded like the Visual Basic
  community or the Java Swing community?

11
Single PB Project with 3 Deployment Options
No other development platform in the world,
including .NET and J2EE, will allow you to build
business applications that are device and
technology agnostic except for PowerBuilder. 1
App, 1 Project, 3 Deployment Solutions
PowerBuilderProject
Develop, deploy, and maintain all in PowerBuilder
IDE using only PowerBuilder skills
Client/Server
Web
Mobile
12
Future-proof Your Investments

• No other development platform in the world
  outside PowerBuilder, including VS.NET and
  traditional J2EE tools, empower enterprises to
  build applications that are device and technology
  agnostic.

1 Skill, 1 IDE, 1 Project
Web
Mobile
Desktop
Smart Phones
J2EE
.NET
Windows
PocketPC
13
PowerDesigner Design LifecycleLeading Market
Share 39
Design, Reverse Engineer, Synchronize, Document
PowerBuilder Today
BusinessProcess Models (BPM)
ebXML BPEL4WS

• - Business Logic
• Use Case Scenarios
• Class Diagrams
• Sequence Diagrams
• Activity Diagrams
• Component Diagrams
• All UML Diagrams

Object-Oriented Model (OOM)

• Java Code
• PowerBuilder Code
• XML DTD, Schema, IDL, BizTalk Source

Java, PowerBuilder, XML, C, VB, C, CORBA,
Analysis, EJB, or create another language
Conceptual Data Model (CDM)

• - Data Structures
• Business Rules

• - Schema Definition
• - Denormalization
• - Optimization (Indexing)
• Database Creation
• Database Size Estimation
• Test Data Generation
• Database/Data Warehouse Modeling

Physical Data Model (PDM) 45 Data Sources
Forward Engineering
Reverse Engineering
ODBC
Database Management System (DBMS)
Database SQL Script
14
Transform the Entire Enterprise

• Applications Automatically convert existing
  PowerBuilder applications to n-tier Web
  applications in just weeks or months.
• Developers Instantly begin building n-tier Web
  applications using only PowerBuilder skills, at a
  speed that is 420 times faster than J2EE/.NET
• End-users Productively work with the worlds
  richest HTML user interface available on the Web

15
Appeon Business Benefits

• For Businesses
• Leverages Dozens or Hundreds of Man-years of
  Investments for Web Applications Enterprise
  Portals
• Improved Customer Satisfaction
• For End Users
• Increase User Productivity (Almost identical GUI
  in Web as Client/Server)
• No Re-Training Expenses
• No User Frustration with Appeon vs. dumb GUI
  legacy web applications
• For Developers
• Focus on Business Issues not N-Tier,
  Architectural, and Technology problems this is
  why PB C/S became so popular
• Fastest Way to move PB code to the Web and with
  5-10 times less code
• Increases Productivity Tremendously Experience
  with 4GL/RAD IDE
• Standard for all new web application development
  for many customers
• Low Risk With Time-Tested Code, GUI, Business
  Logic
• Automatically Deploy apps as Enterprise Portal
  Portlets

16
Appeon Technical Benefits
"Less than 10 of developers worldwide possess
the ability to code to the appropriate level for
J2EE," BEAs Willis concedes the difficulty of
coding Java.

• ROI Reuse with PowerBuilder objects, PowerScript
  code, Event-driven architecture, OOP, and
  embedded SQL
• C/S Coding by coding and maintenance with
  straight-forward PowerBuilder C/S
• Single Code Base possible for both C/S and Web
  with IsWeb f(x) type function that Appeon
  provides
• No Coding in HTML, JavaScript, JSP, EJB, J2EE, or
  .NET
• No need to Re-architect, Re-design and Re-write
  Navigational GUI or to learn new languages, IDEs,
  or Specifications
• Rich, smart client GUI minimizes network/server
  usage for scalability
• Automatic Point Click Features added to all
  Appeon web application DataWindows (Adobe Acrobat
  PDF, Microsoft Excel, HTML, Text files,
  Filtering, Sorting, and Find records)

17
Enhance the PowerBuilder Platform

• Appeon Developer deploys PowerBuilder
  applications to the Web using only PowerBuilder
  skills and IDE.
• Appeon Server provides run-time services and
  J2EE support to deployed Web applications
• AEM manages deployed Web applications and
  Appeon Server over LAN or Web

18
Appeon Developer in PowerBuilder IDE
19
Preserve PowerBuilder UI on the Web

• Appeon Web applications precisely replicate the
  source PB application, offering a rich HTML UI
  that is generations ahead of JSP and ASP.NET.

Web
Click n Deploy
PowerBuilder
20
Three Steps to the Web for Fastest New
Applications
Build Apps Sell Worldwide Faster Development
than J2EE/.NET

• Step 1 Develop
• Fastest creation of web app via new PowerBuilder
  Client/Server Windows and DataWindows using
  Appeon supported features

• Step 3 Deploy
• Click Appeon Wizard
• Auto-Creates Web files HTML, XML, and JavaScript
• Deploys Web files, DataWindows, Embedded SQL, and
  N-Tier NVOs to Appeon Server

• Step 2 Test
• Test PowerBuilder application in the PowerBuilder
  IDE

21
Three Steps to the Web for Existing Applications
Convert Apps to Web 100s of times faster dev
than J2EE/.NET rewrite

• Step 1 Analyze
• Appeon wizard studies the entire PowerBuilder
  application, flagging any unsupported features
  found and any heavy windows

• Step 2 Modify Test
• Rewrite desired unsupported features and heavy
  windows using standard PB programming
• Test in PB IDE

• Step 3 Deploy
• Click Appeon Wizard
• Auto-Creates Web files HTML, XML, and JavaScript
• Deploys Web files, DataWindows, Embedded SQL, and
  N-Tier NVOs to Appeon Server

22
Appeon for PowerBuilder Solution
Appeon for PowerBuilder can generate an n-tier
Web application that is an exact replica of the
4GL client/server application, but with HTML user
interface automatically
23
Unsupported Features In Web Browsers and Appeon

• Two Types of Unsupported Features
• Web Browser Limitations or Standards (i.e. No
  JavaScript GOTO, BLOB data type, Security
  paradigm dictates no Client OS access without
  optional secure Appeon ActiveX control, etc.)
• Appeon Unsupported Features (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, 2.8 AE, 2.8 EE, 2.9, 3.0, etc.)
• Miscellaneous Properties and Functions in the
  thousands of PowerBuilder features See the
  Appeon Migration Guide and Appeon Supported
  Features Guide
• Some unsupported features are not critical so
  focus on just the business critical features
• i.e. GOTO, THROWS PowerScript Statements
• i.e. Checkbox Control - BringToTop Property,
  RightToLeft Property, Other Event, etc.
• i.e. Dynamic SQL Format 4
• Miscellaneous system functions, objects, and
  events

24
Working Around Unsupported Features

• In most situations, there is no need to give up
  functionality
• Rework most business logic or non-visual code
  with NVO
• PowerBuilder code can be written in many ways
• Many times you can achieve same business
  objective even with different implementation
• Popular workarounds have been documented by
  Appeon, especially in the Appeon Migration Guide
  and Appeon Troubleshooting Guide
• Note that many unsupported features are not
  critical

25
Performance Tuning for the Web

• The Web is a slower environment than
  client/server with Windows API, so some
  applications and specific windows will require
  some performance tuning
• Weight of the window is heavy
• Amount of data being retrieved/displayed in the
  window is excessive
• Complex logic is executed at the client and not
  the server
• The straight forward steps to performance tuning
• Study the Appeon Performance Tuning Guide
• Use Appeon tools - Heavy Windows Report (i.e.
  Lots of DataWindows on a window) and Runtime
  Performance Tracing (study any events and
  functions that may need performance tuning)
• Reduce high number of rows and complex DataWindow
  column types for DataWindow Retrieves
• Reduce overhead including global functions and
  heavy frameworks
• Perform standard PowerBuilder programming to
  address the performance issue

26
Maintenance Process

• Appeon introduces no changes into your current
  maintenance process, simplifying your life
• All development done using PowerBuilder skills
  and in the PowerBuilder IDE only
• You preserve your existing well-understood code
  base
• Only one code base needs to be maintained for
  both Web and client/server deployment
• All existing PowerBuilder debugging tools
  continue to be used

27
PowerBuilder Supported Features

• Architectures MDI, SDI
• PowerBuilder Library (PBL) Objects
• Application, Custom Class Non-Visual (NVO),
  Custom Visual User Object, DataStore (Non-Visual
  DataWindow), DataWindow, Function, Menu/Toolbar,
  OLEObject, Standard Visual User Object,
  Structure, Window
• Dynamic Tab Pages (Enterprise Edition)
• OpenTab, OpenTabWithParm, CloseTab functions, Key
  event
• Dynamic User Objects (Enterprise Edition)
• OpenUserObject, OpenUserObjectWithParm,
  CloseUserObject
• Hot Keys, Shortcut Keys, Accelerator Keys
  (Enterprise Edition)
• Window Types
• All window types Child, Main, MDI, MDIHelp,
  Popup, and Response windows
• Window Controls
• CheckBox, CommandButton, DataWindow,
  DropDownListBox, DropDownPictureListBox,
  EditMask, GroupBox, Line, ListBox, ListView,
  MultiLineEdit, Picture, PictureButton,
  PictureHyperLink, PictureListBox, Oval,
  RadioButton, Rectangle, RoundRectangle,
  SingleLineEdit, StaticHyperLink, StaticText, Tab
  Folder, TreeView, and User Object

28
DataWindow Is The Power In PowerBuilder
DataWindows Comprise 70-90 Of Existing New
PowerBuilder Apps

• DataWindow Presentation Styles
• Composite, Crosstab, Freeform, Group, Graph,
  Grid, Nested, Label, N-Up, Tabular
• DataWindow Bands
• Header, Detail, Group (Report PDF), Footer
  Summary
• DataWindow Buffers
• Primary, Filter, Delete, every item status
• DataWindow Column Style Types
• Edit Mask, Format Style, Edit, CheckBox,
  DropDownDataWindow, DropDownListBox, and
  RadioButton
• DataWindow Controls
• Button, Column including Computed Column,
  Computed Field, GroupBox, Picture, Rectangle,
  RoundRectangle, Text
• DataWindow Data Sources
• SQL, Query, Stored Procedure, External

29
DataWindow Is The Power In PowerBuilder
DataWindows Comprise 70-90 Of Existing
Applications

• DataWindow Child
• GetChild function with almost all DataWindow
  manipulation functions
• DataWindow Dot Notation
• DataWindow Expressions Operators
• DataWindow Functions
• ShareData, Describe, Modify, RowsCopy, RowsMove,
  ImportFile, ImportString, Update and 80 other
  functions
• DataWindow Printing SaveAs Automatically (No
  Coding)
• Adobe Acrobat PDF, Microsoft Excel, HTML Text
• DataWindow Validation Rules

30
PowerScript Language Supported Features

• PowerScript Statements
• Reserved Words
• Pronouns (This, Parent, Super)
• Identifiers
• Operators Expressions
• ASCII Characters (n, t, etc.)
• Data Types Constants
• Arrays
• Null Values
• Statement Continuation/Separation
• Comments
• OOP Inheritance, Encapsulation, Polymorphism

• System Events Functions
• User Defined Events Functions
• Global and Object Events Functions
• Triggering Posting Events
• Static Calls to Events Functions
• Dynamic Calls to Events Functions
• Extending, Overriding, and Overloading Events
  Functions
• Arguments Return Values
• Structures
• Embedded SQL
• Dynamic SQL
• Transaction Management Statements
• Cursor Statements
• Database Stored Procedures

31
Extensive J2EE Integration Support

• Server-side Integration for N-Tier NVOs
• Rework unsupported features non-visual in nature
• Connectivity to Java/EJB, PB NVO, C/C DLL,
  COM/ActiveX components and Web Services
• Connectivity to Messaging Queues (MQSeries, JMS,
  etc.)
• Client-side Integration for DLLs, Run, INI Files,
  Registry
• Automatically Deploys INI and Registry to Appeon
  Server
• Supports Profile functions and Registry functions
• Supports client-side and server-side calls to
  DLLs
• Optional secure Appeon ActiveX supports client
  DLLs and Run PowerScript statement

32
PFC/ACF Application Deployment Process

• Appeon Compliant Framework (ACF) supports roughly
  85 of all PFC features and services including
  the most-used PFC features to begin development
• Swap the PFC.PBL ancestor framework layer with
  the Appeon Frameworks PFC.PBL
• PFC work-arounds documented and PFC code
  commented out
• Perform a PowerBuilder Full Build on the
  application
• Correct any errors that occur
• Go through the normal Appeon development process
• Look for Appeon unsupported features
• Provide work-arounds
• Test the application in PowerBuilder
• Deploy to the Web

33
Appeon Framework for PFC Features

• Appeon ACF Examples demo to highlight some of the
  many PFC features that Appeon supports
• Multiple inheritance levels and tested to 10
  levels
• PFC Naming Conventions Standards
• PFC Corporate Layer
• PFC Extension Layer
• PFC Windows
• PFC NVO Services
• PFC Standard Visual User Objects
• PFC DataWindow Services Features
• PFC Controls
• PFC Events
• PFC Functions
• PFC Structures

34
Appeon Languages in Unicode

• Languages for text in the Graphical User
  Interface (GUI) of the application and
  application data from the database
• English
• Simplified Chinese
• Traditional Chinese
• Japanese (including localized version for
  Japanese PB)
• Korean
• Other languages plan to be certified on future
  releases
• Customers are currently working with
  non-certified languages using French, Spanish,
  Italian, Greek, Hebrew and Russian today

35
Flexible Open J2EE, .NET, Web Services
Integration
Appeon Server
PowerBuilderNVOs DataWindows
XML/SOAP
Java EJB
Get/SetFullStateGet/SetChanges
External Function DLL
C/C DLLComponent/PBNI
MQSeries, TIBCO, Tuxedo, JMS, And Messaging World
Dynamically Create Files and Change URLs on
HyperlinkToURL, StaticHyperlink, PictureHyperlink
Web Services on Appeon Server, other Intranet
Servers, or Internet
36
Appeon Server N-Tier Server Side Integration

• Connectivity to Java/EJB, PB NVO, C/C DLL,
  COM/ActiveX Components on Application Servers
• DataWindow GetFullState/SetFullState
  GetChanges/SetChanges for N-Tier DataWindows,
  etc.
• Connectivity to Web Services, J2EE, and .NET
• Connectivity to Messaging Queues (MQSeries, JMS,
  etc.)
• Dynamically create files on Appeon Server (PDF,
  Graphic, etc.) and automatically link to them in
  the web application through HyperlinkToURL(),
  StaticHyperLink, or PictureHyperLink
• PowerBuilder Non-Visual Object (NVO) Component
  Support
• No Web Browser or Appeon limitations on
  PowerBuilder NVO code running inside Appeon
  Server and all the typical benefits of using NVOs

37
Appeon 2.7 Enhancements

• PowerBuilder 8 9 Support
• Window Controls PictureHyperLink,
  StaticHyperLink
• INI/TXT File Support Registry support
• Profile Functions ProfileString, ProfileInt,
  SetProfileString
• Enterprise Portal (EP) Portlet Support
• System Event Timer
• System Functions HyperLinkToURL, KeyDown,
  PopMenu, SetMicroHelp, SetFocus, SetPointer,
  Timer
• Dynamic SQL Format 3
• Window List added for MDI Support and
  ArrangeSheets function
• User Object Constructor and Destructor Events
• Custom Popup Menus
• Performance Enhancements
• Japanese Localization for only other Localized
  PowerBuilder version

38
Appeon 2.8 Performance Enhancements

• Runtime Performance
• 2-5 times faster for most windows to open and
  sometimes up to 10 times faster
• DataWindow 90 Result Set Compression, HTML, XML,
  and JavaScript all cached on browser
• Example below Sales App Demo -gt Order Viewer
  window (34 Window Controls with 5 DataWindows, 3
  UO Tab Pages, 1 Data-driven TreeView, 2 DDLB)
• 50 Increased Web Deployment Performance now
  getting on par with PowerBuilder compilation to
  Client/Server
• PFC Phase II Support for Development Production
  Deployment

39
Appeon 2.8 Other Features

• DataWindow ShareData ShareDataOff functions
• Dynamic Transaction Object to Connection changes
  via PowerScript
• User-defined Message Object
• Pass parameters into the Appeon Web Application
• Appeon PDFPrinter and PS to PDF Format Conversion
  for PDF printing
• Removes the need to purchase Adobe Acrobat
  license
• Package Wizard to automatically package your
  Appeon web app into an EXE and deploy remotely
  onto servers for customers
• Oracle Packages Support

40
Appeon 2.8 Client-side Integration Phase I

• Client-side Integration for External Browser
  Application Support
• External DLL Functions
• Run PowerScript function
• Start external applications like Microsoft
  Outlook, Lotus Notes, Microsoft Word, Microsoft
  Excel, GIS Software like ESRI, MapInfo, MapPoint,
  OLE/DDE, etc.
• OLE objects
• Secure, signed ActiveX to get external browser
  access

41
Replaced Adobe Acrobat with Appeon PDFPrinter

• Appeon 2.8 uses the Appeon PDFPrinter and PS to
  PDF Format Conversion for PDF printing. When the
  user installs Appeon Server, Appeon PDFPrinter
  will be automatically installed.
• Removes the need to purchase Adobe Acrobat
  license
• Removes the potential for an Adobe Acrobat
  deadlock
• Only PS to PDF Format Conversion adopts
  non-Appeon technology, which is Ghostscript with
  Aladdin Free Public License

42
Appeon Components
43
Appeon J2EE-based Architecture
44
Flexible Open Integration
Win32
.NET
PowerBuilder Client
J2EE
PB
DLL
OLE
Appeon Client
Appeon Server
PowerBuilder NVOs
Web Services
Bean/ EJB
OLE
DLL
COM/DCOM
JSP/Servlet
J2EE
Win32
45
Appeon Enterprise Manager (AEM)

• AEM is a Web-based app that manages Appeon Server
  web apps over Internet

46
Appeon for PowerBuilder - RAD/4GL GUI Web
Rich-Client GUI in Thin-Client Browser with
Fastest 4GL/RAD Dev IDE

• Demo Appeon Developer All Toolbar Icons
• Inherit New PowerBuilder Window Code Business
  Logic
• Deploy Web Application
• Demo Appeon Enterprise Manager (AEM)

47
Appeon Server Security

• Firewall Compatibility
• HTTP over Port 80 so Appeon can take advantage of
  Firewalls and does not propose a security threat
• Only documents (.HTML, .JS, .XML, etc.)
  downloaded
• Authentication Security
• LDAP or Appeon Built-in Authentication Security
  with No Coding Applications, Groups, and Users
• Built-in PowerBuilder Application Security
• Application Timeout Security
• Direct URLs Security
• SSL (HTTPS) Encryption Security up to 128 bits
• JavaScript Business Logic Encryption Feature
  Security
• Protects customers intellectual property and
  hacking
• Digital Certificates Security

48
High Scalability

• Appeon n-tier Web architecture offers superior
  scalability
• Typical applications support 60-80 Concurrent
  Users per server CPU which maps to potentially
  300 Named/End Users per server CPU
• Support any number of users via clustering and
  load balancing
• Harnesses idle computing power of client
• No redundant generation of pages

49
No Bandwidth Limitations

• Appeon architecture works reliably with any
  connection type and quality
• Broadband (ISDN, DSL, Cable, T1)
• Dial-up (56Kbps)
• Long distances (North America to Asia)
• Unstable network connection (outside North
  America)
• High latency (outside North America)
• Because
• All Web files cached semi-permanently at the Web
  browser
• Only data result-sets downloaded from server to
  Web browser
• 10X data compression applied to data result-sets
• Utilizes stateless and non-persistent connection

50
Appeon Deployment Options

• Appeon 2.8 offers deployment options depending on
  how much client/server functionality is needed
• Pure-JavaScript (no plug-ins required)
• Advanced Edition (AE)
• At least 2-5 times faster performance than Appeon
  2.7, typically 3-5 times faster up to 10 times
• Support for many rich PB features 85 of PFC
• Optional Enables client integration DLLs, Win32
  API, OLEObject object, launching client programs
  with Run PowerScript
• JavaScript with Appeon Xcelerator plug-in
• Enterprise Edition (EE)
• Boosts performance to near client/server speed
• More client-side integration
• Available in Appeon 2.8 Enterprise Edition 2004
• Start with Appeon Development and simply deploy
  in EE

51
Pure-JavaScript Performance
52
Appeon Xcelerator Performance

• Environment P4 1.8GHz, 512MB RAM, Win2K, Sales
  App Demo (non-PFC)

Window Window Operation PB APB 2.8 EE APB 2.8 AE (JS) APB 2.7 JS
Order Viewer w_order_view.open Open 0.343 0.328 1.0473 6.875
Customer Maintenance w_customer_maintenance Open 0.062 0.094 0.266 2.984
By Order Type (Report) w_rpt_order_type Open 0.062 0.093 1.130 4.827
Customer Report w_rpt_order_customer_summary Open 0.047 0.141 0.593 6.225

• JavaScript (AE) performance 310 times as fast as
  Appeon 2.7
• Appeon Xcelerator (EE) performance 2050 times as
  fast as Appeon 2.7 near C/S speeds

53
Appeon Xcelerator Performance (cont.)

• Environment P4 1.8GHz, 512MB RAM, Win2K,
  customer PFC app (25MB)

Window Path Operation APB 2.8 EE APB 2.8 AE (JS) APB 2.7 JS
User Permissions System Security gt Update gt User Permissions Window Open 0.6 1.9 8.4
Delivery Order Delivery Order and Invoice gt Update gt Delivery Order Window Open 0.8 4.1 15.0
Request Purchase gt Order gt Update gt Request Window Open 1.5 4.6 15.8

• JavaScript (AE) performance 310 times as fast as
  Appeon 2.7
• Appeon Xcelerator (EE) performance 2050 times as
  fast as Appeon 2.7 near C/S speeds

54
Appeon Xcelerator (EE) vs. Pure JavaScript (AE)

• DataWindow Controls GroupBox, Picture,
  Rectangle, RoundRectangle
• DataWindow Controls Properties BringToTop,
  ControlMenu, MaxBox, MinBox, Resizeable,
  RightToLeft, Title, TitleBar
• DataWindow Functions Clear, GetBandAtPointer,
  GetFormat, GetValidate, ImportClipboard,
  ImportFile, ImportString, PointerX, PointerY,
  SetBorderStyle, SetRedraw
• Dynamic Tab Pages OpenTab, OpenTabWithParm,
  CloseTab functions, Key event
• Dynamic User Objects OpenUserObject,
  OpenUserObjectWithParm, CloseUserObject,
  GetParent functions, PictureName property
• Environment object
• Keyboard Support Accelerator Keys, Hot Keys,
  Shortcut Keys
• Menu Properties Shortcut, ToolbarItem
• Message Object Properties WordParm

55
Appeon Xcelerator (EE) vs. Pure JavaScript (AE)

• Print Functions Print, PrintBitmap,
  PrintCancel, PrintClose, PrintDefineFont,
  PrintLine, PrintOpen, PrintOval, PrintPage,
  PrintRect, PrintRoundRect, PrintScreen,
  PrintSetFont, PrintSetSpacing, PrintSetup,
  PrintText, PrintWidth, PrintX, PrintY for Grid,
  Tabular, Freeform DataWindows
• Printer Functions All are supported including
  PrintGetPrinter, PrintGetPrinters,
  PrintSetPrinter, PrintSetupPrinter for Grid,
  Tabular, Freeform
• CorbaObject Properties PackageName,
  ComponentName, ComponentTransactionType,
  ComponentState
• System Functions Randomize, GetEnvironment,
  Handle, Post, Send, PixelsToUnits, UnitsToPixels,
  Clipboard
• Transaction Object DBPass property, DBHandle,
  PostEvent, TriggerEvent
• Window Controls Oval, RoundRectangle
• Window Controls Functions LineCount,
  LineLength, PointerX, PointerY
• Window Controls Properties Accelerator,
  Alignment, AutoHScroll, AutoSkip, BringToTop,
  Cancel, Default, FillPattern, FontCharSet,
  FontFamily, FontPitch, HideSelection, ShowList,
  TabPosition

56
Appeon Xcelerator Enterprise Edition (EE)

• IE Web browser SaveAs dialog box will be
  automatically opened
• User can right-click on the PDF links in the PDF
  repository to SaveTargetAs to their hard drive

57
Citrix Terminal Emulation Woes

• Citrix does not migrate your application to a
  standard n-tier Web architecture.
• Runs the entire application locally at the server
  for each and every user.
• 30 sessions 30 applications running at the
  server
• Large, yearly support costs
• Huge server farms because 10-25 users supported
  per server CPU which results in more maintenance
  and support
• Pressure points placed on Network, Emulation
  Servers and Database Servers because emulation
  does not pool or cache the user interface on the
  client or the database connections on the server
• User interface is projected over the Internet for
  every keystroke, mouse-move, or user interface
  interaction must round-trip to the emulation
  server for processing
• Changes to user interface must be re-projected
  back over the Internet
• Network instability and security issues
• Possibility of some deployment issues because of
  browser download and versioning
• Firewall ports beside HTTP/80
• Short-term tactical solution rather than
  long-term strategic direction

58
J2EE or .NET Rewrite Cons

• Complete Rewrite in J2EE or .NET and HTML
• Invest years and substantial money
• Expose organization to high risk of failure
• Rebuild development team or skills
• Complete redesign and rewrite of application
• Compromise developer productivity and complicate
  development
• Accept a foreign Web application with poorer user
  productivity

59
When to Use Appeon for PowerBuilder?

• Best to use Appeon when enterprise needs to move
  to J2EE-based and n-tier Web architecture and the
  following are true
• in the fastest amount of time
• with the least cost
• with the least risk
• with greatest productivity
• with rich user interface
• leveraging existing PowerBuilder skill set

60
System Requirements

• PowerBuilder 8 or 9 Applications written for
  pre-version-8 versions of PowerBuilder will need
  to be upgraded to PB 8.x or 9.x before migrating
• Windows 2000/XP/NT Appeon is working on
  extending support to Linux/Unix servers in the
  near future
• Internet Explorer 6.0 Appeon chose to not
  compromise on the richness and functionality
  since IE has 96 of the browser market share
• Appeon Server Appeon Server offers robust
  support for J2EE and PowerBuilder, including
  DataWindows and NVOs
• All Leading RDBMS Sybase ASE 12.x, Sybase ASA
  7.x-9.x, Oracle 8i/9i, Microsoft SQL Server 2000,
  IBM DB2 8.1, Informix not certified but customers
  successfully using for SQL DataWindows and
  Embedded SQL

61
Appeon Documentation Resources

• http//sybase.com/manuals
• Appeon Help Files with All Supported
  Unsupported Features
• Appeon Supported Features PFC/ACF Guide
• Appeon Migration Guide
• Appeon Troubleshooting Guide
• Appeon Performance Tuning Guide
• Appeon Release Bulletin
• Appeon Installation Guide
• Appeon Whats New Guide
• Appeon Developer User Guide
• Appeon Enterprise Manager User Guide
• Appeon Demo Applications Guide
• Appeon Migration Tutorial Guide
• Appeon Introduction Guide

62
Appeon Getting Started

1. Go through the Appeon Tutorial
2. Create a new application and deploy it to the web
3. Run through the deployment on an existing
   application and study the Unsupported Feature
   Analysis (UFA) Report and the Heavy Windows
   Report
4. Work around the unsupported features (or ignore
   them if they are not critical features) for the
   framework
5. Work around the unsupported features (or ignore
   them if they are not critical features) for a
   window
6. Test the window in Client/Server
7. Test the window in Web Browser

63
Beyond Appeon 2.8 Considerations AE

• Connection Caches, Listeners, and Performance
  Properties in Appeon Enterprise Manager (AEM) for
  easy Appeon Server Support
• Drag n Drop
• EAServer 5.1, 6.0 support
• EP Portlet Parameter Passing support
• Error System Object and Associated PFC Service
• More connectivity to external applications like
  Microsoft Outlook, Lotus Notes, Microsoft Word,
  Microsoft Excel, GIS Software like ESRI, MapInfo,
  MapPoint, OLE/DDE, etc.
• More language certification for users already
  using French, Spanish, Italian, Hebrew, German,
  Greek, Russian, etc.
• Performance Enhancements
• PowerBuilder 10
• Rich Text DataWindow Presentation Style Window
  Control
• System Function Types DW.ImportFile, File, Help,
  Printer, Profile, Registry
• Unix/Linux support

64
Beyond Appeon 2.8 Considerations EE

• Always Available/Occasionally Connected support
• Connection Caches, Listeners, and Performance
  Properties in Appeon Enterprise Manager (AEM) for
  easy Appeon Server Support
• Drag n Drop
• Dynamic DataWindow
• EAServer 5.1, 6.0 support
• EP Portlet Parameter Passing support
• Error System Object and Associated PFC Service
• JavaScript Runtime Debugger
• More language certification for users already
  using French, Spanish, Italian, Hebrew, German,
  Greek, Russian, etc.
• OLE/OCX/ActiveX Controls on Windows
• PowerBuilder 10
• Rich Text DataWindow Presentation Style Window
  Control
• Server Performance Enhancements
• Unix/Linux support

65
Appeon Licensing Overview

• Appeon Evaluation Edition through Sybase Website
  download although sales involvement is the best
  way to help customers be successful
• Includes all Appeon components but is time
  limited
• Appeon Server (with both Pure JavaScript and
  Appeon Xcelerator in 2004)
• Appeon Developer
• Appeon Enterprise Manager (AEM)
• EAServer Developer Edition (embedded in Appeon
  Server installation)
• ASA 8.0.2 (embedded in EAServer installation)
• PowerBuilder 8.0.4 Build 10656
• PowerBuilder 9.0.1 Build 7171

66
Appeon Licensing Overview

• Appeon Developer Edition
• Licensed per developer
• Includes EAServer Developer Edition
• Appeon Development Test Server Edition
• Licensed per Development Test Server CPU
• Includes EAServer Development Test Edition
• Appeon Production Deployment Server Advanced
  Edition
• Licensed per Production Server CPU
• Includes EAServer Advanced Edition license
• Pure JavaScript deployment only even though
  Appeon Xcelerator is included if customers want
  to upgrade the license to Enterprise Edition
• Appeon Production Deployment Server Enterprise
  Edition
• Licensed per Production Server CPU
• Includes EAServer Advanced Edition license
• Pure JavaScript and Appeon Xcelerator deployment

67
Portal - The Next Step for Appeon Web Apps
Sybase Enterprise Portal
68
Appeon for PowerBuilder - The Next Step - Portal
Rich-Client GUI in Thin-Client Browser with
Fastest 4GL/RAD Dev IDE

• Running PowerBuilder 9 Build 7171
• PB 8.x and 9.x supported
• Deploy PowerBuilder application to Appeon web app
• Add Appeon web application HTML Portlets in EP
  Portal Interface
• Show N-Tier coding in PowerBuilder window

69
Single PB Project with 3 Deployment Options
No other development platform in the world,
including .NET and J2EE, will allow you to build
business applications that are device and
technology agnostic except for PowerBuilder. 1
App, 1 Project, 3 Deployment Solutions
PowerBuilderProject
Develop, deploy, and maintain all in PowerBuilder
IDE using only PowerBuilder skills
Client/Server
Web
Mobile
70
Appeon for PowerBuilder - The Next Step - Portal
Sybase Enterprise Portal
71
Pet World Lines Of Code Study For New
DevelopmentFaster New Development Than J2EE or
.NET No Dumbing Down GUIhttp//www.appeon.net/p
etworld/http//www.trysybase.com http//appeon.co
dexchange.sybase.com/

1. How many more mistakes would be made in coding?
2. How much longer would debugging take?
3. How much longer would routine maintenance take?
4. How much longer would enhancements take?
5. How much longer would rewriting business logic
   take?
6. How much extra ROI would there be for existing
   code?
7. How much more user friendly apps and productive
   would users be?

72
Appeon Resources

• 4 Demo Web Applications http//www.trysybase.com
  
• Product Websites http//sybase.com/appeon and
  http//www.appeon.net
• Demo/Webcast http//download.sybase.com/presenta
  tion/isug_presentations/sybs041304.wmv
• Newsgroup forums.sybase.com -gt
  sybase.public.appeon
• CodeXchange http//appeon.codexchange.sybase.com
  
• Pet World Study http//www.appeon.net/petworld/
• Whitepapers http//www.appeon.net/developers/doc
  uments/
• Product Manuals http//sybase.com/support

73
PWB502 Course Number Appeon for PowerBuilder
Technical Overview
Rex GeisslerSybase Appeon Product
ArchitectRex.Geissler_at_sybase.com / 303-409-7887