Session Catalog

Learn how the Scrum framework can be used in PowerBuilder projects, in the same way as in more recent projects. Topics covered include: introduction to Scrum, The Scrum events, How Scrum can be applied on a PB application, Scrum compared to traditional project management.

Learn various environmental considerations that a PB developer would need to perform in order to be ready for installing the PowerBuilder Cloud / PowerServer 2021 software combination. Topics covered include: Getting Ready, Requirements; Prerequisites; .NET frameworks & SDK; IIS installation & configuration; PB IDE / PS Toolkit and; the Appeon Installer. After this session, the PB developer will have a good understanding of the PB / PS 2021 product environment that needs to be in place before starting those product installations.

Learn how to achieve a subtle yet unmistakable modernization in the appearance of a long-standing PowerBuilder application by customizing a UI Theme to match the application's existing design aesthetic. Topics covered include: optimum formats and resolutions for image files; choosing colors; preparation of graphic assets for use in a custom UI Theme; editing theme.json.

Learn how to deploy your PowerBuilder apps to the cloud. Topics covered include: an introduction of the PowerServer architecture; how the new PowerBuilder 2021 IDE integrates with PowerServer 2021; the relationship of the PB IDE's integrated PS Toolkit to generate each of the PowerServer and App Cloud components and; how these components are then integrated together to form the final PowerServer Cloud Application - right through to its delivery to the Cloud App user. Then finally at the end of the session the steps / techniques for delivering the completed Native Cloud Application's deployment into production.

Learn how to integrate Google Maps into your PowerBuilder application. Topics covered include: Google Places API summary; Place Search, Place Details and Place Photos APIs; use PowerBuilder 2021 HTTPClient and JSONParser; provide a working reusable nvo service object to access Places API.

Learn how debugging PowerServer 2021 applications. Topics covered include: breakdown of the operations and functions to debug will teach you what are the right debugging tools and how to use the appropriate technique. Demonstration of how to perform client-side and server-side debugging. It will also describe useful file logs produced during the deployment and running of PowerServer projects. Finally, a few debugging case studies will be discussed to showcase how to handle real-world issues and locate errors occurring during the app execution.

Learn how to set up a PowerBuilder build and release pipeline using Azure DevOps. This session will show you how to automate your builds and distribute them to various environments using Azure DevOps. Topics covered include: what is CI/CD ( Continuous Integration / Continuous Deployment ) ? azure DevOps as an environment defined; creating a Build Pipeline in Azure DevOps; the Challenge of PowerBuilder Integration with Azure DevOps; how OrcaScript Bridges the Gap and Allows PowerBuilder Integration: 1. What is OrcaScript.2. OrcaScript code examples; case Study - Build and Release Pipeline Built for one of our Major Customers.

Learn in depth the unsupported features of PowerServer 2021 based applications. Topics covered include: how to automatically detect Unsupported Features; Unsupported features where there is a suggested workaround; Unsupported features where there is *no* suggested workaround; further workaround suggestions by the presenter; Discrepancies that cannot be detected; Possible workarounds for those discrepancies and Trouble shooting & Debugging tips. At the end of this session, the PB developer will have in-depth knowledge of the possible challenges and alternatives to implementing successful PS2021 Cloud Native Applications.

Learn how to migrate your PDF functional from PowerScript to a REST APIs. Topics covered include: how to export PowerBuilder PDF documents from RichTextEdit Control, compress the data to the SQLServer through REST API, migrate the data manipulation script from PowerScript to the REST API, pull the data from the database and make it readable in the latest WebBrowser. The considerations of migration and read the documents process will also be included.

Learn about the various means of mapping database connections to connection caches in the PowerServer app and the impact on them when migrating Client/Server applications to the cloud using PowerServer. Topics covered include: how to configure connection caches, dynamic mapping, static mapping, dynamic connections, and comparing the options.

Learn more about how to reduce the footprint of the PowerBuilder Foundation Class library (PFC) to a more manageable level for inclusion in existing PowerBuilder applications. Topics covered include: explore how to reduce the library objects, integrate the library, and migrate existing windows to take advantage of the PFC.

Learn how to implement Authentication, Authorization and Audit features in PowerServer applications, without coding, using Visual Guard. Topics covered include: codeless Web API Authentication, implementing a server-side Authentication and integrating with an Identity Server; modernize Authentication Methods, replacing the typical authentication with a user table by modern methods: Windows Authentication, Single Sign-on (SSO), Oauth2 or Multi-factor Authentication (MFA/2FA); add Web API Authorizations, controlling Access to Server Resources (datawindows, tables, methods…); unified Client & Server Security, same user accounts and authentication methods, both for PB Clients and Web APIs; audit & Monitoring: Audit user access rights, monitor sensitive transactions, trigger alerts for suspicious activities.

Learn examples and techniques of manipulating and connecting visual objects on a datawindow and between datawindows using the mouse. This session will show there are methods to interact and connect with users in a simple intuitive way. Topics covered include: grabbing visual objects and moving/copying them from one datawindow to another; drawing simple lines and shapes; grabbing groups of objects and moving and copying them; arranging groups of objects into different formats; logically connect different visual objects and groups of objects using the mouse.

Learn how to find, report and fix security issues in the code of PowerBuilder and PowerServer applications, using Visual Expert. Topics covered include: scanning PowerBuilder & PowerScript code for security issues; locating flaws at instruction level and fixing them; producing statistics and graphs about the security of the code; drilling down to focus on specific issue types, or parts of the application; automatically scanning new builds in a Continuous Integration Workflow; generating reports to list and share issues with teammates.

In this session you will learn opportunities of the new PowerServer 2021 from the perspective of the author, who has spent last 15 years working with PowerServer "classic" in roughly a hundred of Mobile and Web projects. Topics covered include: comparisons of runtime performance tuning, architecture integration, PowerBuilder features support, server components deployment and extensibility. You will learn why PowerServer 2021 offers a new approach to PB developers, with its REST architecture that gives a relief to major limitations of the old PowerServer version but also rises some questions on the future of existing migrations.

Learn how to migrate DDS EAF based components from PowerBuilder to C# using PowerBuilder CloudPro’s PowerScript Migrator using the SnapDevelop IDE and/or Visual Studio IDE. Topics covered include: the steps needed to re-host these components from EAServer to IIS, changing TCP protocols from CORBA IIOP to HTTP web services, and the challenges facing organizations who wish to re-platform components developed in this framework. EAF(Enterprise Application Framework) is a common framework for PowerBuilder components hosted on EAServer. The DDS EAF was developed by to be service-oriented similar to PowerBuilder’s PFC but for the middle tier.

Learn how to add authentication to the REST APIs exposed by PowerServer. Topics covered include: using the build in JWT server, the build in OATH server and using third party services such as Amazon and Azure.

Learn how to use webbrowser to modernize PowerBuilder application. Topics covered include: how to use open source JavaScript libraries and examples to integrate JavaScript treeview, charts and 3d data visualization.

Learn how dockerizing SQL Anywhere 17 ODBC client with REST API and PowerServer 2021 projects. Topics covered include: a step-by-step approach will teach you how to configure ODBC connection in Docker engine, how to configure the Docker Image and how to configure SnapDeveloper for Docker deploy. A first scenario will target a PowerServer 2021 project, migrating the Appeon SalesDemo application. A second exercise will instead dockerize a REST API project. This unique setup will allow you to easily pack, ship, and run any SnapDevelop project connecting ASA 17 remote DB as a lightweight, portable, self-sufficient container, which can run virtually anywhere.

Learn how to add updateable column(s) to your DataWindow SQL and display at runtime. Topics covered include: runtime customization of DataWindows by adding a column to a DataWindow's syntax, including changing the SQL, adding the column definition, and creating the column display. Plus, how to handle sharedata when you are adding/changing the datawindow definition.

Learn about the different techniqes 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 diagnose the execution of your application with the tracing and profiling capability of PowerBuilder. Topics covered include: how to configure the Trace capability within the PowerBuilder IDE and the tips on how to avoid its pitfalls; how to code trace and profile execution in your application's Powerscript so you can capture the performance of just about every line of code at runtime; tricks for how to identify the "thin ice" in your code, the vulnerable points in execution.

Learn how to create a PowerBuilder application in Azure using Docker Containers with Kubernetes and Azure SQL Database. Topics covered include: a walkthrough of creating the SQL Database, create the Docker container and create the Kubernetes in Azure, deploy the PowerServer Project in PowerBuilder, and create the image that is going to be sent to dockerhub.com from SnapDevelop.

Learn how to send WhatsApp and SMS messages from your PB applications. What is needed, technical and organizational aspects. Topics covered include: WhatsApp messaging, SMS messaging, REST API calls, Implementing chatting in WhatsApp, An alternative approach to messaging.

Learn how to retrieve and upload large documents with .NET Datastore and other tools. Topics covered include: typical usage scenarios for file operations; saving and retrieving binary data using SqlExecutor; PbBlob datatype; emailing PDF attachments; putting it all together.

Learn how to deploy your PowerServer applications to Amazon Web Services.

Learn techniques of how to use JSON parser object to consume JSON within PowerBuilder DataWindow/DataStore. Topics covered include: importing JSON strings, populating multiple objects from a single JSON string, parent/child datawindows, populating dropdowndatawindows, and various parsing techniques.

Learn how to use a single sign on service for both PowerServer and other applications (e.g., HTML apps).

Learn how to create stable nvo service objects for your PowerBuilder applications. Topics covered include: using try/catch/finally blocks; passing variables as reference arguments; logging integration. Prevent memory losses and other best practices for nvo's.

Learn how to perform load-testing on a PowerServer's Web API by using JMeter to simulate multiple users accessing the Web API simultaneously. Topics covered include: acquiring JMeter, setting up the testing plan, running and understanding the test results.

Learn how to build and execute a single set of automated tests that will run against PowerBuilder, PowerServer and PowerClient versions of the target application. Participants will learn how to define application objects for all PowerBuilder elements with special focus on the datawindow regardless of its presentation style (Form, Grid, Group, Treeview, Tabular, etc.). Topics covered include: defining Pb application objects including the new Ribbon element; using the AscentialTest selector to navigate and interact with Pb tables; handling application startup across the different Appeon platforms (PowerBuilder, PowerServer, PowerClient); integrating automated tests with continuous integration solutions. All examples will target 2021 versions of Appeon platforms.

Learn how to deploy your PowerServer applications to Azure.