PowerBuilder Authors: Chris Pollach, Yeshim Deniz, Jayaram Krishnaswamy, Kevin Benedict, Avi Rosenthal

Related Topics: PowerBuilder

PowerBuilder: Blog Feed Post

OSUG Two-Day Event

The group is composed of over 400 members

** Ottawa Sybase User Group - December Meeting **


The Ottawa Sybase User Group has been in existence since 1993 and was formerly known as the Ottawa PowerBuilder User Group until its current name change in 2003. OSUG's mission is to create a Sybase community in the National Capital of Canada where users can share knowledge, experiences, and best practices on various Sybase products. The group is composed of over 400 members that represent Database, Design, Architecture, Application Server, Mobility and Development Tool product lines. The strongest representation currently is in the PowerBuilder area as there are over 4,000 licenses of the product alone in the Canadian Federal Government.Sybase Futures

The Ottawa Sybase User Group’s last meeting was on December 1st and 2nd, 2009. For the first time in OSUG’s history this was a two day event that spanned two streams – one focused on PowerBuilder 11.5 on day 1 and PowerBuilder 12.Net on day 2. The second stream was focused on Data Management but only ran for the first day of the two day event. The event was sponsored by Appeon, Bradmark, Novalys, Sybase and ISUG, The first presenter was Sybase VP of Database Product Development, Mr Brian Vink who presented to both the PowerBuilder and Data Management groups together as the key note speaker. Brian’s presentation was entitled “Sybase State of the Nation” and covered Sybase’s current product strategic directions in the areas of Mobility, DBMS (ASE and SA), Development & Modelling tools, Data Warehousing, and new product horizons. Some of the interesting information conveyed was that in the last quarter Sybase has had a 20% increase in new PowerBuilder licenses and Data Management product growth is ahead of the nearest completion by a factor of 3:1 – both up significantly over the previous year. After this key note address, each group split in their respective streams for presentations focused towards their area of interest.

The event was also a great place to meet our new Sybase partner in Ottawa, who is Mr. Bill Lobban and owns Bill LobbanPurePoint Consulting. PurePoint delivers solutions to help ensure business and information availability. They provide: Business Continuity, Disaster Recovery Planning; Project Development and Management; Strategic and Technical Consulting; and the Essential Hardware and Software solutions to help meet business needs. PurePoint has now been registered on the Canadian Federal Governments supply arrangement and can provide any federal government department right across Canada with Sybase software solutions. Bill was able to meet with various OSUG and partner attends at the last OSUG meeting to introduce himself and PurePoint. For more information on PurePoint Consulting, have a look at the PurePoint website. You can find Bill’s contact information on the web site under the “Contact Us” section. OSUG would like to welcome PurePoint and Bill into the Sybase arena.

Data Management

For the Data Management track on the first day, OSUG had the privilege of hosting Ms Cindy Bean from Bradmark along with Mr. Anthony Robinson and Mr. Matt Creason from Sybase Canada and USA respectively. Matt spoke to the attendees about Enterprise Architecture vs Enterprise Information Architecture that places the focus on Meta Data Management. Once you have a repository of your information assets you can quickly do impact analysis for business agility and change management; traceability and standards for Regulatory Compliance and; process alignment and integration to support Service Oriented architecture goals. Cindy presented the audience with Bradmark’s phenomenal monitoring tool for the ASE DBMS called Surveillance. This is one of Bradmark’s award winning products that can perform event management, data flash back, real time diagnostics, and historical repository of c hanges. Anthony gave us a look at Sybase’s new Replication Server version 15.2 that can bi-directionally replicate data between any major DBMS on the market today and not just ASE to ASE. Speaking with the DM stream attendees though many of them were really impressed with Anthony’s presentation on Sybase’s IQ and in particular the SUP (Sybase’s Unwired Platform). SUP addresses the challenge of creating and managing multiple mobile applications that securely connect a variety of heterogeneous back-end data sources to all major device types.

Since the meeting was held in December, many OSUG members took this opportunity during the vOSUG Membersarious breaks and lunch to wish each other the best of the season. Lunch was graciously sponsored by ISUG and their partners and consisted of a first class buffet of various sandwiches, pastries, salads and beverages. This also allowed the members to connect with the presenters and various Sybase personnel present at the event. Judging by the various discussions and feverous drawing on serviettes, there was allot of information exchange going on as well about numerous products. This is certainly a great benefit to attending a local user group meeting.

In attendance for the event first day were just over 70 attendees from various IT disciplines that included IT management, analysts, developers, project managers, independent consultants, architects, consulting firm technical representatives, etc. Some attendees even travelled to Ottawa from Montreal, Toronto and, even as far away as Vancouver and Buffalo New York. The event was officially opened by OSUG’s president Chris Pollach who spoke about ISUG, local Sybase news, OSUG direction, and a special mini-report entitled “Chris`s Technology Watch”.


Chris then had a special activity prepared for John Strano one of the key PowerBuilder presenters. Chris usually starts the meetings off with a small Martial Arts demonstration to show how a technique or way of doing something can make a person much more powerful for a self-defence move against an attacker. Of course, this is always an analogy towards the “Power” in PowerBuilder where using such tools at the DataWindow makes your development life so much easier. In these cases Chris often asks John Strano to join him for the demo as the “Vana White” participant to demonstrate on. However, this time Chris had John break some boards to demonstrate how a certain technique can make you more effective in delivering a more powerful blow. To aid in this matter, Chris invited his Martial Art instructor Master Stephen Yeoh a 6th degree black belt in TaeKwonDo to advise John on how to proceed. Amazingly enough, John was able to break the board held by Chris on the first try with a reverse knife hand strike! For this great accomplishment Master Yeoh and Chris (2nd degree black belt) presented John with an Honorary Black Belt and certificate. This whole process was a great crowd pleaser for the OSUG attendees who encouraged John through-out the demonstration. Well done John! Next year concrete stones maybe?

In the first presentation of the Development tools track saw Mr Armeen Mazda who was a key member of the initial team that founded Appeon Corporation back iArmeen Mazdan 1999 and is currently its CEO & President. Armeen presented two topics for the balance of the morning which were Rich Internet Application Development Made Easy with PowerBuilder & Appeon and Learning from a Highly Transactional & Available Web Business Application. The presentations were extremely interesting and drew many questions from the attendees. The focus on webification was definitely a key focus for many of the PowerBuilder developers as their current work assignments and their IT management have been directing them in that direction. Armeen was also able to relate to his customer base and gave many tips, techniques, approaches and traps that comprised some great lessons learned information.

During the presentations from Armeen, he was also able to break into actual demonstrations of he Appeon web development platform that is integrated with PowerBuilder. Interesting points were made that not only does Appeon take you to Webform applications super fast with all of Appeons special run time optimization but, the development time is 4:1 better in terms of lines of code and time and; Appeon with PowerBuilder applications can be done with a 8 times better cost ratio that MS.Net products. These were statistics gathered from actual projects using Appeon and Visual Studio. All in all, a most impressive product that held the OSUG members attention. Armeen was able to stay for the entire two day session and even on the 2nd day was giving more demonstrations in the Sybase Canada board room that Sybase donated for OSUG use during the two day event. For more information on Appeon, please visit the Appeon web site.

The second presenter for the afternoon in the Development Tools stream was Mr John Strano from Sybase USA. John is one of the key evangelists on the PowerBuilder team for Sybase. On day one, John focused oJohn Stranon the current production release of PowerBuilder (version 11.5.1) and the theme of his presentations was “Solving your Top Business problems today with PowerBuilder”. John worked through many business scenarios and how PowerBuilder today could be used to easily solve these problems. John did this by using a “Hands On Challenge” feature where he worked through eight different business scenarios that your IT management might ask a PowerBuilder developer to perform in handling some of today’s common requests. The challenges covered such things as: Exposing logic of a business object as a .NET Web Service; Exposing my current application logic to my .NET peers; We need to build Web Services, use ‘em, and manage them; Management wants a new application written for the Web; We must move our current PB applications to the Web, Publish your traditional application as a .NET Smart Client application; and, PowerBuilder applications can get a face lift in no time. During the challenges, John was able to break away and build and demonstrate with PB 11.5.1 how this can be actually done. This seemed to be a real eye opener for some developers and especially the IT managers who attended!

On Day 2 of the OSUG event, only the development stream continued but was action packed with presentations and information. The Sybase Canada board room continued to be open for one-on-one presentations and questions to all our guest presenters. On tap for the entire morning program was Mr Christophe Dufourmantelle who founded Novalys in 1998 and has run the company from that point in time. Christophe focused on the various product offerings and many new recent releases of these items to the PowerBuilder community. This was of great interest to many of the OSUG attendees as they currently use one or more of Novalys’s products currently. Christophe first explored the application mining tool called Visual Expert. At the time of the OSUG meeting, Visual Expert 6.0 was recently released and Christophe was able to take the audience through a detailed tour of the new feature set. ChristopheVE 6.0 now supports PB 11.5.1 and is used in many sites around Ottawa (PWGSC, Supreme Court, Passport, Elections, etc for example). The next product he spoke about is a brand new tool called PBProtect. This product addresses the area called Obscurification where the application executables are basically scrambled so that it cannot be decompiled. This would be very beneficial for applications that perform unique processing and contain special algorithms, business process logic or security checking for example that you would not want anyone to reverse engineer. PBProtect actually scrambles the PowerScript code by tokenizing it just as it enters the compilation stage – which Christophe then demonstrated.

The next presentation was on a product named VisualGuard. This product wrappers an existing PowerBuilder application and imposes security by user, role, data value, etc without recoding the application. What was on interest in the new release of VG is the new Enterprise version that can perform this feat on not only PowerBuilder, but Java and Visual Studio applications as well. So now you have one-stop shopping for application security in the major development languages and one common repository for all their security control. After a demonstration of VG, Christophe moved on to the new Customization Studio product. This is a new aspect to VisualExpert and allows for customization of the product’s use, extra reporting, special name checking, etc features that an organization may want. Novalys is also planning to release common customized modules that will be downloadable to existing customers so that they can be shared.  Christophe then demonstrated how customization worked and then entertained a Q&A session on the Novalys product suite. For more information on Novalys and its PowerBuilder product line please visit the Novalys web site. At this point in the event, Chris Pollach with the help of the presenters held a draw for various door prizes and then the attendees broke for lunch.

OSUG Lunch

The last part of Day 2 was dedicated to PowerBuilder 12.Net. John Strano returned wearing his newly acquired black belt to give the audience a detailed live tour of PB 12.Net. John covered the overview of the PB 12 release that will encompass InfoMaker 12, PB 12 Classic and PB 12.Net. Those customers who have the Enterprise version of PowerBuilder will receive all three of these products on the install DVD. John then proceeded with an overview of the new types on controls in PB 12.NET and the fact that all the standard PB Controls now are descendants of actual .NET cOSUG 2 Day eventontrols. So the behaviour and feature set of every control is a true .NET behaviour yet, Sybase has still retained certain features on PB controls that offer unique behaviour. Of course the DataWindow is still its own unique control but has a refactored code line to now be true WPF (Windows Presentation Foundation) member. The DW object is now true .NET managed code where as in PB 11.x, the DW was unmanaged code and thus had some restrictions on its feature set and execution privileges. This now makes the DW object a fully compliant .NET custom control.

The next significant change (among many) for PB 12.NET is the departure from the PB 11.x IDE shell and adoption of the .NET Isolated shell that Visual Studio uses as its IDE. The change to the Microsoft IDE allows PB to: leverage more of the .NET framework; capitalize on assimilating 3rd party WPF controls; add “intellisense” and collapsing code blocks; position PB to take advantage of emerging technologies such as Silverlight; support for fully managed executable code generation and even support for 64bit MS-Windows just to highlight a few key areas. During the PB 12.NET talk, John was able to demonstrate the PB 12.NET IDE and run some example applications that emphasized these areas. The new software was “without a doubt” captivating to hear and watch for the all the OSUG members.


The next area on the PB 12.Net tour was the new vector graphics, DW graph types such as Cone, Radar, Scatter, etc along with Application Skins. All these new features are now possible for PB 12 being a true .NET citizen. John as able to walk the attendees through the design and coding steps needed to use these new features. For those OSUG members who were already in the Beta program and brought their copy of PB 12.NET on their laptops, John was able to share code examples and help the members get these features working on their own machines. This was an excellent hands-on training session for those who attended! During the presentations, demonstrations and code example walk through, John lived up to his theatrical background and amused the crowd with stories, anecdotes and light humour which made for a very entertaining afternoon that I am sure all would agree.

The afternoon session witnessed 43 attendees who were primarily PB developers who got a great look at intellisense, collapsing code blocks, new object browser, etc while John was able to gather great feedback from the audience for engineering of what they would like in the final production product. The next section covered the XAML language and how PB 12.NET can incorporate 3rd party controls based on this technology. The next section covered the new WPF design painter that replaces the Window painter and some of the nuances when converting to this technology paradigm.John's presentations

John then covered the considerations for migrating an existing older PB Win32 application over to the new PB 12.NET WPF architecture. He stated that it is Sybase’s intention to have this as automated as possible so that rewriting an older application will not be necessary. To backup his point, John demonstrated a migrated Win32 application now running as a WPF based one from within PB 12.NET – a true testimate to Sybase’s commitment in this area. Chris Pollach pointed out that Microsoft developers moving from Visual Basic version 6.x to VB.Net already have to rewrite their applications. VB developers will again have to rewrite or do significant enhancements to their VB.Net applications to assimilate the WPF environment. Whereas, PowerBuilder developers will enjoy the ease-of-migration in version 12 as they did in any other previous release.

PB 12.NET now also include visual inheritance that even the new VS2010 does not even support! VS developers today and with the new release this year must still control inheritance via code (my how archaic!). Couple this with a WPF based DataWindow and one can see the enormous productivity gains possible with this PB 12.NET based technology direction. When asked about the debugging capabilities of PB 12.NET, John demonstrated the use of the VS debugger in PB 12.Net as it is integrated through the .NET framework and the common VS shell IDE. However, Sybase has made the interaction with the debugger more intuitive to use as in previous PB releases.OSUG Meeting

Overall, the attendees of the PB 12.NET training session were very impressed with Sybase’s PB direction and the fact that engineering has been proactive in informing the customer base about their efforts thus far. John iterated that PB 12.NET also has WCF - Windows Communication Facility capabilities and is now able to directly inherit from native .NET controls. Stay tuned for more road shows planned from Sybase focused on the new PB 12.NET product and technologies. Visit the Sybase news groups and the main Sybase and ISUG web sites for more information on these venues. From all the OSUG members here in Canada’s national Capital ... thanks John, for a great presentation, guided test drive and hands-on education! OSUG would also like to that OSUG member Michael Lessard who took many of the pictures at the two day event. When not coding in PowerBuilder Michael is an accomplished wedding photographer – so if you need some expert photographs done, please contact Chris Pollach for Michaels contact information.

Again a great big thank you to Sybase Canada, its Partners, ISUG and Sybase US marketing and engineering for helping OSUG make this its most memorable event ever.


Regards ... Chris

Read the original blog entry...

More Stories By Chris Pollach

Chris Pollach is a Senior Consultant with over 30 years experience in Systems and Software Analysis, Development, Maintenance and Technical Support, mainly in the areas of GUI Design, MS-Windows Programming, Java / .NET Programming, Wireless, Application / Web Server Design & Programming, Object Oriented Development Tools and Methodologies, Data Base, Data Communications and Network application development. He has participated in numerous technical, planning and management roles, as well as consulted and educated in these fields for a diverse clientele. He is also the owner of “Software Tool & Die Inc.” a company dedicated to provide custom software and education solutions on Object Oriented business systems.

As an educator, Chris is certified to teach PowerBuilder (first in Canada), MS-SQLServer, Sybase’s Enterprise Application Studio and EAServer integrated application/web development environment. He is former Certified SilverStream developer (CSSD) and current Certified PowerBuilder Developer – Associate / Professional (CPD-P) as well as a Certified Sybase Tools Instructor (CSI).

Chris has written numerous articles in various popular personal computer magazines, newsletters and is the author of the PowerGuide and PowerExpert products as well as the STD Foundation Classes. Currently, Chris has developed a Foundation Class library for Sybase's PocketBuilder, SAP's PowerBulder and EAServer products and now Appeon Web & mobile products that integrates JSP or ASP web development, Section 508 / CLF web standards and mobile applications. A new Web Service framework has also been released for IIs to support PowerBuilder based web service NVUO's!

Chris recently became a 2nd Degree Black in the TaeKwonDo martial art and has developed a Martial Art multimedia study guide using the Component-One “Doc2Help” and Sybase PowerBuilder products. Since the fall of 2004 he became a TaeKwonDo instructor for the City of Ottawa’s Goulbourn program. He has also been certified with the World TaeKwonDo Federation (February 2005 - 1st Dan and October 2008 - 2nd Dan).

Chris was awarded the Sybase “Innovation and Achievement” award for 2005 as voted for by the International Sybase User Group (ISUG). This award was presented for innovations to the PocketBuilder mobile development product, contributions to the PowerBuilder News groups and support of the Ottawa Sybase User Group.

To round his management and leadership skills, Chris is the former president of the Kiwanis Club of Goulbourn and still volunteers his time with the service clubs in his area. He is also the coordinator of the Ottawa Sybase User group and a certified NAUI scuba instructor. For the last three years, Chris has been voted onto the ISUG Board of Directors and holds the position of "Director - North American User Groups".