Session Catalog

Learn more about the new PowerServer 2022, a full-fledged development frameworks for converting even the most complex PB app into Cloud deployable app with ease and speed. Topics covered include: an overview of architecture deployment, debugging tools, migration pitfalls and performance tuning. PowerServer REST architecture offers an open, scalable and maintainable solution, yet overcoming the major limitations of previous PowerServer Web.

Learn how to write unit tests for PowerScript-based apps with PbTest. Topics covered include: what is unit testing, how to write and execute unit tests with PbTest, how to group unit tests in test suites, understanding PbTest structure and how to extend it.

Learn about multiple debugging enhancements made in PowerBuilder 2022. Topics covered includes how to enable the debugging for 64-bit apps, PowerClient apps and PowerServer apps.

We will show how to configure, deploy, and utilize the Cloud App Launcher (CAL) while showcasing it's PowerBuilder v2022 enhancements for PowerClient-automated publishing and installation of PowerBuilder applications. With the advent of Cloud application deployment enhancements for PowerClient/PowerServer, Appeon PowerBuilder has expanded the depth and breadth of its integration and deployment capabilities. In addition to User-specific deployment and installation, applications can now be published publicly to better integrate with all Users of virtualized desktop environments. Topics covered include: We'll show how these enhancements will integrate with PBAutoBuild, Git SCC, MS IIS, and platforms like DevOps to achieve a front to back CI/CD solution. We' will also review how this capability can be approached/emulated using PowerBuilder 2021.

Learn the key differences between long-running connections and short-lived connections. Topics covered include: why connection difference may cause consolidated features in c/s apps to fail to work in corresponding cloud apps or REST API; how to apply the appropriate coding techniques and avoid to re-design the PB code that relies on long-connections; a few case studies to explain typical scenarios in PowerServer 2022 and REST API projects.

Learn how to use and inherit custom UI Themes in PB applications. Topics covered include: What are UI Themes Considerations to create custom themes Apply custom UI Themes Supported and unsupported theme settings Appy UI Themes inheritance to user objects and windows in PowerBuilder Application Demo (show the inheritance)

Learn about the different techniques for performance tuning applications that have been migrated from Client/Server to the cloud using PowerServer. Topics covered include: improving the speed of project compilation and deployment, the initial application load and ongoing operation.

Learn how to build test automation for the datawindow. Topics include: * get the number of rows in a datawindow * get all the values of a datawindow row based on some value in one of the columns * get the values of a column for the entire data window * loop through the rows of a datawindow * how to define the tabbed MDIChild * how to define the Ribbonbar * how to configure automation support for built in Chrome (CEF)

Learn how the same PowerServer 2022 application can be accessed by many customers, each one on a different database. Topics covered include: * How to create a Connection Cache dynamically by calling the PowerServer Web API * How to create a Connection Cache inserting a record directly into a table * How to change in the application the connection to the database on the fly using this new Connection Cache created. * Learn the structure of the tables used by the Connection Caches in order to configure each one according to the specific needs of a given customer.

Learn how the DevOps approach can also be implemented for PowerBuilder applications through the combination of Jenkins and PBAutoBuild. Topics covered include: how to optimize the interaction between the programmers and the Testing/Production operators; different deployment scenarios: C/S, PowerClient, PowerServer (Client and WEB API), all of these integrated with the most widely used open source platform for CI/CD, Jenkins.

Learn how to send WhatsApp messages from your PowerBuilder and PowerServer Applications, Topics covered include: * How to integrate Twilio's Web API inside your PB applications to send WhatsApp messages. * How to create the Web API that Twillio needs to call in order to get the responses from the WhatsApp messages. This Web API is going to be created using SnapDevelop with .NET DataStore and Twilio's C# Library.

Learn how to recapitulate GLV in a Git SCC context. In the world of Git Source Code Control(SCC), the one-click Get Latest Version (GLV) does not exist in the same form as it had for PowerBuilder and other Microsoft Interface-adherent (MSSCCI) development platforms. How then do we periodically update our local copy of the PowerBuilder Workspace to test if our individual enhancements integrate well with our fellow development team members' modifications? Topics covered include: In this session we'll demonstrate how to use Git Rebase procedures to: Update your Workspace with other development team members' changes Completely avoid dreaded server side, remote repository Merge Conflicts Gracefully side-step local Merge Conflicts and avoid the need for conflict resolution We will also demonstrate PowerBuilder 2022's new ability to generate local PBLs from Git-remote Source Files (*.SR*), which negates the need for PBLs to be under SCC.

Learn how to send WhatsApp and SMS messages from your PB applications, implement chatting with WhatsApp, sending OTP and confirmation codes - technical and organizational aspects. Topics covered include: WhatsApp messaging and chatting, SMS messaging and regulations, REST API calls, An alternative approach to messaging that uses the full power of PB 2022 - this is an extension of the 2021 presentation addressing more messaging regulations, more use cases, and showing a PowerClient app, a REST API (with .Net datastore), the PB to C# migration of a console application.

Learn about the approaches and limitations of consuming .NET Managed Code Assemblies in PowerBuilder. In this case from our consulting files, Intertech recently developed a Dymo label printer API wrapper adapter for PowerBuilder using Dymo’s next generation printer APIs. Dymo recently deprecated it’s COM solution and instead offers a .NET framework API called the DYMO Label SDK, which is relatively complex and difficult to consume in PowerBuilder when compared to the COM predecessor. Topics covered include: Calling a .NET Assembly in PowerBuilder, C# and PowerBuilder language feature mapping, creating an adapter wrapper for unsupported .NET features, deploying the solution and debugging the solution. We will also share our basic approach to integrating the DYMO Label SDK into PowerBuilder, thus illustrating the strengths and limitations of integrating PowerBuilder with .NET.

Learn about multiple security enhancements made in PowerBuilder 2022. Includes how to enable HTTP/2 & TLS 1.3 for your apps HTTP communication in PowerBuilder. How to enable mutual TLS authentication with Amazon Web Services & Azure.

Learn how to identify the slowest objects in your application, analyze the components of a business process (call chain) to find bottlenecks, and more… We will use Visual Expert to analyze the execution of application objects, their number of calls, average execution time, etc., combine this information with a static analysis of the code, and optimize performance. Topics covered include typical cases of PowerScript code in client/server and PowerServer applications, as well as Oracle PL/SQL and SQL Server Transact-SQL stored procedures.

Continuing on from Part I* where I covered the window resize service, this session will focus on how to use the datawindow resize service without incorporating the full PFC. *Part I: https://www.appeon.com/developers/library/videos/using-pfc-resize-service-without-pfc.html

Learn about how to implement Single Sign On in PowerServer. Topics covered includes an introduction of the OpenID Connect, the changes you need to make in both PowerServer project, and PowerBuilder client in order to make to integrate with the authentication server, and how to achieve the Single Singe On result between a PowerServer app and React Client.

Learn more about use of the OAuthClient object to protect your data when consuming web services and APIs. Topics covered include: 1. An overview of the OAuthClient object and other objects that facilitate its use. 2. Review of the code in a recent deployment 3. A discussion of some issues we encountered and the solutions 4. A walk-through of a use case at a large customer in the rail industry