Your presenters
This presentation is the property of its rightful owner.
Sponsored Links
1 / 78

Your Presenters PowerPoint PPT Presentation


  • 87 Views
  • Uploaded on
  • Presentation posted in: General

Your Presenters. Dave Fish–Engineering Evangelist Jim O’Neil –Sales Evangelist John Strano –Technical Evangelist. PowerBuilder Market Focus and Road Map.

Download Presentation

Your Presenters

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Your presenters

Your Presenters

Dave Fish–Engineering Evangelist

Jim O’Neil –Sales Evangelist

John Strano –Technical Evangelist


Powerbuilder market focus and road map

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


Market focus sybase goals

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


Market focus the powerbuilder products

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


Datawindows everywhere

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


Messaging

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)


Simplified development for today tomorrow and beyond

2007

PowerBuilder 11.0

.NET Simplified

  • Deploy applications and NVOs to .NET

  • UI and IDE Enhancements

  • DataWindow Enhancements

  • New and Updated Database Drivers

Simplified development for today, tomorrow, and beyond

Language

Independence

Application

Connectivity

Multiple

Platform

Support

Power

And

Performance


Simplified development for today tomorrow and beyond1

2007

PowerBuilder 11.0

2007

PowerBuilder 11.1

.NET Simplified

.NET Enhanced

  • .NET incremental compiler

  • Informix 10 support

  • Enhanced Vista Support

  • Deploy applications and NVOs to .NET

  • UI and IDE Enhancements

  • DataWindow Enhancements

  • New and Updated Database Drivers

Simplified development for today, tomorrow, and beyond

Language

Independence

Application

Connectivity

Multiple

Platform

Support

Power

And

Performance


Simplified development for today tomorrow and beyond2

2007

PowerBuilder 11.0

2008

PowerBuilder 11.1.1

2007

PowerBuilder 11.1

.NET Simplified

.NET Enhanced

.NET Enhanced

  • .NET incremental compiler

  • Informix 10 support

  • Enhanced Vista Support

  • AJAX Support for Web Forms Applications

  • EAServer .NET Client Support

  • r.a.d. Controls for Web Forms

  • Deploy applications and NVOs to .NET

  • UI and IDE Enhancements

  • DataWindow Enhancements

  • New and Updated Database Drivers

Simplified development for today, tomorrow, and beyond

Language

Independence

Application

Connectivity

Multiple

Platform

Support

Power

And

Performance


Simplified development for today tomorrow and beyond3

2007

PowerBuilder 11.0

2008

PowerBuilder 11.1.1

2007

PowerBuilder 11.1

2008

PowerBuilder 12

.NET Simplified

.NET Enhanced

.NET Enhanced

.NET Exploited

  • .NET incremental compiler

  • Informix 10 support

  • Enhanced Vista Support

  • AJAX Support for Web Forms Applications

  • EAServer .NET Client Support

  • r.a.d. Controls for Web Forms

  • Deploy applications and NVOs to .NET

  • UI and IDE Enhancements

  • DataWindow Enhancements

  • New and Updated Database Drivers

  • .NET in the IDE

  • WPF/WCF support

  • Fully managed code DataWindow

  • Language enhancements to support .NET interoperability

Simplified development for today, tomorrow, and beyond

Language

Independence

Application

Connectivity

Multiple

Platform

Support

Power

And

Performance


Powerbuilder 11 features

PowerBuilder 11 Features

15


Powerbuilder 11 release defining features

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


Ide and user interface enhancements

IDE and User Interface Enhancements

10


Ide enhancements

IDE Enhancements

  • AutoScript


Ide enhancements1

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes


Ide enhancements2

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes

  • Updated menus and toolbars


Ide enhancements3

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes

  • Updated menus and toolbars

  • System tree


Ide enhancements4

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes

  • Updated menus and toolbars

  • System tree

  • Project painter


Ide enhancements5

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes

  • Updated menus and toolbars

  • System tree

  • Project painter

  • Output window tabs


Ide enhancements6

IDE Enhancements

  • AutoScript

  • Resizable dialog boxes

  • Updated menus and toolbars

  • System tree

  • Project painter

  • Output window tabs

  • Exception support in debugger


Ide enhancements7

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


Datawindow enhancements

DataWindow Enhancements

10


Datawindow enhancements1

DataWindow Enhancements

  • Display ellipsis for truncated data

  • Retain DataWindow retrieval argument values

  • Web TreeView DataWindow

  • Web Service DataWindow data source


Display ellipsis for truncated data

Display Ellipsis for Truncated Data


Retain datawindow retrieval arguments

Retain DataWindow Retrieval Arguments

  • Stored with target information in registry

  • Not applicable at runtime


Web treeview datawindow

Web TreeView DataWindow


Additional treeview datawindow features

Additional TreeView DataWindow Features

  • Zero-height detail band supported

  • Repositioned rows retain their collapsed/expanded state

  • Standard TreeView events added to DataWindow control


Web services datawindow data source

Web Services DataWindow Data Source

  • Deliver data to DataWindow via a Web Service

    • Supports disconnected client model

    • Eliminates requirement that vendor’s 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


Web service datawindow definition

Web Service DataWindow Definition

PowerBuilder

Web Service

support using

the .NET

engine

Generated

.NET

Assembly

Metadata

DataWindow

Painter

WSDL

A DataWindow

Object


Web service datawindow retrieval

Web Service DataWindow Retrieval

  • Uses existing DataWindow retrieval PowerScript syntax

  • Optional wsconnectionobject supports runtime customization

    • Endpoint

    • User ID and password

    • Timeout

    • Security options

    • Proxy server settings


Web service datawindow updates

Web Service DataWindow Updates

  • Analogous to Stored Procedure update options


Web service datawindow error handling

Web Service DataWindow Error Handling

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


Web service datawindow runtime operation

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


Datawindow enhancements demonstration

DataWindow Enhancements Demonstration


Database connectivity enhancements

Database Connectivity Enhancements

5


Database connectivity enhancements1

Database Connectivity Enhancements

  • New Sybase Adaptive Server Enterprise (ASE) 15 native driver

  • New Microsoft SQL Server native driver

  • Oracle RAC support

  • MobiLink support


Sybase adaptive server enterprise ase 15

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


Microsoft sql server

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


Oracle real application clusters rac

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


Mobilink support

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


Powerbuilder and net

PowerBuilder and .NET

5


Powerbuilder s 4 phase net integration initiative

PowerBuilder’s 4-Phase .NET Integration Initiative

  • Web Services (PB9)

  • DataWindow .NET (PB10 Timeframe)

  • .NET Deployment (PB11)

  • .NET Resource Consumption (PB12)


Powerbuilder net compiler internals

PowerBuilder .NET Compiler Internals

  • Deployment relies on .NET SDK’s C# compiler

  • Execution relies on PowerBuilder .NET System Libraries

PB2CS

PBL Files

C# Code

.NET

Application

Generates

Depends On

References

PowerBuilder

.NET Compiler

Framework

PowerBuilder

System Library

for .NET


Deploying net applications web form applications in asp net 2 0

Deploying .NET Applications:Web Form Applications in ASP.NET 2.0

20


Architecture net web form applications

Sybase.PowerBuilder.Web.DLL

Sybase.PowerBuilder.Common.DLL

Sybase.PowerBuilder.Interop.DLL

Sybase.PowerBuilder.Core.DLL

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


What happens at deployment

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


What powerbuilder features are supported

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


What powerbuilder features are not supported

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


Net web form application demonstration

.NET Web Form Application Demonstration


Deploying net applications windows form and smart client applications

Deploying .NET Applications:Windows Form and Smart Client Applications

30


Architecture net windows form applications

Sybase.PowerBuilder.Win.DLL

Sybase.PowerBuilder.Common.DLL

Sybase.PowerBuilder.Interop.DLL

Sybase.PowerBuilder.Core.DLL

Architecture:.NET Windows Form Applications

Compiles to

PB Windows Form

Application

PB 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


Powerbuilder net windows form applications

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


Powerbuilder net smart client support

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


Comparison among rich thin and smart clients

Comparison Among Rich, Thin, and Smart Clients


Powerbuilder net smart client support1

PowerBuilder .NET Smart Client Support

  • Occasionally connected

    • PowerBuilder with MobiLink

  • Always up-to-date applications

    • PowerBuilder’s “Intelligent Update”

  • Maximize performance using client resources

    • PowerBuilder applications deployed as Windows Form (Rich Client)

  • Communicate utilizing Web Services

    • PowerBuilder’s Web Service DataWindow

  • Utilize network resources

    • PowerBuilder’s Web Service DataWindow

    • PowerBuilder’s “Intelligent Update”

    • PowerBuilder with MobiLink


Mobilink synchronization overview

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


Mobilink synchronization architecture

MobiLink Synchronization Architecture


Intelligent update overview

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


Deployment model

Deployment Model

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


Net windows form smart client demonstration

.NET Windows Form/Smart Client Demonstration


Consuming net resources powerbuilder 11 net interoperability

Consuming .NET Resources:PowerBuilder 11 .NET Interoperability

10


Net interoperability

.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


Powerbuilder 11 net interoperability demonstration

PowerBuilder 11 .NET Interoperability Demonstration


Creating net resources deploying nvos as net assemblies

Creating .NET Resources:Deploying NVOs as .NET Assemblies

10


Deploying nvos as net assemblies

Deploying NVOs as .NET Assemblies

  • .NET Assembly Target type

  • PowerScript data types automatically mapped to C#

  • Integrated .NET debugger support


Your presenters

Sybase.PowerBuilder.Win.DLL

Sybase.PowerBuilder.Common.DLL

Sybase.PowerBuilder.Interop.DLL

Sybase.PowerBuilder.Core.DLL

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


Deploying nvos as net assemblies demonstration

Deploying NVOs as .NET Assemblies Demonstration


Creating net resources deploying nvos as net web services

Creating .NET Resources:Deploying NVOs as .NET Web Services

15


Deploying nvos as net web services

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


Your presenters

Sybase.PowerBuilder.Web.DLL

Sybase.PowerBuilder.Common.DLL

Sybase.PowerBuilder.Interop.DLL

Sybase.PowerBuilder.Core.DLL

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


Deploying nvos as net web services demonstration

Deploying NVOs as .NET Web Services Demonstration


Future powerbuilder technology showcase

Future PowerBuilder Technology Showcase

10


Windows presentation foundation wpf

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


Wpf datawindow demonstration

WPF DataWindow Demonstration


Wpf datawindow demonstration1

WPF DataWindow Demonstration


Get started with powerbuilder 11 now

Get Started with PowerBuilder 11 Now!

5


Your presenters

Moving to PowerBuilder 11 Class at TechWave 2007

  • Stay in touch with Sybase’s new direction in web development for today’s most demanding web applications

  • As a seasoned PowerBuilder developer, this course will help you learn PowerBuilder’s 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


Your presenters

Thank you!


  • Login