Session Catalog

Learn about all the REST-related features of PowerBuilder 2017 R3. Topic covered include: how to authenticate using OAuth 2.0; how to perform DataWindow retrieves & updates against REST Web APIs; how to handle complex JSON result sets; how to synchronize DataWindow state information; how to merge multiple DataWindows for faster network performance.

Learn how to apply the SOLID OO principles and other proven design principles to PowerBuilder. Topics covered include: an overview of the SOLID OO principles; guidance on how to implement these principles for PowerBuilder apps; PowerScript code examples demonstrating these principles. This session is equally valuable for and applicable to the new C# features of PB 2018.

Learn how to quickly migrate your application to C# using PB 2018. Understand how to use PB's conversion engine to automatically migrate existing DataWindow/DataStore objects to C# DataStore server objects, and reuse PB DataWindow/DataStore in C# projects with minimal effort. Step-by-step generation of the C# model and controller will be discussed, as well as how to publish Web APIs to IIS server.

Discuss challenges users are facing when using the new features of PowerBuilder 2017 and possible solutions. Information collected from this discussion will be considered by Appeon product management in planning future releases.

Schedule a 20-30 minute one-on-one meeting with Appeon. An Appeon staff will email you shortly to confirm the time and topics of the meeting.

Learn how to work with Subversion using the native interface of PowerBuilder 2017 R3. Topics covered include: how to setup the environment, integrate the PowerBuilder IDE with TortoiseSVN, create a SVN repository, get/release a lock, handle/avoid merge conflicts, show diff and log, and extend PowerBuilder’s diff capabilities with various third-party diff tools.

Deploying a classic, complex PowerBuilder application in its entirety to the web using PowerServer can be a daunting task which may not yield the desired results. Sometimes, however, only a targeted set of features is needed by a specific class of users via a web interface. Learn how ChartBase Medical Systems created a modern web portal by leveraging existing DataWindow reports within a new, light application framework designed to provide a contemporary web experience. Topics covered include: modern web-centric UX, dynamic data source mapping in PowerServer, NativePDF vs. Ghostscript (with web service) to deliver DataWindow reports as PDF documents.

Learn to Install and Setup PowerServer 2017 on a Remote Windows Server using IIS. You will also learn how to connect PowerBuilder and publish an Application without much effort.

Learn how to work with Git using the native interface of PowerBuilder 2017 R3. Topics covered include: how to setup the environment, integrate the PowerBuilder IDE with GitStack, create a Git repository, commit source code changes, handle/avoid merge conflicts, show diff and log, and extend PowerBuilder’s diff capabilities with various third-party diff tools.

Learn how to transform a traditional PowerBuilder client/server app to a cloud-based architecture using REST/JSON open standards and C#. Topics covered include: how to create a “feature toggle” controller in PowerScript; how to partition this client/server feature to a Web API; how to extend it with advanced functionality using C#.

Learn all about the new RTE Control feature within the PowerBuilder 2017 and InfoMaker2017 products. Topics covered include insights into: why you would use Appeon RTE vs TX Control, how the RTE feature is implemented, a look under the covers of how Appeon RTE works, deployment scenarios & considerations, tips & tricks and of course the PROS/CONS of using the new Appeon RTE feature. Recommended for all PowerBuilder projects requiring RTE integration within their PB/IM/Web applications.

Learn how to develop a new Web app from scratch using PowerBuilder 2017 R3. Topics covered include: how to set up the working environment, set up the database connection, perform data manipulation through DataWindow, generate PDF using the new NativePDF feature, use INI files and more.

Learn how to incorporate JavaScript components in PowerBuilder, making a new world of functionality available to your PowerBuilder apps. Topics covered include: an overview of the approach; applying the approach to a JavaScript rich text editor; applying the approach to a JavaScript file comparison tool.

Learn how to denormalize and export data from DataWindows to Microsoft Word for additional processing. Topics covered include: an overview of data denormalization and its benefits; how to denormalize data from multiple DataWindows linked together; how to use mail merge to export the denormalized data to Word.

Learn a simple technique for leveraging the DataWindow to create an advanced and modern user experience for your PowerBuilder apps. Topics covered include: how to achieve high-performance drag & drop; how to create enhanced apps, such as calendars; how to create graphical components using DataWindow.

"Learn techniques for achieving a simple user-friendly UI for complex database structures. Topics covered include: loading data into datastores, filling and restructuring that information into a datastore and write the edited data from the datawindow back to the datastores, tips of improving the UI and improving the development efficiency.

Learn how to use PowerBuilder 2018 to start writing C# cloud apps in just 60 minutes. Topics covered include: an overview of the new C# targets; how to use the new C# editor and debugger; how to create a C# DataStore; how to deploy your project to Microsoft IIS.

Are your users tired of scrolling through long lists in DropDownDataWindow columns? Are they frustrated by classic “search and return” dialogs? Learn how to build a modern dynamic search box that is simple to use, displays results on the fly, avoids client-side caching of large data sets, saves your users from scrolling through long lists, and performs well in web-deployed PowerServer apps. Topics covered include: modern UX, DataWindows, stored procedures, dynamic SQL, dynamic UserObjects.

Learn how to call Web services in your application. Topics covered include: an introduction of the Web Services programming, differences between and benefits of REST and SOAP protocols, implementation details of consuming Web services in PowerBuilder 2017 R3.

Schedule a 20-30 minute one-on-one meeting with Appeon. An Appeon staff will email you shortly to confirm the time and topics of the meeting.

Learn how to use PowerBuilder 2018 to create .NET assemblies that can be maintained using any C# compatible IDE. Topics covered include: an in-depth look at the C# ModelMapper; how to most-effectively code against the C# ModelMapper; how to automatically convert existing DataWindows; how to maintain your project using any C# IDE.

Learn how Zeenyx AscentialTest saves time and money to test PowerBuilder applications without recording or scripting. Topics covered include test planning, automated and manual test creation, test management and execution, and reporting. Recommended for users planning to roll out or improve automated testing.

Learn about the PowerBuilder coding practices that can make it easier to code, debug, extend, maintain and add performance to your PB & PowerServer applications. Topics covered include: how to self-document your code; how to code for performance; how to implement system-to-system checks for application stability; debugging considerations & extensions; adding MS-Windows features to your object classes; how to profile & trace your Apps; MDI vs Dockable apps; and many other useful tips n’ tricks for developer productivity.

Learn coding techniques and design patterns for tackling complex coding scenarios with less effort. Topics covered include: programming by Intention; encapsulating OLEObject Interfaces; using C#-style Enumerations; using C#-style Interfaces; design patterns for app-to-app integration; introducing design patterns into existing code.

Learn about the key considerations when migrating from a previous version of PowerBuilder to PowerBuilder 2018. Topics covered include: new features introduced, deprecated features and functional changes, as well as tools and techniques that will help ensure a successful migration.

Learn how EVENTIM, European ticketing giant, evolved their multi-lingual PowerBuilder-based app from client/server to the cloud and .NET. Topics covered include: how to reuse existing business logic when creating .NET Web APIs; design best practices for a robust Web tier, including high-volume transaction handling and PDF generation; SQL Server configuration suggestions; new features of PowerBuilder to evolve your technology stack.

Learn about: Single sign-on, password control, application privileges and many other aspects of your PowerBuilder, PowerServer Web and PowerServer Mobile applications that can utilize an Active Directory database. Topics covered include: demonstrate how to unlock the Active Directory sub-system to fully integrate your Native, Web and Mobile applications. This seminar will include real world scenarios, coding techniques and demonstrations.

Learn how to use PowerBuilder 2018 to create C# REST Web APIs that can be maintained using any C# compatible IDE. Topics covered include: an in-depth look at the C# ModelMapper; how to most-effectively code against the C# ModelMapper; how to automatically convert existing DataWindows; how to use the new C# Web API target to accelerate your project; how to maintain your project using any C# IDE.

Learn how to fully and deeply integrate PowerBuilder apps with SAP Business One (running on SAP HANA) using REST APIs. Topics covered include: how to certify your PB apps as SAP Business One add-ons; how to connect to SAP Hana from PowerBuilder; how to make REST calls to SAP Business One.

Learn how to leverage the built-in features of PowerServer to interact with server-side components. Topics covered include: the File Service plugin, the Web Service proxy, the PowerServer Open Interface, and the interfaces to .NET assembly or Java EJB.

Learn about how the InfoMaker and PowerBuilder IDE’s can be tweaked to deliver maximum flexibility and developer productivity. Topics covered include: how to customize the IM/PB IDE’s for a better UX; how to easily recover the IDE & painter layouts; supporting multiple versions of the IDE’s; utilizing 3rd party tools with the IDE; tweaking the IDE’s toolbars; and many other useful tips n’ tricks for developer IDE productivity.

Learn how to use key new features introduced in PowerBuilder 2017 R2 and R3 for the NativePDF engine, which generates a PDF natively without any third-party plug-in. Topics covered include: restricting document options, requiring passwords, and generating PDFs directly to a blob for use in Web services.

Learn about how build PowerServer Web production applications that maximize the Web User Interface look & Feel in the browser. Also, tips & tricks for converting existing PB Native Apps to PowerServer and refactoring for a web GUI. Topics covered include: Two case studies of real-life prodcution built PowerServer Web applications and the challenges faced in refactoring & building internationally used PowerBuilder Classic Win32 application into a full blown Web applications that meets the Government web standards. The seminar will cover PB to Appeon coding adjustments, alternatives, techniques and workarounds to fully webify any PB Classic application.

Learn how to leverage and benefit from the key new features of PowerServer 2018. Topics covered include: how to make your Web application consume REST Web services, encrypt your data for secure transfer, authentication using the OAuth 2.0 protocol, and more.

Learn how to do full CRUD operations from PowerBuilder to access and manipulate data in Dynamics 365 data using ODBC, OData, or REST interfaces. Topics covered include: how to set up and manage connections for the 3 interfaces; how to securely perform CRUD operations over Dynamics 365 Web APIs; how to display the before and after data.

Learn techniques for optimizing the performance of data-intensive PowerBuilder apps. Topics covered include: how to efficiently load and save massive amounts of data; practical performance optimization suggestions; important dos and don’ts.

Learn about the techniques needed to build a multi-threaded PowerBuilder Classic applications and even deploy these as MS-Windows Native, System Tray & Service components. Topics covered include: the approach and implementation techniques of using PB multi-threading for performance, scalability and stability. Then how to leverage these Apps for RAD development and operational considerations like email notifications, console, debug/tracing, etc. production support.

Learn the essentials for unit testing PowerBuilder components using the PBUnit open-source framework. Topics covered include: an overview about unit testing; how to create automated unit tests with PBUnit; techniques for expanding the capability of PBUnit; all steps illustrated by concrete examples.

Learn how to use the new encryption features introduced in PowerBuilder 2017 R3 to securely move data between the client and server. Topics covered includes: how to use the new CryptoObject and CoderObect in PowerBuilder 2017 R3 to perform encryption, digital signing, and encoding of data.

Learn how to integrate a PowerBuilder desktop app with a BPM product via Web Services. Topics covered include: what is BPM product, how to create C# Web Services, how to consume such services in a PowerBuilder desktop app, how to invoke a PowerBuilder desktop app in a Windows Service, and more.

Learn the basic concepts of object-relational mapping and what is PB's new ModelStore object. Understand the ORM benefits of PB's C# framework vs. the .NET Entity Framework. See how to quickly build Web APIs using C# ModelStore and consume RESTful Web API's through PB's new RESTClient object.

Learn how to integrate your PowerBuilder mobile apps with the device hardware and peripherals. Topics covered includes: accessing the camera to take photos and scan barcodes; printing to mobile printers; processing payment with credit card readers; connecting to serial port hardware.

Presenting the new DataStore, ModelStore and ModelMapper objects for PowerBuilder C# 2018! Through this session you will be able to know the new objects, their differences and some best use case scenarios.

Learn how to build a native mobile app from scratch using PowerBuilder 2017 R3. Topics covered include: how to set up the working environment, set up the database connection, perform data manipulation through the DataWindow, generate PDF and leverage various device APIs such as camera, GPS/navigation and more.

Learn about how the Software Tool & Die Foundation Classes for PB, PowerServer Web and PowerServer Mobile provide a comprehensive, cohesive and accelerated productivity development framework for the Appeon developer. Topics covered in this session will guide the PB developer through the basic architecture of the framework, its adaptation, use, services, performance & tuning and deployment considerations when building industrial strength Native, Web and Mobile applications.

Schedule a 20-30 minute one-on-one meeting with Appeon. An Appeon staff will email you shortly to confirm the time and topics of the meeting.

Learn how to work with PostgreSQL using new PostgreSQL compatibility features introduced in PowerBuilder 2017 R2 and enhanced in R3. Topics covered include: how to install PostgreSQL, install the PostgreSQL ODBC driver, create an ODBC profile, use PostgreSQL procedures and functions via RPCFUNC in transaction objects, and use PostgreSQL from a DataWindow, including support for auto-incrementing columns and other enhancements added in PowerBuilder 2017 R3.

Learn key considerations & recommendations for properly moving your PowerBuilder app off terminal services to an n-tier architecture. Topics covered include: securing your Web APIs and management of those APIs; handling transactions in an n-tier environment; suggested communication protocols to use; how to tackle Internet latency.

This is for intermediate users that want to deploy their appeon mobile app using the Google Store and Apple Store without having to train their end-users to use the Appeon Workspace. I will go through the process that both of these platforms require in order to put a mobile app into production.

Learn how to leverage PowerBuilder’s standalone compiler to automate your builds process. Topics covered include: how to use the standalone compiler to create builds, limitations of the compiler, and enhancements made to the compiler in PowerBuilder 2017 R3.

Learn how to quickly build mobile apps using a self-developed PowerBuilder framework. Topics covered include: common issues experienced in mobile app design and development; how to make your UI responsive (resizing to various screen sizes); how to create a PowerBuilder framework to rapidly accelerate mobile development; demonstration of an iOS and Android app developed in just minutes.

Learn why and how to move away from database model in favor of an object model for queries and updates. Understand the key steps of the migration from DataWindow/DataStore objects. Speed up your C# development using the new C# DataStore and build up Language Integrated Query (LINQ) via SQLExecutor and SQLBuilder.

Learn valuable lessons and techniques for achieving a single PowerBuilder code base that deploys both as traditional client/server and Web apps, which is especially useful for software vendors. Topics covered include: assessing the types of code changes required; deployment methods, including deployment to cloud service providers; licensing changes to consider for your software; maintenance and future development considerations.

Learn how to master the more advanced features of IM – including Appeon IM 2017’s new features. Topics covered include advance topics, such as: Advanced Report design & use, Advanced Form design & use, Importing and Exporting Objects, changing the IM IDE, interacting with PB Developers, webifying & deploying your reports, and changing the IM inheritance templates! Recommended for all PowerBuilder projects requiring advanced reporting and data management by including System Users, Business Analysts and PB Developers.

Discuss key new features in PowerBuilder 2018. Information collected from this discussion will be considered by Appeon product management in planning future releases.

Learn how to migrate off EAServer without the cost and complexity of a complete rewrite. Topics covered include: an overview of several effective EAServer migration approaches; the feasibility and tradeoffs of each approach; the process and key steps to perform the migration; tips n’ tricks learned from various real-life projects.

Learn how to use the basics of InfoMaker 2017 from the PB Developer, Business User or Business Analyst perspective. Topics covered include how to configure the IDE for productivity, various tips & techniques, learn how to build basic reports and forms, the Ins / Outs of the various Painters, Data Sources & the Database Painter, IM 2017’s new feature set and how to share your work with others. Recommended for all PowerBuilder projects requiring reporting and data management by including System Users, Business Analysts and PB Developers.