760 likes | 888 Vues
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
E N D
Your Presenters Dave Fish – Engineering Evangelist Jim O’Neil – Sales Evangelist John Strano – PowerBuilder Evangelist
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
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
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 • 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)
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
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
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
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 Enhancements • AutoScript
IDE Enhancements • AutoScript • Resizable dialog boxes
IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars
IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree
IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree • Project painter
IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree • Project painter • Output window tabs
IDE Enhancements • AutoScript • Resizable dialog boxes • Updated menus and toolbars • System tree • Project painter • Output window tabs • Exception support in debugger
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 • Display ellipsis for truncated data • Retain DataWindow retrieval argument values • Web TreeView DataWindow • Web Service DataWindow data source
Retain DataWindow Retrieval Arguments • Stored with target information in registry • Not applicable at runtime
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 • 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 PowerBuilder Web Service support using the .NET engine Generated .NET Assembly Metadata DataWindow Painter WSDL A DataWindow Object
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
Web Service DataWindow Updates • Analogous to Stored Procedure update options
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 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
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 • 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 • 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
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 • 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’s 4-Phase .NET Integration Initiative • Web Services (PB9) • DataWindow .NET (PB10 Timeframe) • .NET Deployment (PB11) • .NET Resource Consumption (PB12)
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 20
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 • 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
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
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
Deploying .NET Applications:Windows Form and Smart Client Applications 30
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