Appeon for PowerBuilder Introduction

1
Appeon for PowerBuilder Introduction
Appeon for PowerBuilder
BRINGING THE POWER OF PB TO THE WEB

• PRESENTATION FOR NAME

Armeen Mazdaarmeen.mazda_at_appeon.com1-877-3APPEON
x621
2
Topics

• Appeon Overview
• Live Demonstration
• Technical Details
• Conclusion

3
About Appeon Corporation

• Worldwide leader in providing PowerBuilder-based
  development products and IT outsourcing services
• Patented technology in deploying applications
  built in PowerBuilder to J2EE and .NET platforms
• Sybase distributes supports Appeon worldwide.
  Over 600 customers using Appeon today!
• Subsidiary of Shell Electric, a Hong Kong
  conglomerate founded in 1952 and publicly traded
  on the HKSE

4
PowerBuilders Relationship to .NET

• .NET is any programming language deployed to a
  single framework/OS, for example, C, ASP, etc.
• Traditional 4GLs have become .NET languages, for
  example, VB, Delphi, etc.
• PowerBuilder is the latest .NET language,
  following the likes of VB and Delphi

5
What is Appeon for PowerBuilder?

• Appeon for PowerBuilder (APB) is
• Add-on for PowerBuilder to develop complex .NET
  or
• Java Web applications rapidly and easily.

Automatically Deploy
6
Why Choose Appeon?

• More companies prefer to use Appeon for their Web
  projects because they find that Appeon delivers
  superior ROI by
• Shortest development time and lowest cost.
• Develop new Java or .NET Web applications 4X
  faster and migrate existing PowerBuilder
  applications in just a few months or even weeks.
• Least project risk.
• There is no need to rewrite your entire code
  base, no need to re-architect your system, no
  need to retool your engineering team, and even no
  need to re-train your end-users.
• Most powerful PowerBuilder Web deployment.
• Effortlessly handles the largest of applications
  (up to 600MB) with the most robust PowerBuilder
  feature support, and offers powerful desktop
  integration with the richest Web user interface.
• Extraordinary performance and scalability.
• Delivers virtually the performance of
  client/server with the scalability of the Web
  there is no faster or more scalable Web
  deployment option.

7
The Appeon Technical Edge

• Rich-Client architecture utilizing ActiveX and
  AJAX technology to deliver the power of PB on the
  Web
• Most powerful and interactive Web user interface
• V6.0 optimized over 8 years and 1,000 engineering
  years of RD to handle real-life complex
  applications
• Technology agnostic simultaneously deploys to
  .NET and J2EE platforms with numerous integration
  options
• Performs under real-life load situations and
  features numerous automatic performance
  boosting features
• Hundreds of successful deployments where all
  other solutions failed, including Citrix, Web
  rewrites, and status quo

8
Case Study Appeon Savings
Just spending one week, one PowerBuilder engineer
implemented the PetShop blueprint application of
Microsoft .NET, which took two .NET engineers
four weeks to develop.

• Appeon is able to implement
• the same .NET application with
• 1/4 of the lines of code
• 1/4 of the time
• 1/8 of the cost.

Item .NET PB/Appeon Ratio
Lines of Code 2,213 564 1/4
Time 4 weeks 1 week 1/4
Cost 2 4 8 engineer-weeks 1 engineer-week 1/8
9
Healthcare Practice Management

• HENRY SCHEIN (NASDAQ HSIC)
• CHALLENGE
• To grow their customer base further, the Dental
  Vision business unit was forced to offer a
  standard Web solution and move away from Citrix.
• Complicating matters worse, the Web solution must
  deliver all existing functionality, including
  X-ray, imaging, RichTextEdit and MS Word
  integration.
• However, with 30 person years already tied up in
  the flagship Dental Vision client/server
  solution, budget and manpower to devote to
  rewriting Dental Vision a second time for the Web
  proved to be scant.
• SOLUTION
• Appeon for PowerBuilder
• Appeon Global IT Services
• RESULTS
• Successfully delivered a Web product that can
  seamlessly scale up to 5,000 users (the largest
  customer size in the dental industry).
• Not only preserved all functionality of existing
  client/server solution, but also UI remained
  unchanged eliminating complicated re-training.
• Project completed within 12 months and within
  limited budget.

10
Health Care - Human Resources

• RES-Q HEALTHCARE SYSTEMS
• CHALLENGE
• Customers demanded RES-Q expand their HR solution
  to offer hospital staff the ability to schedule
  themselves from anywhere and at anytime (i.e.
  Web-based self-scheduling).
• However, RES-Q staff and resources were full
  committed to maintaining their existing HR
  solution in PowerBuilder.
• The complexity and cost to add any new skill set
  or maintain an additional product line made it
  prohibitive for RES-Q to appease their customers.
• SOLUTION
• Appeon for PowerBuilder
• Appeon Global IT Services
• RESULTS
• Web-based self-scheduling delivered in just 60
  days.
• Integrated into existing product such that RES-Q
  staff is required to only maintain a single
  application.
• Existing RES-Q staff/skill set adequate for
  on-going maintenance of the integrated solution.

11
Healthcare - Procurement

• LEEDS TEACHING HOSPITAL
• CHALLENGE
• Improve the efficiency and cost-effectiveness of
  supply procurement
• Provide management with real-time visibility into
  the procurement system
• SOLUTION
• Appeon for PowerBuilder
• RESULTS
• Overall cost savings of 2.6 million to date
• 92 reduction in total processing cost per order
• Reduction in time spent on supply issues from 20
  to less than 5
• Time between requisitions and purchase orders has
  been cut from 7 to 10 days to 3-4 hours
• Improved financial control to comply with audit
  requirements and management information,
  including key performance indicators (KPI)
  reporting
• Improved requisitioning capability and with
  integration to multiple systems

12
ISV Contract Mgmt

• INTELLISOFT GROUP
• CHALLENGE
• Intellisoft Group, after much success with its
  medical credentialing software (IntelliContract)
  was looking to expand its business beyond
  healthcare and offer a horizontal solution
• Wading through uncharted waters was a significant
  concern, and as such, IntelliSoft wanted to
  quickly validate the opportunity with minimal
  investment (potential loss).
• However, to be successful in this crowded market,
  needed to offer radically superior and
  technically advanced product.
• SOLUTION
• Appeon for PowerBuilder
• Appeon Global IT Services
• RESULTS
• Successfully brought IntelliContract to market in
  6 months
• Venture profitable within 2 months of being on
  the market
• Have won accounts against SalesForce.com and
  other strong competitors

13
Telecommunications - CRM

• CHINA UNICOM INTEGRATIVE ACCOUNT SYSTEM
• CHALLENGE
• As China Unicoms subscriber base had rapidly
  grown in recent years, the legacy CRM system had
  become outdated and difficult to maintain
• Off-the-shelf CRM solutions did not match China
  Unicoms business processes and departmental
  workflows or proved to be cost-prohibitive
• Time-to-market was essential since customer
  accounts were in jeopardy
• SOLUTION
• Appeon for PowerBuilder
• Appeon Global IT Services
• RESULTS
• System developed and successfully rolled out to
  China Unicom customers in just 8 months
• Subscribers empowered to view account information
  and perform various account modifications without
  calling customer service
• China Unicom engineers able to perform the
  ongoing maintenance the Web application using
  familiar PowerBuilder skills and toolsets
• System runs stably at the rush hour when more
  than 1,300 online users are accessing the system

14
Topics

• Appeon Overview
• Live Demonstration
• Technical Details
• Conclusion

15

• DEMO

16
Topics

• Appeon Overview
• Live Demonstration
• Technical Details
• Conclusion

17
Secret to Automated Web Deployment

• Appeon replicates most powerful PB features such
  that existing PowerBuilder code can be readily
  mapped to the Web

• All DataWindows styles
• All Windows types for both SDI and MDI
• All UI controls and 27 common system objects
• Menus/Toolbars, all User Objects NVOs
• OLE/OCX/DLL
• Most PowerScript
• PFC Framework

18
Preserving Rich GUI on the Web

• Based on AJAX, Appeon precisely replicates
  the source PB application resulting in the most
  productive UI for your users that beats current
  offerings in JSF/J2EE and Web Forms/.NET

Web
Click n Deploy
PowerBuilder
19
N-Tier Platform for Web Apps

• Appeon Developer deploys to the Web using only
  PowerBuilder skills and IDE
• Appeon Server for J2EE implemented 100 in Java
  providing runtime services
• Appeon Server for .NET implemented 100 in C
  providing runtime services
• Standard N-tier Architecture HTML, XML,
  JavaScript, ActiveX, Java and C, HTTP/HTTPS,
  default IE browser settings and firewall
  friendly, seamless Web loading

20
Application Partitioning

• Where does the Presentation Business Logic run?
• Distributed to Web Browser Client App Server
  vs. Consolidated on App Server?
• This impacts the number of round trips across the
  Network or Internet
• This impacts the performance and scalability of
  the application

21
Appeon Partitioning Approach

• Appeon Utilizes a Balanced Architecture
• Preserve business logic and UI of the original
  PowerBuilder application as a rich-client in
  standard Web browser
• Deploy DataWindows, Embedded SQL, and heavy
  business logic to the J2EE or .NET application
  server
• Re-use database and stored procedures via JDBC or
  ODBC

22
Rich Client Architecture

• Performance
• Supercharge Web performance/scalability through a
  balanced N-tier architecture ideal for complex
  functionality
• Compiled language is 10X faster than interpreted
  (e.g. JavaScript)
• Eliminate unnecessary, timely, and costly server
  roundtrips that frustrate end users (customer,
  partners, employees, etc.)
• Features
• Go beyond the browser and integrate seamlessly
  with any application, Windows OS, or hardware
  (scanner, printer, etc.)
• Bring the rich functionality of traditional
  PowerBuilder applications into the standard
  Internet Explorer Web browser (OLE/OCX/DLL)
• Desktop look n feel with multi-tasking floating
  windows, toolbars, menus, drag n drop, hot keys
  shortcuts

23
Automatic Performance Boosting

• Numerous functionalities built-in to boost Web
  performance under real-life situations
• Download manager offers Just-in-Time (JIT) or
  Preload options for running the Web application
• ActiveX optimized to be only 2MB in size yet
  virtually deliver same power as 8MB PBVM
• 10X data compression to compress DataWindow
  result sets
• 3-level DataWindow caching technology caches at
  the application server, Web server, and Web
  browser
• Micro-refresh (via AJAX) eliminates all redundant
  generation and downloading of data, such as in
  commonly and frequently-used Master-Detail
• Application server connection pooling can boost
  database scalability by several folds through
  shared connections

24
Complex Application Optimizations

• Automatic conversion up to 95 in many cases.
• Without doing any coding work, click deploy and
  see majority of your application Web-enabled
• Occasionally, a line of PowerScript in an event
  handler that is not supported will prevent the
  launching of the functionality
• Work around the unsupported feature using
  standard PB programming, perform an incremental
  deploy, and voila!
• Not an all-or-nothing deal!
• An application with known unsupported features or
  errors can still be Web deployed allowing you to
  explore the app
• Problematic (Web) code is automatically commented
  out
• Utilize Appeon Debugger to real-time debug the
  resulting Web application tracing back to
  specific line of PowerScript

25
New Web Development with Appeon

• Step 1 Analyze
• Define the scope
• Define requirements
• Produce detailed functional specs

• Step 2 Design
• Design architecture
• Design UI layout
• Produce design doc and pseudo code

• Step 3 Implement
• Code and test using PB IDE and skills
• Re-use tools (PB Delta, Winrunner, etc.)
• Re-use processes

26
Automated Web Migration with Appeon

• Step 1 Analyze
• Analyze application using built-in tools
• Unsupported PB features?
• Inefficient code?

• Step 2 Design
• Devise workarounds for unsupp. features
• Optimize and/or package some logic for
  Internet/WAN

• Step 3 Implement
• Code and test using PB IDE and skills
• Re-use tools (PB Delta, Winrunner, etc.)
• Re-use processes

27
Major Unsupported Features

• PowerScript Statements GOTO, THROW, THROWS
• DataWindow TableBlob Control for DataWindow
• System Functions Class Definition functions, DDE
  Server functions, Garbage Collection functions,
  Help functions, Library functions, Shared Object
  functions, Tracing functions
• System Objects ADOResultSet, ArrayBounds,
  ClassDefinition, ClassDefinitionObject,
  ConnectionInfo, ConnectObject, ContextInformation,
  ContextKeyword, CORBA (all), CPlusPlus,
  DivideByZeroError, DWRuntimeError,
  EnumerationDefinition, EnumerationItemDefinition,
  Error, ErrorLogging, Exception, ExtObject,
  JaguarORB, NullObjectError, OLERuntimeError,
  OLEStorage, OLEStream, OLETxnObject, OMControl,
  OMCustomControl, OMEmbeddedControl, OMObject,
  OMStorage, OMStream, ORB, PBTocppObject,
  Pipeline, ProfileCall, ProfileClass, ProfileLine,
  ProfileRoutine, Profiling, RemoteObject,
  ResultSet, ResultSets, RuntimeError,
  ScriptDefinition, Service, SimpleTypeDefinition,
  Throwable, Trace (all), TransactionServer,
  Transport, TypeDefinition, VariableCardinalityDefi
  nition, VariableDefinition

Nearly all major unsupported features can be
commonly worked around utilizing server-side
PowerBuilder NVOs
Many unsupported features can be readily worked
around at the client-side without utilizing
server-side PowerBuilder NVOs
28
Unsupported Features Analyzer

• Identifies unsupported features based on keyword,
  providing you with location, line number, and
  code snippet

29
Appeon Code Insight

• Keeps future development Web-compliant by listing
  only supported PowerScript at your fingertips

30
Appeon (Web-to-PB) Debugger

• Utilize Appeon Debugger to real-time debug the
  resulting Web application tracing back to
  specific line of PowerScript

31
System Requirements

• Web Browser
• Internet Explorer 6 or 7 on Windows
  XP/Vista/2003/2008
• Web Application Server
• Microsoft IIS 7.0/6.0, Apache 2.x, Sybase
  EAServer 6.1/5.5, IBM WebSphere 6.1/5.1, BEA
  WebLogic 10.0/9.2
• Windows 2008/2003, Red Hat Linux 5.0/4.0, IBM AIX
  5.3/5.2
• Database
• Sybase ASA 10.0/9.0/8.0, ASE 15.0/12.5, IQ 12.7
• Microsoft SQL Server 2005/2000
• Oracle 10g/9i/8i
• Informix 9/7
• IBM DB2 9.5/8.2

32
Topics

• Appeon Overview
• Live Demonstration
• Technical Details
• Conclusion

33
Proven PB Web Migration Paths

• Java/.NET Web App
• Any Vendor Server
• Java/.NET EAI
• Java/.NET Developers
• Any Vendor Tools
• Open Web Source

Java/.NET Rewrite

• Time 1.5-2 Yr
• Cost 4-10X
• Risk gt70

By Hand
Power Builder

• Time 3 Mths
• Cost X
• Risk lt5

• Java/.NET Web App
• Any Vendor Server
• Java/.NET EAI
• PB Developers
• SY Standard Tools
• Closed Web Source

Automated
Appeon Java/.NET Web Deployment
34
Future-proof Your Investments

• PowerBuilder and Appeon empowers enterprises to
  build .NET and Java applications that are device
  technology agnostic, deploying to many
  platforms at virtually the click of a button.

35
Real Tangible Benefits

• Modernize PowerBuilder Automatically convert
  existing PowerBuilder applications to Web
  applications in just months or even weeks.
• Develop 4X Faster Instantly begin building new
  Web applications that deploy to .NET or Java
  platform at a speed that is at least 4 times
  faster than typical .NET or Java development.
• Satisfy End-users End users productively work
  with the worlds richest Web user interface!

36
Competitive Advantage for ISVs

• Preserve Existing Customer Base There is risk
  of losing segment of existing customer base due
  to lack of Web solution.
• Upsell Existing Customer Base Customers view
  Web solutions as providing higher value than
  client/server solutions, and as such are willing
  to pay higher license fees to purchase Web
  solutions.
• Expand Customer Base Now your company is well
  positioned to go after prospects that demand
  enterprise-class Web solution.
• Stay Ahead of the Competition - Agility to
  respond to changing business requirements 4 times
  faster than your competition.

37
Competitive Advantage for ISVs (cont.)

• Differentiate your Product Competing solutions
  lack the rich UI and functionality of your Web
  solution Web-enabled with Appeon.
• Lower your Cost - Achieve the absolute lowest
  cost position. At least 4 times fewer headcount
  and even greater savings for automated migration
  of existing product portfolio.
• Transition Seamlessly Your existing customers
  wont have to undergo retraining and your
  existing user guides, training program, and sales
  collateral will continue to be useful since the
  UI is unchanged

38
Thank You!
Appeon for PowerBuilder
BRINGING THE POWER OF PB TO THE WEB
Armeen Mazdaarmeen.mazda_at_appeon.com1-877-3APPEON
x621