Your Presenters

1
Your Presenters

• Dave Fish Engineering Evangelist
• Jim ONeil Sales Evangelist
• John Strano Technical Evangelist

2
PowerBuilder Market Focus and Road Map
The development, release, and timing on any
features and functionality described for our
products remains at our sole discretion. The
information on this roadmap is intended to
outline our general product direction and should
not be relied on in making a purchasing decision.
15
3
Market Focus Sybase Goals

• Focus on .NET and J2EE platforms to extend reach
• Provide key technology differentiators within an
  open 4GL IDE
• Leverage DataWindow technology as the cornerstone
  of Sybase offerings

4
Market Focus The PowerBuilder Products

• PowerBuilder
• 4GL development for Windows, Web, and distributed
  applications
• Provide key technology to simplify .NET
  development
• PowerBuilder Application Server Plug-in
• Deploy PowerBuilder business objects (NVOs) to
  J2EE application servers
• Expose business logic as EJBs or Web Services
• PocketBuilder
• 4GL RAD for Windows Mobile devices
• Quickly extend the reach of business applications
  to mobile users
• DataWindow .NET
• 4GL productivity in Visual Studio .NET
• Attract Microsoft developers to Sybase technology

5
DataWindows Everywhere

• PowerBuilder for Client/Server, Web, Web Services
  and now .NET
• PowerBuilder Application Server Plug-In
• WebLogic
• WebSphere
• JBoss
• DataWindow .NET
• PocketBuilder
• DataWindows greatly reduce the amount of code you
  need to write for your application
• The DataWindow Painter provides an intuitive
  graphical user interface granting you immediate
  productivity

6
Messaging

• Sybase is committed to PowerBuilder
• PowerBuilder 11 delivers core functionality
  enhancements
• Database driver enhancements
• DataWindow enhancements
• IDE and user enhancements
• and major new features
• .NET deployment options
• Web Services DataWindow
• New SQL Server database driver
• Sybase is committed to fully supporting and
  exploiting .NET
• PowerBuilder 11 release
• DataWindow .NET 2.5 (due 3Q 2007)

7
Simplified development for today, tomorrow, and
beyond
Language Independence
Application Connectivity
Multiple Platform Support
Power And Performance
8
Simplified development for today, tomorrow, and
beyond
Language Independence
Application Connectivity
Multiple Platform Support
Power And Performance
9
Simplified development for today, tomorrow, and
beyond
Language Independence
Application Connectivity
Multiple Platform Support
Power And Performance
10
Simplified development for today, tomorrow, and
beyond
Language Independence
Application Connectivity
Multiple Platform Support
Power And Performance
11
PowerBuilder 11 Features
15
12
PowerBuilder 11 Release Defining Features

• IDE and user interface enhancements
• DataWindow enhancements
• Updated database connectivity
• .NET deployment capabilities
• .NET Web Form applications in ASP .NET 2.0
• .NET Windows Form and Smart Client applications
• .NET Web Services
• .NET Assemblies

13
IDE and User Interface Enhancements
10
14
IDE Enhancements

• AutoScript

15
IDE Enhancements

• AutoScript
• Resizable dialog boxes

16
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars

17
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars
• System tree

18
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars
• System tree
• Project painter

19
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars
• System tree
• Project painter
• Output window tabs

20
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars
• System tree
• Project painter
• Output window tabs
• Exception support in debugger

21
IDE Enhancements

• AutoScript
• Resizable dialog boxes
• Updated menus and toolbars
• System tree
• Project painter
• Output window tabs
• Exception support in debugger
• Window animation and transparency

22
DataWindow Enhancements
10
23
DataWindow Enhancements

• Display ellipsis for truncated data
• Retain DataWindow retrieval argument values
• Web TreeView DataWindow
• Web Service DataWindow data source

24
Display Ellipsis for Truncated Data
25
Retain DataWindow Retrieval Arguments

• Stored with target information in registry
• Not applicable at runtime

26
Web TreeView DataWindow
27
Additional TreeView DataWindow Features

• Zero-height detail band supported
• Repositioned rows retain their collapsed/expanded
  state
• Standard TreeView events added to DataWindow
  control

28
Web Services DataWindow Data Source

• Deliver data to DataWindow via a Web Service
• Supports disconnected client model
• Eliminates requirement that vendors client
  software reside on end-user machine
• Web Service result set support
• Data type support
• Simple data type (or array of simple data types)
• Non-nested structure (or array of structures)
• Method retrieval options
• Return value
• Reference output parameter

29
Web Service DataWindow Definition
PowerBuilder Web Service support using the .NET
engine
Generated .NET Assembly
Metadata
DataWindow Painter
WSDL
A DataWindow Object
30
Web Service DataWindow Retrieval

• Uses existing DataWindow retrieval PowerScript
  syntax
• Optional wsconnection object supports runtime
  customization
• Endpoint
• User ID and password
• Timeout
• Security options
• Proxy server settings

31
Web Service DataWindow Updates

• Analogous to Stored Procedure update options

32
Web Service DataWindow Error Handling

• New WSError event is analog of existing
  DataWindow DbError event when using a Web service
  data source

33
Web Service DataWindow Runtime Operation
PowerBuilder Web Service support using the .NET
engine
Generated assembly and the .NET framework
Metadata
The DataWindow engine
The Web Service
Retrieval method call
Returned data
34
DataWindow Enhancements Demonstration
35
Database Connectivity Enhancements
5
36
Database Connectivity Enhancements

• New Sybase Adaptive Server Enterprise (ASE) 15
  native driver
• New Microsoft SQL Server native driver
• Oracle RAC support
• MobiLink support

37
Sybase Adaptive Server Enterprise (ASE) 15

• New interface supports version 15 and later
• SQLCA.DBMS ASE (DLL name PBASE110.DLL)
• Requires Open Client 15
• ASE 15 feature support
• Identifier names up to 128 characters
• Scrollable cursors
• New integral data types
• Updated SYC interface supports some features of
  ASE 15
• Scrollable cursors
• New integral data types

38
Microsoft SQL Server

• New native driver interface
• SQLCA.DBMS SNC (DLL name PBSNC110.DLL)
• Supports SQL Server 2000 and 2005
• Relies on SQL Server 2005 native client
  installation
• SQL Server 2005 support
• Multiple active result sets (MARS)
• Bypass validation during encryption
• Snapshot isolation level
• DBParm support
• Cache stored procedure parameter descriptions
  (SPCache)
• Host and AppName parameters from previous MSS
  native driver reinstated

39
Oracle Real Application Clusters (RAC)

• RAC is an optional feature where single database
  is deployed across a hardware cluster
• Supported by PowerBuilder Oracle 10g interface
  only
• Handling RAC failure events
• Define custom Transaction object
• Set HANotification DBParm on Transaction object
  to enable notification
• Implement DBNotification event on Transaction
  object to handle the error
• Set return value of DBNotification event
• 0 initiate failover
• Other value stop processing current command,
  return error

40
MobiLink Support

• Sybase technology providing session-based
  synchronization between a main database and
  multiple remote databases
• New PowerBuilder built-in objects support .NET
  Windows Form applications
• MLSynchronization abstract base class for
  MLSync object
• MLSync wraps call to dbmlsync.exe to perform
  synchronization and respond to callbacks
• SyncParm structure used to set properties for
  the MLSync object obtained from default or
  customized synchronization options window
• SyncProcessType enumeration indicating
  direction of the synchronization

41
PowerBuilder and .NET
5
42
PowerBuilders 4-Phase .NET Integration Initiative

• Web Services (PB9)
• DataWindow .NET (PB10 Timeframe)
• .NET Deployment (PB11)
• .NET Resource Consumption (PB12)

43
PowerBuilder .NET Compiler Internals

• Deployment relies on .NET SDKs C compiler
• Execution relies on PowerBuilder .NET System
  Libraries

PB2CS
C Code
.NET Application
PBL Files
Generates
Depends On
References
PowerBuilder .NET Compiler Framework
PowerBuilder System Library for .NET
44
Deploying .NET ApplicationsWeb Form
Applications in ASP.NET 2.0
20
45
Architecture.NET Web Form Applications
Compiles to
PB Web Form Application
PB Application
DataWindow .NET WebForm Control
PBDWM.DLL
PBSHR.DLL
DB Drivers
Unmanaged DLLs (without PBVM)
PB System Library for .NET
46
What Happens at Deployment

• PowerScript code is compiled to a .NET assembly
• PBDs with DataWindow objects are copied
• Resource files are copied
• PowerBuilder stock images
• INI files
• ASP.NET files are generated
• default.aspx the main ASP.NET page
• default.htm wrapper for default.aspx to hide IE
  toolbars and menu

47
What PowerBuilder Features Are Supported

• Most PowerScript language features
• All data types
• Function invocation (dynamic, post, trigger)
• Event handling
• Embedded SQL
• Most visual and non-visual controls
• Rich Text Control to be supported in EBF
• Pipeline object to be supported in maintenance
  release
• File operations File Manager
• Sending e-mail (via SMTP not MAPI) Mail Manager
• DataWindow printing Print Manager

48
What PowerBuilder Features Are Not Supported

• Some system classes such as
• Profile-related classes (but application tracing
  is available via web config)
• Trace-related classes (but database SQL tracing
  is available via web config)
• Some system functions such as
• DDE-related functions
• Clipboard-related functions
• Some controls, properties, and events such as
• OLEControl / OLECustomControl (partial support)
• InkPicture / InkEdit
• Drag-and-drop events
• EditLabels of TreeView

49
.NET Web Form Application Demonstration
50
Deploying .NET ApplicationsWindows Form and
Smart Client Applications
30
51
Architecture.NET Windows Form Applications
Compiles to
PB Application
PB Windows Form Application
DataWindow .NET Windows Form Control
Application config Application manifest
PBDWM.DLL
PBSHR.DLL
DB Drivers
Unmanaged DLLs (without PBVM)
PB System Library for .NET
52
PowerBuilder .NET Windows Form Applications

• Supports most features available in PowerBuilder
  Win32 applications
• PowerScript language features
• DataWindow, Editmask, RichText, InkEdit,
  InkPicture,
• DataStore, Transaction, ResultSet,
• Most system functions
• Consume .NET classes via PowerScript .NET
  interoperability
• Preserve PowerBuilder development skills
• Create a PowerBuilder application
• Deploy it as a .NET Windows Form application

53
PowerBuilder .NET Smart Client Support

• Solves the biggest headache of all

Application Deployment

• The best of the Rich Client world
• The ubiquity of the Web

54
Comparison Among Rich, Thin, and Smart Clients
55
PowerBuilder .NET Smart Client Support

• Occasionally connected
• PowerBuilder with MobiLink
• Always up-to-date applications
• PowerBuilders Intelligent Update
• Maximize performance using client resources
• PowerBuilder applications deployed as Windows
  Form (Rich Client)
• Communicate utilizing Web Services
• PowerBuilders Web Service DataWindow
• Utilize network resources
• PowerBuilders Web Service DataWindow
• PowerBuilders Intelligent Update
• PowerBuilder with MobiLink

56
MobiLink Synchronization Overview

• MobiLink synchronization objective create Smart
  Client, offline-enabled application
• Requirements
• Runtime
• ASA 9 or 10 database drivers and MobiLink
  deployed
• PowerBuilder Win32 or .NET Windows Form
  application
• Design time
• PowerBuilder 11.0
• SQL Anywhere 9/10

57
MobiLink Synchronization Architecture
58
Intelligent Update Overview

• Reduces pain of updating a typical client-server
  application
• Based on ClickOnce technology of .NET Framework
  2.0
• Makes deploying a Windows Form application as
  easy as deploying a Web application

59
Deployment Model

• Application installations and updates are
  deployed via centralized servers (via HTTP, FTP,
  UNC,)

60
.NET Windows Form/Smart Client Demonstration
61
Consuming .NET ResourcesPowerBuilder 11 .NET
Interoperability
10
62
.NET Interoperability

• .NET interoperability enables PowerBuilder
  applications to consume non-visual .NET resources
• Common Type System (CTS) types supported
• .NET interfaces
• PowerScript language extensions
• Code blocks and conditional compilation support
• Parameterized constructors
• Static properties and methods
• .NET exception propagation
• System Tree includes .NET assembly metadata

63
PowerBuilder 11 .NET Interoperability
Demonstration
64
Creating .NET ResourcesDeploying NVOs as .NET
Assemblies
10
65
Deploying NVOs as .NET Assemblies

• .NET Assembly Target type
• PowerScript data types automatically mapped to
  C
• Integrated .NET debugger support

66
Architecture.NET Assemblies
Compiles to
NVO .NET Assembly
PBLs with NVOs
DataWindow .NET
PBDWM.DLL
PBSHR.DLL
DB Drivers
Unmanaged DLLs (without PBVM)
PB System Library for .NET
67
Deploying NVOs as .NET Assemblies Demonstration
68
Creating .NET ResourcesDeploying NVOs as .NET
Web Services
15
69
Deploying NVOs as .NET Web Services

• .NET Web Services Target type
• Stateless design
• Public methods mapped to Web Service messages
• Selectively exclude additional methods from
  deployment
• Method aliases permitted (e.g., to account for
  overloading)
• Design time validation available
• PowerScript data types mapped to XML schema
  types
• Integrated .NET debugger support

70
Architecture.NET Web Services
Compiles to
NVO ASP.NETWeb Service
PBLs with NVOs
DataWindow .NET
PBDWM.DLL
PBSHR.DLL
DB Drivers
Unmanaged DLLs (without PBVM)
PB System Library for .NET
71
Deploying NVOs as .NET Web Services Demonstration
72
Future PowerBuilder Technology Showcase
10
73
Windows Presentation Foundation (WPF)

• High fidelity application experiences
• Blends together UI, documents, and media content
• Ultra-rich UI and data visualization through XAML
• Extensible Application Markup Language
• Vector-based animation

74
WPF DataWindow Demonstration
75
WPF DataWindow Demonstration
76
Get Started with PowerBuilder 11 Now!
5
77

• Moving to PowerBuilder 11 Class at TechWave
  2007
• Stay in touch with Sybases new direction in web
  development for todays most demanding web
  applications
• As a seasoned PowerBuilder developer, this course
  will help you learn PowerBuilders approach to
  application development using a rich set of .NET
  capabilities and much more
• Register for a Pre-Conference Session or an
  Education Seminar
• This class will also be available after TechWave
  in our Learning Centers and via SyberLearning
  LIVE

78
Thank you!