We’ve got over 25 PowerBuilder centric sessions and counting, including a session on the recently released PowerBuilder 12.6! 2015 conference presenters include Bruce Armstrong, Chris Pollach, Brian Le Suer, Ronnie Po, Christophe Dufourmantelle, Armeen Mazda, Matt Balent and John Strano.
A number of technical topics will be covered including: Using .NET Non-Visual Assemblies in PowerBuilder Classic, Implementing SSL into Your Appeon Mobile/Web Applications, Rolling Your Own JSON Parser and many more.
The upcoming Charlotte PowerBuilder Conference will be held on May 6-8, 2015 in Charlotte, North Carolina.
The call for sessions is still open and you can submit sessions here.
This year, there are two ‘Pre Conference’ PowerBuilder training classes for the intermediate level prior to the actual conference led by experienced PB instructor Yakov Werde. The classes take place on Monday, the 4th of May and Tuesday, the 5th of May and last 8 hours each. Read more about the classes here.
- New Features in PowerBuilder 12.6 (Download Slideshow)
- Using PowerBuilder.Net Visual Controls in Visual Studio.Net (Download Slideshow)
- Using VS.Net Visual Control in PowerBuilder Classic (Download Slideshow)
- Using .Net Non-Visual Assemblies in PowerBuilder Classic (Download Slideshow)
- Using PowerBuilder Non-Visual Assemblies in Visual Studio.Net (Download Slideshow)
- Getting started with the “Web Service” STD Foundation Classes Workshop (Download slideshow)
- Getting started with the “Integrated” STD Foundation Classes Workshop
- Building Multi-Threaded Windows Service Applications (Download slideshow)
- Developing a Modern Web UI that includes Image Management (Download slideshow)
- How to implement SSL into your Appeon Mobile/Web applications
- Cloudifying your Web/Mobile applications (Download slideshow)
- Extending your PB/Web/Mobile applications via Web Services
- How to Webify your existing PB applications (real-world example from Government of Canada) (Download slideshow)
- Fully integrating Active Directory into your PB/Web/Mobile applications (Download slideshow)
- Webifying and Mobilizing AIRMAN
- The ‘M’ Word in Test Automation (Download slideshow)
- Applying Design Patterns to Automated Testing (Download slideshow)
- Utilizing external technology to extend your PowerBuilder Applications (Download slideshow)
- Roll Your Own JSON Parser (Download slideshow) (Project files)
- Datawindow Functionality Enhancement Toolkit (Download slideshow) (Project Files)
- Visual Expert 2015 for Oracle and PowerBuilder (Download slideshow)
- Visual Expert 2015 Workshop
- Reporting Studio 2015 (Download slideshow)
- Reporting Studio Workshop
- Reporting by using Report Definition Language (RDL) from Microsoft (Session part 1) (Session part 2)
- Tips and Tricks and Ideas for building new GUI features in your PowerBuilder Classic Application (Download slideshow)
New Features in PowerBuilder 12.6
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
A walk-through for creating visual controls in PowerBuilder.Net and then using those controls in a Visual Studio.Net project.
- PowerBuilder.Net 12.5 or later
- Visual Studio Express 2010 or later
Using VS.Net Visual Control in PowerBuilder Classic
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.
- 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
A walk-through of creating non-visual assemblies in Visual Studio.Net and then using those assemblies in PowerBuilder Classic via COM Callable Wrappers.
- Visual Studio Express 2010 or later
- PowerBuilder Classic 4.0 or later
Using PowerBuilder Non-Visual Assemblies in Visual Studio.Net
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.
- PowerBuilder Classic and/or PowerBuilder.Net 11.5 or later
- Visual Studio Express 2010 or later
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
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
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
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
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
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
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
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)
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
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.
Webifying and Mobilizing AIRMAN
The AIRMAN application installed in many North American major airports is designed for Safety Management helping manage operations around the airfield such as Wildlife Management, Runway Inspections and FOD control to advanced SMS tools for conducting Risk Assessments and Human Factors Analysis(HFACS). This PowerBuilder client/server application has been receiving a major facelift recently enabling it for Web, Mobile and Cloud interoperability. This seminar will outline the lessons learned as AIRMAN morphed from its Win32 roots into newer technology streams thanks to Appeon.
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)
“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)
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)
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)
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)
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.
Visual Expert 2015 for Oracle and PowerBuilder
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.
Visual Expert Workshop
Reporting Studio 2015
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 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
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 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
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 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)
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 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.
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.
CSharp Integration (PDF)
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.
• Microsoft Visual Studio Professional 2013 or Visual Studio Community 2013
• PowerBuilder Classic 9 or later
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
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.
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 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 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 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 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
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 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
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 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.
• Multiple-Browser Compatibility
• PowerBuilder 12.6 Support
• DataWindow DropDown Calendar
• HTML content integration for Mobile
Appeon Workshop Part 1: Simplified Installation
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
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 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.