1 / 75

Your Presenters

Your Presenters. Dave Fish – Engineering Evangelist Jim O’Neil – Sales Evangelist John Strano – PowerBuilder Evangelist. PowerBuilder Market Focus and Road Map. 15. Market Focus – Sybase Goals . Attract next generation of application developers

maddy
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 – PowerBuilder Evangelist

  2. PowerBuilder Market Focus and Road Map 15

  3. Market Focus – Sybase Goals • Attract next generation of application developers • Focus on .NET and Eclipse platforms to extend reach • Support Sybase servers as key to Sybase platform success • 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 • Newest member of the PowerBuilder family • Deploy PowerBuilder objects to J2EE application servers • PocketBuilder • 4GL RAD for mobile devices • Build data-driven mobile applications in less than one hour • DataWindow .NET • 4GL productivity in Visual Studio .NET • Extend the Sybase reach into the Microsoft market

  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 • Leverage/extend PB investment • UI/IDE updates • Native SQL Server support PowerBuilder Roadmap Simplified development for today 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 rebuild • Smart Client for Win32 • EAServer .NET support • Additional AJAX-style functionality • .NET support for Pipeline • Informix 10 support • Deploy applications and NVOs to .NET • Leverage/extend PB investment • UI/IDE updates • Native SQL Server support PowerBuilder Roadmap Simplified development for today, tomorrow Language Independence Application Connectivity Multiple Platform Support Power And Performance

  9. 2007 PowerBuilder 11.0 2007 PowerBuilder 11.1 2008 PowerBuilder 12 .NET Simplified .NET Enhanced .NET Exploited • .NET incremental rebuild • Smart Client for Win32 • EAServer .NET support • Additional AJAX-style functionality • .NET support for Pipeline • Informix 10 support • Deploy applications and NVOs to .NET • Leverage/extend PB investment • UI/IDE updates • Native SQL Server support • .NET in IDE • WPF/WCF support at design time and runtime • Fully managed code at deployment • Complete .NET interoperability PowerBuilder Roadmap Simplified development for today, tomorrow, and beyond Language Independence Application Connectivity Multiple Platform Support Power And Performance

  10. PowerBuilder 11 Features 15

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

  12. IDE and User Interface Enhancements 10

  13. IDE Enhancements • AutoScript

  14. IDE Enhancements • AutoScript • Resizable dialog boxes

  15. IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars

  16. IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree

  17. IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree • Project painter

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

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

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

  21. DataWindow Enhancements 10

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

  23. Display Ellipsis for Truncated Data

  24. Retain DataWindow Retrieval Arguments • Stored with target information in registry • Not applicable at runtime

  25. Web TreeView DataWindow

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

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

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

  29. 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 setttings

  30. Web Service DataWindow Updates • Analogous to Stored Procedure update options

  31. Web Service DataWindow Error Handling • New WSError event is analog of existing DataWindow DbError event when using a Web service data source

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

  33. DataWindow Enhancements Demonstration

  34. Database Connectivity Enhancements 5

  35. Database Connectivity Enhancements • New Sybase Adaptive Server Enterprise (ASE) 15 native driver • New Microsoft SQL Server native driver • Oracle RAC support • MobiLink support

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

  37. 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 reinstated previous MSS native driver

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

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

  40. PowerBuilder and .NET 5

  41. PowerBuilder’s 4-Phase .NET Integration Initiative • Web Services (PB9) • DataWindow .NET (PB10 Timeframe) • .NET Deployment (PB11) • .NET Resource Consumption (PB12)

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

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

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

  45. What Happens at Deployment • PowerScript code is compiled to a .NET assembly • PBDs with DWO definitions 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

  46. 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 releaseExceptions: • File operations: File Manager • Sending e-mail (via SMTP not MAPI): Mail Manager • DataWindow printing: Print Manager

  47. 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 / OLECustomer Control (partial support) • InkPicture /InkEdit • Drag-and-drop events • EditLabels of TreeView

  48. .NET Web Form Application Demonstration

  49. Deploying .NET Applications:Windows Form and Smart Client Applications 30

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

More Related