Click here to close now.


SAP HANA Cloud Authors: Elizabeth White, Pat Romanski, Liz McMillan, Anders Wallgren, Teresa Schoch

Blog Feed Post

PowerBuilder Goes NHL

 ** Hot News **

     At the last Ottawa Sybase User Group (OSUG) meeting we had a surprise guest presenter arranged by OSUG president Chris Pollach. This also included a demonstration of a special PowerBuilder application that was written to – you might not believe this – run and emulate any standard NHL Hockey Scoreboard. Yes, you read that correctly, interface to a very complicated score board hardware system. Obviously, this is not your average PowerBuilder application but one that long time PB enthusiast Chris Pollach likes to show case as Chris has always maintained that “you can build any type of Windows application using PowerBuilder”! To that end, Chris has proven that aspect over and over again with applications like multi-media players, Application / DB Server Monitors, SQL Extraction & Analysis utilities, DataWindow Changer, Code Commenter, MS-Agent, O/S System Resource Introspection, and many more bizarre applications that most people would not at first consider PowerBuilder for.

This system is another excellent example of what Roland Smith of TopWiz Software likes to say “Anything is possible given enough time, money and Mountain Dew”! In this case, we have Mr Jeff Courtice of CourByte Consulting Group Inc who pushed the outside envelope of what typical applications PowerBuilder developers might build. Jeff, a long time PB consultant in Canada’s National Capital area who has worked on elite PowerBuilder applications like Elections Canada System that runs all federal elections right across Canada - decided that he wanted to take a break from these high-end business systems and build something that he wanted PowerBuilder to solve. In his case, after being involved with minor hockey due to his son’s participation in the sport and Jeff’s frustration with dealing with the various scoring systems decided to “build a better mouse trap” in the form of more intelligent scoreboard application software!

A few years ago Jeff decided to start an application that would emulate a hockey scoreboard as he found in real life; as these systems can be quite varied, hard to learn for the novice, poorly documented as their operation and offer no proper training along with their products. To this end, Jeff built a PB application that would visually display the various popular scoreboards including their control panels. Then the application would guide the user through the mechanics of how that scoreboard worked and allowed the student to actually score a virtual game and see how the scoreboard would react to the various inputs. In a few months, Jeff had a basic emulation working of a typical scoreboard. With this early success, Jeff decided to continue his endeavour adding more scoreboard types and better simulations. Then, another revelation occurred to Jeff ... why not build his own scoreboard and challenge the actual manufactures of the current hardware! To this end, Jeff decided to build a new product called Time-Keeper Professional or TKP for short. Thus Timekeeper-PRO ( TKP) was born and is a software program developed in Powerbuilder 11.5 and SQL Anywhere 11 to run on a standalone computer in the timekeeper/scorekeeper’s booth in hockey games.  It will perform the role of expert timekeeper/scorekeeper where none exists.  Timekeeper-PRO was designed from the ground up to be a simple to use tool that would automatically make any timekeeper/scorekeeper an expert without having to know the myriad rules of hockey as they apply to off-ice officiating. Many seasoned PN developers do not realize that simple RS232 serial port communication can be accomplished in PB by using the FileOpen, FileRead and FileWrite built-in commands. You can actually open any PC’s COM port via the FileOpen command and then read and write data streams to any device listening on the port. Typical devices could be cash registers, RFID programmers, security systems and oh, of course – hockey scoreboards.

Anyone who has ever been involved in timekeeping and score-keeping in a hockey game when the game gets intense and there are many penalties being tracked concurrently knows that the job can get extremely difficult and pressure packed.  Timekeeper-PRO’s approach was to simplify the timekeeper/scorekeeper’s life is straightforward.  Simply enter data corresponding what the on-ice referees say and the software will do the rest without any knowledge of the rules.  Among many other features, TKP will automatically track offsetting penalties and will automatically determine such things as when an extra player is required to sit for another player’s penalty.  TKP will automatically generate the game-sheet thereby eliminating the need to hand scribe the information during the game.  TKP clearly displays time remaining for penalties that are not displayed on the scoreboard – ie – off setting penalties and it will automatically adjust them when necessary as goals are scored.  TKP also has an integrated communications component responsible for distributing near real-time game statistics to registered email recipients and to league websites.

Over the course of the TKP development process a separate initiative was undertaken to design and build a fully functioning and complete electronic scoreboard to be controlled by TKP.  This was undertaken as joint venture between the Ontario Centre of Excellence (OCE), Algonquin College and Courbyte Consulting Group.  As part of the College’s Electronics Technologist program, four electrical engineering students were tasked with the job of designing and building the scoreboard.  They were successful in their task and were awarded first place amongst all Ontario colleges participating in the OCE program.  In addition to building a full sized scoreboard (12’x5’ and 300 lbs), a mini-scoreboard was also designed and built to use as a proof of concept and also as a sales tool for displaying at trade shows where space is expensive and most often at a premium.

Timekeeper-PRO has now been extensively tested at the junior hockey level where the frequent need for tracking multiple penalties and goals is prevalent.  Timekeepers that have assisted in the testing of this revolutionary new product have been amazed at the power of the product and often are heard to say “that it’s about time a product like this was developed to make timekeeping and score keeping a less onerous task”. Jeff has now decided that not only does he have a product that can easily control any major commercial scoreboard system – he now has actual scoreboard hardware that he estimates could be built at a fraction of the price many commercial systems are priced at today. To this end, Jeff is now talking to potential electronic manufactures that might be interested in taking on his design.

The latest version of TKP has even grown the functionality further by allowing the application to post the current hockey game statistics to the internet where Jeff has another PB application that can display the current game vitals on his website, email parents who cannot attend that their son or daughter has scored a goal and even print out official game reports that can be sent into the various hockey leagues. Jeff also has a “ton” more ideas for this unique PowerBuilder application for sure and OSUG members were exceptionally impressed with his system. Even SAP Sybase Technical Evangelist John Strano in attendance at the last OSUG meeting was also suitably impressed over Jeff’s scoreboard application.

For more information on the TKP application, have a look at the YouTube video of the actual TKP application in action at To experience the actual TKP training emulator application, have a look at this YouTube video:
Also, feel free to drop Jeff an email as well for more information on TKP ( or to just cheer him on in this unique endeavour!

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

@ThingsExpo Stories
WebRTC: together these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at WebRTC Summit, Cary Bran, VP of Innovation and New Ventures at Plantronics and PLT Labs, will provide an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it may enable, complement or entirely transform.
SYS-CON Events announced today that Dyn, the worldwide leader in Internet Performance, will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Dyn is a cloud-based Internet Performance company. Dyn helps companies monitor, control, and optimize online infrastructure for an exceptional end-user experience. Through a world-class network and unrivaled, objective intelligence into Internet conditions, Dyn ensures traffic gets delivered faster, safer, and more reliably than ever.
WebRTC services have already permeated corporate communications in the form of videoconferencing solutions. However, WebRTC has the potential of going beyond and catalyzing a new class of services providing more than calls with capabilities such as mass-scale real-time media broadcasting, enriched and augmented video, person-to-machine and machine-to-machine communications. In his session at @ThingsExpo, Luis Lopez, CEO of Kurento, will introduce the technologies required for implementing these ideas and some early experiments performed in the Kurento open source software community in areas ...
Too often with compelling new technologies market participants become overly enamored with that attractiveness of the technology and neglect underlying business drivers. This tendency, what some call the “newest shiny object syndrome,” is understandable given that virtually all of us are heavily engaged in technology. But it is also mistaken. Without concrete business cases driving its deployment, IoT, like many other technologies before it, will fade into obscurity.
Today air travel is a minefield of delays, hassles and customer disappointment. Airlines struggle to revitalize the experience. GE and M2Mi will demonstrate practical examples of how IoT solutions are helping airlines bring back personalization, reduce trip time and improve reliability. In their session at @ThingsExpo, Shyam Varan Nath, Principal Architect with GE, and Dr. Sarah Cooper, M2Mi's VP Business Development and Engineering, will explore the IoT cloud-based platform technologies driving this change including privacy controls, data transparency and integration of real time context w...
Who are you? How do you introduce yourself? Do you use a name, or do you greet a friend by the last four digits of his social security number? Assuming you don’t, why are we content to associate our identity with 10 random digits assigned by our phone company? Identity is an issue that affects everyone, but as individuals we don’t spend a lot of time thinking about it. In his session at @ThingsExpo, Ben Klang, Founder & President of Mojo Lingo, will discuss the impact of technology on identity. Should we federate, or not? How should identity be secured? Who owns the identity? How is identity ...
The IoT market is on track to hit $7.1 trillion in 2020. The reality is that only a handful of companies are ready for this massive demand. There are a lot of barriers, paint points, traps, and hidden roadblocks. How can we deal with these issues and challenges? The paradigm has changed. Old-style ad-hoc trial-and-error ways will certainly lead you to the dead end. What is mandatory is an overarching and adaptive approach to effectively handle the rapid changes and exponential growth.
The buzz continues for cloud, data analytics and the Internet of Things (IoT) and their collective impact across all industries. But a new conversation is emerging - how do companies use industry disruption and technology enablers to lead in markets undergoing change, uncertainty and ambiguity? Organizations of all sizes need to evolve and transform, often under massive pressure, as industry lines blur and merge and traditional business models are assaulted and turned upside down. In this new data-driven world, marketplaces reign supreme while interoperability, APIs and applications deliver un...
Electric power utilities face relentless pressure on their financial performance, and reducing distribution grid losses is one of the last untapped opportunities to meet their business goals. Combining IoT-enabled sensors and cloud-based data analytics, utilities now are able to find, quantify and reduce losses faster – and with a smaller IT footprint. Solutions exist using Internet-enabled sensors deployed temporarily at strategic locations within the distribution grid to measure actual line loads.
The Internet of Everything is re-shaping technology trends–moving away from “request/response” architecture to an “always-on” Streaming Web where data is in constant motion and secure, reliable communication is an absolute necessity. As more and more THINGS go online, the challenges that developers will need to address will only increase exponentially. In his session at @ThingsExpo, Todd Greene, Founder & CEO of PubNub, will explore the current state of IoT connectivity and review key trends and technology requirements that will drive the Internet of Things from hype to reality.
The Internet of Things (IoT) is growing rapidly by extending current technologies, products and networks. By 2020, Cisco estimates there will be 50 billion connected devices. Gartner has forecast revenues of over $300 billion, just to IoT suppliers. Now is the time to figure out how you’ll make money – not just create innovative products. With hundreds of new products and companies jumping into the IoT fray every month, there’s no shortage of innovation. Despite this, McKinsey/VisionMobile data shows "less than 10 percent of IoT developers are making enough to support a reasonably sized team....
You have your devices and your data, but what about the rest of your Internet of Things story? Two popular classes of technologies that nicely handle the Big Data analytics for Internet of Things are Apache Hadoop and NoSQL. Hadoop is designed for parallelizing analytical work across many servers and is ideal for the massive data volumes you create with IoT devices. NoSQL databases such as Apache HBase are ideal for storing and retrieving IoT data as “time series data.”
Today’s connected world is moving from devices towards things, what this means is that by using increasingly low cost sensors embedded in devices we can create many new use cases. These span across use cases in cities, vehicles, home, offices, factories, retail environments, worksites, health, logistics, and health. These use cases rely on ubiquitous connectivity and generate massive amounts of data at scale. These technologies enable new business opportunities, ways to optimize and automate, along with new ways to engage with users.
The IoT is upon us, but today’s databases, built on 30-year-old math, require multiple platforms to create a single solution. Data demands of the IoT require Big Data systems that can handle ingest, transactions and analytics concurrently adapting to varied situations as they occur, with speed at scale. In his session at @ThingsExpo, Chad Jones, chief strategy officer at Deep Information Sciences, will look differently at IoT data so enterprises can fully leverage their IoT potential. He’ll share tips on how to speed up business initiatives, harness Big Data and remain one step ahead by apply...
There will be 20 billion IoT devices connected to the Internet soon. What if we could control these devices with our voice, mind, or gestures? What if we could teach these devices how to talk to each other? What if these devices could learn how to interact with us (and each other) to make our lives better? What if Jarvis was real? How can I gain these super powers? In his session at 17th Cloud Expo, Chris Matthieu, co-founder and CTO of Octoblu, will show you!
As a company adopts a DevOps approach to software development, what are key things that both the Dev and Ops side of the business must keep in mind to ensure effective continuous delivery? In his session at DevOps Summit, Mark Hydar, Head of DevOps, Ericsson TV Platforms, will share best practices and provide helpful tips for Ops teams to adopt an open line of communication with the development side of the house to ensure success between the two sides.
SYS-CON Events announced today that ProfitBricks, the provider of painless cloud infrastructure, will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. ProfitBricks is the IaaS provider that offers a painless cloud experience for all IT users, with no learning curve. ProfitBricks boasts flexible cloud servers and networking, an integrated Data Center Designer tool for visual control over the cloud and the best price/performance value available. ProfitBricks was named one of the coolest Clo...
SYS-CON Events announced today that IBM Cloud Data Services has been named “Bronze Sponsor” of SYS-CON's 17th Cloud Expo, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. IBM Cloud Data Services offers a portfolio of integrated, best-of-breed cloud data services for developers focused on mobile computing and analytics use cases.
SYS-CON Events announced today that Sandy Carter, IBM General Manager Cloud Ecosystem and Developers, and a Social Business Evangelist, will keynote at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA.
Developing software for the Internet of Things (IoT) comes with its own set of challenges. Security, privacy, and unified standards are a few key issues. In addition, each IoT product is comprised of at least three separate application components: the software embedded in the device, the backend big-data service, and the mobile application for the end user's controls. Each component is developed by a different team, using different technologies and practices, and deployed to a different stack/target - this makes the integration of these separate pipelines and the coordination of software upd...