2015 Charlotte Conference Session Downloads

You may download the session slide decks and other materials from the links below:

charlotte-conference-logo

If you attended the event, please don’t forget to fill out a feedback form.

Bruce Armstrong

Chris Pollach

Brian Le Suer

Matt Balent

Christophe Dufourmantelle

John Strano

Heino Hellmers

Franck Fasolin

Mike Searer

Kyle Griffis

Ryan Story

Don Clayton

Kay Jenkins

Song Li

Fili Sosa

Armeen Mazda

 

 

New Features in PowerBuilder 12.6

 


Bruce Armstrong

A review of the new features in PowerBuilder 12.6, including:

  • Dockable Windows
  • 64 bit compilation (PowerBuilder Classic)
  • OData support

 

Using PowerBuilder.Net Visual Controls in Visual Studio.Net

 


Bruce Armstrong

A walk-through for creating visual controls in PowerBuilder.Net and then using those controls in a Visual Studio.Net project.

Prerequisites:

  • PowerBuilder.Net 12.5 or later
  • Visual Studio Express 2010 or later

 

Using VS.Net Visual Control in PowerBuilder Classic

 


Bruce Armstrong

A walk-through for using the Microsoft Interop Forms Toolkit for Visual Basic in Visual Studio.Net to create visual user controls that can then be used in PowerBuilder Classic.

Prerequisites:

  • Visual Basic Express 2010 or later
  • Microsoft Interop Forms Toolkit 2.1
  • PowerBuilder Classic 4 or later

 

Using .Net Non-Visual Assemblies in PowerBuilder Classic

 


Bruce Armstrong

A walk-through of creating non-visual assemblies in Visual Studio.Net and then using those assemblies in PowerBuilder Classic via COM Callable Wrappers.

Prerequisites:

  • Visual Studio Express 2010 or later
  • PowerBuilder Classic 4.0 or later

 

Using PowerBuilder Non-Visual Assemblies in Visual Studio.Net

 


Bruce Armstrong

A walk-through for creating non-visual .Net assemblies in PowerBuilder Classic and PowerBuilder.Net, and then using those assemblies in Visual Studio.Net projects.

Prerequisites:

  • PowerBuilder Classic and/or PowerBuilder.Net 11.5 or later
  • Visual Studio Express 2010 or later

 

Bruce Armstrong

 


Bruce Armstrong is a development lead with Integrated Data Services (IDS). Prior to joining IDS ten years ago, he was an independent consultant for 15 years doing PowerBuilder development for companies such as Rockwell, Hughes, Boeing, Western Asset Management, Investment Technology Group and Johnson & Johnson. He has been using PowerBuilder since version 1.0.B. He is a charter member of TeamSybase (formerly TeamPS), a PowerBuilder MVP and an SAP Mentor. He was a contributing author to SYS-CON’s PowerBuilder 4.0 Secrets of the Masters and the editor of SAMs’ PowerBuilder 9: Advanced Client/Server Development. He has contributed numerous articles to the PowerBuilder Developer’s Journal (PBDJ) and the ISUG Tech Journal. He served as the editor-in-chief of PBDJ from 2004 to 2013 and served for a while as a technical editor for the ISUG Tech Journal. He has done sessions on PowerBuilder at most TechWaves since 2004 and at other user group meetings, including meetings in Columbia, Germany, Belgium, Switzerland, England, Italy and France.

Getting started with the “Web Service” STD Foundation Classes Workshop

 


Chris Pollach

This workshop will cover the “Web Service” version of the Software Tool & Die (STD) Foundation Class libraries for PowerBuilder Classic. The attendee will be exposed to the framework, its architecture, services and various features that specifically support the .Net Web Service platform. The workshop will take the attendee from an entry level view to being able to unlock many of the framework’s advanced constructs. This will also include numerous demonstrations of real-life working application code – including how to integrate this with Appeon Web and Appeon Mobile. Attendees are invited to bring their laptops to install the Foundation Classes directly.

Getting started with the “Integrated” STD Foundation Classes Workshop

 


Chris Pollach

This workshop will cover the “Integrated” version of the Software Tool & Die (STD) Foundation Class libraries for PowerBuilder Classic, Appeon Web and Appeon Mobile. The attendee will be exposed to the framework, its architecture, services and various features that support the Win32, Web Browser and iOS/Android mobile platforms. The workshop will take the attendee from an entry level view to being able to unlock many of the framework’s advanced constructs. This will also include numerous demonstrations of real-life working application code. Attendees are invited to bring their laptops to install the Foundation Classes directly.

Building Multi-Threaded Windows Service Applications

 


Chris Pollach

This seminar will expose the attendee to the techniques needed to build a PowerBuilder Classic application and deploy this as an MS-Windows Service component. The approach and implementation techniques of then multi-threading the service for performance and scalability will be reviewed and then how to build an architecture around the Windows Service for RAD development and operational considerations like email notifications, console, debug/tracing, etc. production support.

Developing a Modern Web UI that includes Image Management

 


Chris Pollach

This session will walk the attendee through a Appeon Web application that was developed for a major Canadian government agency for the specific purpose of locating and redacting credit card information to comply with PCI (Payment Card Industry) standards. This application utilized open source Imaging software, web services, CLF (Common Look & Feel) Web Standards, Active Directory, Appeon and ASE technologies. This application is focused on allowing human interaction with images all within a web / mobile application.

Securing your Appeon Mobile/Web Applications

 


Chris Pollach

Enabling your Web and Mobile applications to implement secure communications for sensitive data and transactions is a must in today’s internet based world. This seminar will take the attendee through the steps necessary to build and deploy server and client certificates – then enable trusted connections through Secure Socket Layer communications. This will also include techniques on how to automatically switch your Appeon applications into SSL mode.

Cloudifying your Web/Mobile applications

 


Chris Pollach

The Amazon Cloud platform is a rich environment to host your Web and Mobile applications enabled via Appeon. In this seminar we will take you through the steps to allocate, configure, install and manage an Amazon cloud space that includes Appeon, DBMS, PB Run-Time for Web Services, and your PB Application (including deployment techniques).

 

Extending your PB/Web/Mobile applications via Web Services

 


Chris Pollach

Both PowerBuilder and Appeon can consume web services. However, PowerBuilder Classic can also build .Net web services. This seminar will explore how to build and integrate Web Services within your Win32, Appeon Mobile and Appeon Web applications to infinitely expand their application’s functionality!

How to Webify your existing PB applications (real-world example from Government of Canada)

 


Chris Pollach

This seminar will detail the challenges faced in refactoring an internationally used PowerBuilder Classic Win32 application into a full blown Web application that meets the Government of Canada’s web standards. The seminar will cover PB to Appeon coding adjustments, alternatives, techniques and workarounds to fully webify any PB Classic application.

Fully integrating Active Directory into your PB/Web/Mobile applications

 


Chris Pollach

Single sign-on, password control, application privileges and many other aspects of your PowerBuilder, Web and Mobile applications can be defined in an Active Directory database. This seminar will demonstrate how to unlock the Active Directory sub-system to fully integrate your Win32, Web and Mobile applications into this domain. The seminar will include real world scenarios, coding techniques and demonstrations.

Chris Pollach

 


Chris Pollach is a Senior Technical Solutions Architect with over 30 years of 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. Chris has written numerous articles in various popular personal computer magazines, newsletters and is the author of the PowerGuide, PowerExpert and STD Foundation Class library for PowerBulder, EAServer and Appeon.

Chris is a two time winner of the SAP “Topic Leader” award in the SAP Community Network for PowerBuilder in 2013 and 2014.In his spare time, Chris is also an instructor in the Taekwondo martial art and holds a 2nd degree black belt WTF certification.)

The ‘M’ Word in Test Automation (PDF)

 


Brian Le Suer

“Maintenance” is a dirty word in test automation circles, the “M” word if you will. Test tool vendors don’t like to talk about it because it muddies the clear waters of record/playback and other “ease of use” features that are often touted as silver bullets in the field of Software Quality Assurance. Test automation is supposed to reduce costs while increasing efficiency in a test organization, but test maintenance can quickly erode the return on investment if the approach and framework are not designed to ensure that tests can be modified quickly and easily as the target application changes over time. After all, if our applications were static, there would be no need for automated testing.

Applying Design Patterns to Automated Testing (PDF)

 


Brian Le Suer

A design pattern is a reusable solution to a commonly occurring problem. It provides a description or template of a solution. There are many opportunities to apply design patterns to automated testing to make tests more reusable and easier to maintain. This presentation will explore use of design patterns to solve common problems encountered in automated testing along with code examples. A PowerBuilder application will be used as the target for all examples.

Brian Le Suer

 


Brian Le Suer is the CEO of Zeenyx Software, Inc., a company dedicated to building next generation solutions for manual and automated software testing. AscentialTest provides the ability to build a single set of tests to validate both PowerBuilder and Appeon. Visit www.zeenyx.com to learn about their innovative step-based testing approach.

Utilizing external technology to extend your PowerBuilder Applications (PDF)

 


Matt Balent

Ideas and tips for creating ‘easy’ proof of concept type demonstrations showing how external application functionality can be brought into existing PowerBuilder applications. Barcode readers, scanning, webcam, document processing are just some of the examples which will be shown.

Roll Your Own JSON Parser (PDF)

 


Matt Balent

This session gives participants the opportunity to create their own JSON Parser as a C# COM component which can be consumed within PowerBuilder. The component itself will utilize the open source project JSON.Net. Bring a laptop with Visual Studio installed if you wish to follow along and build this ‘on the fly’.

Datawindow Functionality Enhancement Toolkit (PDF)

 


Matt Balent

This session will demonstrate an easy to use datawindow toolkit to enhance the functionality of existing datawindows within your PowerBuilder applications. Improve your users productivity with low risk and low cost of development.

Matt Balent

 


Matt Balent has been a PB developer since version 5.0. He has presented as numerous conferences and user group meetings and is an avid PB enthusiast. He was named a PowerBuilder MVP in 2012.

Visual Expert 2015 for Oracle and PowerBuilder

 


Christophe Dufourmantelle

Most developers are maintaining applications that they did not originally develop.
They need to understand old and complex code before making any changes.
And when they make a change, they must ensure that they will not break the application because of unexpected side-effects.

This presentation will address these issues: we will use brand-new Visual Expert 2015 to explore PB and Oracle code, run impact analyses, and generate detailed source code documentation.

Visual Expert Workshop

 


Christophe Dufourmantelle

Install and configure Visual Expert in your environment.
Analyse your code and get a free 6 month copy.

Reporting Studio 2015

 


Christophe Dufourmantelle

Business users are now asking for a quick and direct access to their information.
They need to build reports on the fly, and visualize data in multiple, unpredictable ways.
How do you answer their needs when reports are embedded in a PowerBuilder application?
During this presentation, we’ll show how Business users can build new reports themselves (no technical or SQL Skills required).

Once reports are defined, they can:
· Embed them automatically in the Application to make them visible to all users
· Deploy them in a click to Web and Mobile users
· Schedule them on a regular basis and send them automatically by email

Reporting Studio Workshop

 


Christophe Dufourmantelle

Install and configure Reporting Studio in your environment.
Create new reports and integrate them with your application.

Christophe Dufourmantelle

 


Christophe is CEO of NOVALYS. He started as an IT consultant and has been a project leader and a sales executive in various French and international IT companies. He regularly participates in Seminars and User Group Conferences around the world.

 

HANA and PowerBuilder 12.6-The Solution Mix

 


John Strano

PowerBuilder has long been heralded as the most productive custom application development environment in the industry. We’ll examine multiple architectures and avenues for having PowerBuilder develop the presentation layer and business logic for retrieving, manipulating, transforming and persisting data for custom solutions on the HANA platform.

John Strano

 


John Strano has been using PowerBuilder since 1991 and has authored articles for multiple industry periodicals. John has been a Sybase Certified Instructor and has presented application development tools on an international basis since 1997. Over the last 23 years John has developed a variety of applications from single-user scaling up to enterprise-class, web-based projects.

 

Reporting by using Report Definition Language (RDL) from Microsoft

 


Heino Hellmers

This session will cover RDL as an alternative to the DataWindow report for PowerBuilder developers and end users. RDL is a standard proposed by Microsoft for defining reports and it is used for reporting by many applications from different companies. RDL can be used in local mode as an independent and low budget reporting solution with many different datasources (like Oracle, Microsoft SQL-Server, ODBC and OLE DB) and in remote mode together with Microsoft SQL-Server Reporting Services (SSRS).

The attendee will be exposed to the Report Definition Language (RDL), its architecture and various features and possibilities in the context of creating, designing, using and embedding RDL reports. The presentation will take the attendee from an entry level view to being able to unlock many of the RDL features like charts, maps, tablixes (table+matrix), interactive reports, page control or native export to Word (.docx) , Excel (.xlsx) and PDF file. This will also include demonstrations of real-life working application code – including how to embed RDL reports into PowerBuilder applications.

Heino Hellmers

 


Heino Hellmers is CEO of S&F Datentechnik GmbH, an independent consulting and software development company in Germany with a team of 17 PowerBuilder developers. For more than five years the company has been a Microsoft Gold Competency Partner and also an Oracle Gold Partner.

Heino has been using PowerBuilder since version 4 and holds a master’s degree (Diplom-Informatiker) in computer science from the Carl von Ossietzky University of Oldenburg, Germany. He started as a developer and consultant in 1996 and has been a project leader in various projects. He regularly participates in seminars and user group conferences around the world and is a frequent speaker at regional and national conferences in Germany.

Tips and Tricks and Ideas for building new GUI features in your PoweBuilder Classic Application (PDF)

 


Franck Fasolin

The session will show examples of GUI features implemented with PowerBuilder Classic. It will then focus on the code needed to:

  • Implement an “Outlook” search and display oriented GUI in you PB windows, by using only datawindows.
  • Display and Interact with Google Earth
  • Display pictures and use gradient in grid Datawindows.
  • Use png pictures for buttons with hyperlink behavior.
  • Use nice colors in PB graphs
  • Build windows that look like Web pages (and moving them to Web with Appeon)

 

Franck Fasolin

 


Franck Fasolin has been a PowerBuilder developer for the last 23 years. He created many add on tools for PowerBuilder when he was living in France, such as PowerLib from Novalys, Visual Guard from Novalys and HTMLBridge from Cstech. He now works for Sagem Avionics in Dallas,Texas, as the lead PowerBuilder developer on their Flight data analysis software that is used by all major airline companies world wide.

ISV Roundtable

 


Mike Searer

This session will bring together developers for a round table discussion on PowerBuilder ISVs. There will be a number of topics discussed; among others, Appeon for SAAS deployment. Along with these issues, this is a real opportunity for ISV developers to bring questions and discuss issues in a round table format.

Mike Searer

 


Mike Searer is President of Searer Business Technology. His PowerBuilder based SBT Executive Series is a completely integrated accounting software solution with strong drill down capabilities.

 

CSharp Integration (PDF)

 


Kyle Griffis

A walk-through for using the updated Microsoft Visual C# Windows Forms Control Library to create controls that can integrate into PowerBuilder Classic.

This training session will illustrate how to create a visual User Control that contains events and methods that can be exposed into a PowerBuilder Classic OLE container. With the continued push of business operations being developed in Service Oriented Architecture models the need to integrate existing Client Server applications has become mandatory. Learn the simple technique of creating a C# control that can receive notifications from services through the use of custom events within the PowerBuilder OLE container.

Prerequisites:
• Microsoft Visual Studio Professional 2013 or Visual Studio Community 2013
• PowerBuilder Classic 9 or later

 

Kyle Griffis

Kyle Griffis has over 20 years of experience in Information System expertise in Telecommunications, Human Resources, Hospital Information, Marketing, Retail Sales and Inventory Control systems.

He is also the owner of KTG Enterprises LLC a consulting company dedicated to providing custom software solutions to businesses of all sizes.

Currently Kyle is on the team with Replacements, LTD. a company that has the world’s largest selection of old & new dinnerware. With a 500,000-square-foot facility (the size of 8 football fields!) that contains the incredible inventory of 12 million pieces in more than 400,000 patterns, some over 100 years old!

Building Modern Applications with Appeon 2015

 


Don Clayton

PowerBuilder 12.6 is a potent development platform that remains among the most productive programming environments available. But times change: user interfaces are now “User Experiences”. The Internet is everywhere, and system access is often taken for granted. But some things never change: users still want applications that are powerful and pleasant to use, and systems that leverage their computing platforms of choice effectively.

In this session, Don will discuss two real-world development projects to build entirely modern, Enterprise-class Appeon systems from the ground up. Topics will include the strategic decisions made regarding platforms, architecture, appropriate reuse of legacy code, and designing a UX with an eye towards for the future. In addition to showing these groundbreaking development efforts, Don will discuss a variety of ways to update older applications to achieve higher user satisfaction and productivity, and how to leverage PowerBuilder with Appeon to achieve your goals. A variety of tools, including PowerBuilder 12.6 and Appeon 2015 Web and Mobile will be demonstrated.

 

Don Clayton

Donald D. Clayton is Founder and President of Intertech Consulting, Inc. Intertech Consulting is a SAP Partner and was formerly a Sybase Systems Integration Partner for nearly 20 years. Mr. Clayton is a PowerBuilder MVP and has been a frequent speaker at past conferences. He is a Sybase Certified Developer and Instructor and has been working with, teaching, and managing PowerBuilder projects for over 20 years.

Off the Grid: Migrating Sometimes Connected PowerBuilder Apps with Appeon (PDF)

 


Ryan Story

Ryan Story will explore the process of developing, configuring, and deploying a legacy PowerBuilder app with Appeon Mobile that uses Mobilink/Ultralite technology to provide a consistent offline user experience. In addition, he will discuss other techniques to make applications match current mobile app design practices and provide the user a seamless experience.

 

Ryan Story

Ryan Story is a developer with Rax, Inc. which develops software serving the petroleum distribution industry. Ryan began working with PowerBuilder in 2012 and has been working with Appeon Mobile since the first beta period. With the help of Appeon, Rax has migrated six Powerbuilder applications to Appeon that allows expansion to the field from Rax’s primary back office management system. Rax currently has two applications using Appeon in production with the other four in beta.

Deploying Appeon in a Commercial Software Solution


Kay Jenkins
Kay Jenkins will discuss her company’s partnership with Appeon and the unique challenges that have (and have not) been addressed in a commercial software solution deployment of PowerBuilder and Appeon.

Kay Jenkins

Kay Jenkins is Executive Vice President of Research and Development at AssetPoint, a software solutions company headquartered in Greenville, SC, and is responsible for all technology strategy including software development, cloud operations, quality and service delivery. Her team has been working with PowerBuilder for 20 years and Appeon for 7 years, and their innovation as a commercial software provider with PowerBuilder can be traced to 2006 when they became the first PowerBuilder application to become Vista certified by Microsoft. Kay graduated with honors from the College of Charleston with a Bachelor of Science degree in Computer Science and is a PMI-certified Project Management Professional (PMP).

Tips and Tricks for Building Mobile Apps in PB


Song Li
This session shares the real-life experience of a US software vendor developing a suite of mobile apps in PowerBuilder to deploy at 400+ customer sites. This is a technical-focused session that outlines how to achieve a user-friendly UI/UX, fast performance, and mobile-specific functionality on iOS and Android devices. It includes technical implementation details and demonstration of the following features: locking screen orientation, zooming large data sets, handling gestures, creating mobile-specific controls, integrating maps, making phone calls, minimizing memory consumption, minimizing server calls, optimizing heavy nested reports, and more.

Song Li

Song Li is a senior technical architect on the mobility team at Appeon. He has successfully led numerous Appeon projects, and he works closely with Appeon product engineering to resolve complex technical issues. Song has served various roles in Appeon over his 12-year tenure, including tech support, product engineering, and consulting.

Pos Application in the Cloud with Appeon


Fili Sosa
Sizes and Colors is a Point-of-Sale solution that was developed 15 years ago in SAP Sybase PowerBuilder. The application was migrated to the Web with Appeon and today, it is a cloud-based application that is hosted on five servers at a Dallas datacenter with 2,650 shoe stores running it. Even during time periods with increased sales (holidays, for instance), the Appeon application maintains a high transaction rate per second with minimal CPU use. The cloud platform makes applications such as Sizes and Colors very affordable, particularly for small and medium-sized businesses, since companies can share resources and they do not need to purchase servers or any infrastructure. In 2013, Sizes and Colors created a Mobile App for
iOS with Appeon Mobile. The Mobile App gave Management the ability to access real time data from anywhere using their iPhone, Ipod and Ipad. The same Mobile App was also deployed for Android devices couple months ago and it was amazing that the same PowerBuilder code used for the iOS devices works also in the Android. To add more power to the App, we also uploaded data to SAP HANA and created a Report for the Mobile App. The same data is also in Microsoft SQL Server and we compare the speed of both.”

 

Fili Sosa

Fili Sosa has been working for 22 years with SAP Sybase PowerBuilder. He started back in 1993 with PB version 3.0. He has 20 years experience in the Shoe Retail industry in Software Development, TI Administration and Business Process Re-engineering. Today, 30% of the Shoes comercialized in México are sold with the POS developed by Mr. Sosa.

Appeon 2015


Armeen Mazda
An overview of Appeon 2015, including highlights of the biggest new features for Web and Mobile applications:

• Multiple-Browser Compatibility
• PowerBuilder 12.6 Support
• DataWindow DropDown Calendar
• HTML content integration for Mobile

Appeon Workshop Part 1: Simplified Installation


Armeen Mazda
In this workshop, experienced Appeon staff will help you install and configure Appeon 2015 to your Windows laptop in the most straightforward manner. Topics covered include Microsoft IIS configuration, Web browser configuration, Appeon Server installation, Appeon Developer installation, and Appeon Plugin installation. This workshop is recommended for all PowerBuilder developers interested in trying Appeon but do not currently have Appeon 2015 or Appeon 2013 R2 installed to their machines.

Appeon Workshop Part 2: Jump Start Session


Armeen Mazda
In this workshop, experienced Appeon staff will guide you through all the basics of starting an Appeon Web or Mobile project. Topics covered include configuring your project, establishing database connection, developing Appeon-compliant code, and deploying your Web or Mobile application. This workshop is recommended for all PowerBuilder developers that have Appeon 2015 or 2013 R2 installed to their machines.

Armeen Mazda

Armeen Mazda is currently the CEO & President of Appeon Corporation. Armeen has worked with PowerBuilder technologies since 2000 and has served various roles in Appeon, including Product Management, Business Development, and Operations. Armeen is a graduate of the Haas School of Business at U.C. Berkeley and holds 5 U.S. patents in the area of Rich Internet Application (RIA) technologies.