1 / 78

Your Presenters

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

perry
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Your Presenters Dave Fish – Engineering Evangelist Jim O’Neil – 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. 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

  8. 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

  9. 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

  10. 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

  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 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

  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 wsconnectionobject 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. PowerBuilder’s 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 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

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

  45. 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

  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 Applications:Windows Form and Smart Client Applications 30

More Related