Prague 2023 Session Archive


Session: Protecting Your Data: Best Practices for Ensuring OpenEdge Database Reliability
Speaker: Adam Backman (White Star Software)
Excerpt: As a database administrator, you know that protecting your data is critical to the success of your business. In this , we'll take a deep dive into the technologies and best practices that enable reliable OpenEdge database operation. We'll cover key topics like database backup and recovery, after-image management, and OpenEdge Replication, and provide practical tips and strategies for ensuring database reliability. You'll gain a deeper understanding of Progress' internal structures and mechanisms that enable these technologies, and learn how to manage them effectively to protect your data and maintain business continuity. Don't miss this opportunity to gain critical insights into database reliability and learn how to protect your data effectively. Whether you're a seasoned DBA or just starting out, this will provide you with valuable information and practical tips that you can apply in your own work. Join us and ensure that your OpenEdge databases are reliable, secure, and always available.
Download:
Watch: Video

Session: Birds of a Feather: Chatting about ChatGPT for Progress OpenEdge
Speaker: Allar Allas (Inspirators!)
Excerpt: During this Birds of a Feather session, we will discuss and share the possibilities of integrating Progress OpenEdge with ChatGPT in various ways. As an introduction we will shortly illustrate the following items: 1. A summary of the “Vanilla” ChatGPT abilities of writing ABL 2. Teaching ChatGPT new things - newer OpenEdge features, a database structure, interaction with OpenEdge based frameworks 3. Talking to ChatGPT from Progress OpenEdge Code After the introduction we can dive deeper into the listed items, starting an interactive session with the public. The session will be moderated by Allar Allas from Inspirators! with Valentin Duricu from Wayfare on stage too. Our delegates can already write to them with suggestions using this dedicated e–mail address: bof-chatgptoe@pugchallenge.eu
Download:
Watch:

Session: Using Apache Kafka for Modernizing OpenEdge Applications
Speaker: Andrius Marcišauskas (Baltic Amadeus)
Excerpt: There are a lot of legacy OpenEdge applications. Modernizing them using "big bang" approach might take a while and the result most likely will not be acceptable for current business. However, using Apache Kafka as an alternative can be a good solution. With Kafka, it's possible to combine the old functionality of an application with its old database while developing a new application. Eventually, the old database can be completely removed due to Kafka's loosely coupled nature. This means that the modernization process can be done in small increments, resulting in a more reliable and acceptable product for the business. During this , we will share our experience of using Kafka data streams to simulate the modernization process of an older OpenEdge application, which we want to update into a web-based application.
Download:
Watch: Video

Session: SQL for a Progress DBA
Speaker: Bob Brennan (Integrated Manufacturing Systems, Inc.)
Excerpt: A lot of businesses run Open Edge applications provided by a third party vendor. These same businesses then want to access the data stored in the database via ODBC or JDBC to generate reports. Care and feeding of the SQL92 engine can sometimes get lost or ignored. In this session we will pull together a number of tips, tricks and best practices on how to care for the SQL92 side of the database. - Setup of ODBC - Security and Authorization - Performance - DBA Housekeeping - Migration and Upgrade Considerations - Best Practices Discussion The target audience member will be responsible for an Open Edge database but needs some clarity on the SQL side of things.
Download:
Watch: Video

Session: Who are you? Identity Access Management for PAS via OAuth2 and OIDC
Speaker: Bronco Oostermeyer (flusso)
Excerpt: This will elaborate on how OpenEdge can utilize OAuth2 and/or Open ID Connect to do authentication and authorization. We take a giant leap away from constructs like _User and other homebrew schemes to take this to an enterprise level. Utilize the likes of Azure AD, Google, Facebook or your LDAP to secure your application and even be able to throw in 2 factor authentication. Along the way we’ll discuss the various components which make up the OAuth2/OIDC stack and how to implement this in the PAS configuration.
Download:
Watch: Video

Session: Application Performance – Useful Tools and Practices (Case Study)
Speaker: Claudiu Spac (Wayfare)
Excerpt: Session brief description Application performance is always fine, until it isn’t. When performance inevitably becomes a problem, what are some useful tools and practices to 1. Identify the immediate problem? 2. Make sure it never becomes a problem again? This session will go over some useful tools and practices, from the perspective of some recent, real world, and impactful code and architecture changes. Session description Application performance is always fine, until it isn’t. Is a newly deployed feature too slow to use? Did the most recent release cause logins to take 10 times as long? Did the number of daily users increase so much that the infrastructure can no longer keep up? Are things just slow(er) for no apparent reason? When performance inevitably becomes a problem, what are some useful tools and practices to 1. Identify the immediate problem? 2. Make sure it never becomes a problem again? Fortunately, we already have various tools we can use to identify and fix performance issues: log files, profiler data, XREF reports, VSTs, and in an ideal world performance data from previous releases for comparison purposes. During this session we will go over 1. How the aforementioned tools were used to make some impactful performance changes for a project. 2. Some improvements, automations, and reports created on top of existing tools like the profiler, XREF reports, and VSTs. 3. Some of the performance bottlenecks we found while making changes. By the end of the session you should have a good idea of how to improve the performance of your own application, and some new tools to help you along the way.
Download:
Watch: Video

Session: Log Analytics – What, why, and how
Speaker: Claudiu Spac (Wayfare)
Excerpt: All projects have some form of logging. What information can we extract from logs? Is there an easy way to store, process, and search through that information? Is there an easy way to visualize information that we are interested in? The answer to all of those is yes, and the tool used is a Log Analytics tool. Session description All projects have some form of logging. Commonly used for debug messages, and to give developers an excuse when they have nothing else to do – “I’m improving our logging”. Every project has a different standard for logging, and that includes things like the format used, the context that gets output with the log, what actually gets output to a log, where the logs get output, how many different log files there are, etc. What all projects have in common is that logs contain a lot of information, a lot of information that is particularly hard to search through, analyze, organize, and visualize. This is where log analytics tools come in. They provide an easy way to store, search, analyze, and visualize that information. Unfortunately, in my experience, they are rarely used. During this session we will 1. Go over some commonly used log analytics tools. 2. Identify some of the major benefits that log analytics tools provide. 3. Go over a minimal setup using Grafana, Grafana Loki, and Grafana Mimir, so you can easily implement a similar setup for your own project. The log files are already there, there is no reason not to benefit further from them.
Download:
Watch: Video

Session: Managing the complexities of system integrations
Speaker: Coenraad Vermaak (Britehouse Automotive)
Excerpt: It is inevitable that at some point in the application life cycle some form of integration will be required. The reality of the matter is that all applications are designed, developed and deployed differently, each for their own reasons. This session aims to dive into some of the questions and issues that can arise during system integration. Some of the topics that will be considered includes: • Integrating with legacy systems based on outdated system designs and potential constraints on data management • Role in integration: Publisher vs subscriber • Synchronous vs asynchronous integration and transaction management complexities • Data integrity across systems o Golden source of data and the role each application plays o How to manage varying business rules and ensuring integrity of your own data • Complex transaction management (Transactions spanning multiple systems) and how to implement governance • Performance considerations o Distributed systems o Data format transformations o Volume o Dependencies between systems and transaction state
Download:
Watch: Video

Session: Logging: From Files to the Cloud, with No Code Changes
Speaker: Daniel van Doorn (Consultingwerk)
Excerpt: Logging events and exceptions in an ABL application have come a long way from a bunch of MESSAGE statements scattered throughout the codebase. Today’s logging libraries allow developers to add logging messages into the application and for administrators to decide what messages should be recorded, how they should look and where they should be stored. This session describes the ABL logging classes – what they are and how to use and customize them – and how they can be used in your application, including anonymisation of messages and writing to cloud-based services, such as Kafka queues.
Download:
Watch: Video

Session: PASOE Web Handler – the best thing since sliced bread
Speaker: Daniel van Doorn (Consultingwerk)
Excerpt: In this we will introduce PASOE's WebHandlers - the most flexible method to handle HTTP requests in OpenEdge. We will provide an overview of the architecture of a web handler and provide practical coding samples based on real-world requirements. Starting from simple “hello world” style to RESTful, dynamic interpretation of the URL and multi-part messages.
Download:
Watch: Video

Session: Build.One Commercial Session: Progressing with Confidence: Unlocking OpenEdge’s Potential for the Web
Speaker: Dr. Ronny Schüritz Mike Liewehr (Build.One)
Excerpt: Discover how you can bring your OpenEdge applications to the web while honouring your tried and tested backend. See for yourself how Build.One’s innovative approach can modernise at “twice the speed and half the cost” based on an exemplary case. Of course, the will be accompanied by a live demo where we will showcase some of the most enticing features of the platform.
Download:
Watch: Video

Session: VSCode with OpenEdge
Speaker: Gilles Querret (Riverside Software)
Excerpt: The OpenEdge plugin for Visual Studio Code (VSCode) is a powerful tool designed to enhance the development experience for OpenEdge developers. This plugin provides a rich set of features that allow developers to easily create, manage, and deploy OpenEdge applications from within the VSCode environment. During this session, we will explore the different features of the OpenEdge plugin for VSCode, including its code editor, debugging capabilities, and integration with the OpenEdge AppBuilder. We will also look at how the plugin can help developers streamline their workflow by providing a seamless integration with Git, Docker, and other development tools. Through practical demonstrations, attendees will learn how to create new OpenEdge projects using the plugin, how to navigate and search through large codebases, and how to debug their applications using the built-in debugging tools. We will also look at how to use the OpenEdge AppBuilder, the Data Dictionary and how to execute applications from various platforms. Finally, we will discuss some best practices for using the OpenEdge plugin for VSCode, including how to optimize your development workflow and how to leverage the plugin's features to write more efficient and maintainable code. By the end of this session, attendees will have a better understanding of how the OpenEdge plugin for VSCode can help them become more productive OpenEdge developers, and how to use it to create, manage, and deploy high-quality OpenEdge applications.
Download:
Watch: Video

Session: Inside The OpenEdge RDBMS: After-Image Log Records And Their Uses
Speaker: Gus Bjorklund (Parmington Foundation)
Excerpt: The OpenEdge RDBMS uses two different kinds of transaction logs. These form the basis for a variety of important features like transaction rollback, crash recovery, replication, media failure recovery and so on. In this talk we will open the bonnet on the topic of After-Image Journaling and Recovery Log Records (aka "Notes"). We will describe what they are, what they do, and how to monitor them. But most importantly, we will show you some practical applications and uses of your newfound understanding of Notes.
Download:
Watch: Video

Session: A Bit Of History
Speaker: Gus Bjorklund (Parmington Foundation)
Excerpt: The first release of the Progress 4GL and RDBMS took place on August 8, 1984. Since that day, there have been many more releases and other events in the history of Progress Software Corporation. In this talk we will review significant milestones in the history of PSC and some of the important features and capabilities of various major releases up to the present day.
Download:
Watch: Video

Session: Tales From The Secret Bunker 2023
Speaker: Gus Bjorklund Mike Furgal (Parmington Foundation)
Excerpt: The "Secret Bunker" has been used for many interesting OpenEdge RDBMS investigations in past years. Please join your intrepid explorers for another trip into the bowels of the (recently relocated) bunker. As databases are used and modified over an extended period, database administrators will gain experience and knowledge of what they should have done. They will discover that various improvements in database organization could be made to improve day-to-day performance and maintenance operations. In this talk we will examine some techniques you might use for "online table dump and load" operations with the database. OpenEdge Release 12 has a variety of new features and capabilities that can make such maintenance tasks more efficient and less disruptive to normal production operations. In the bunker we test some of these capabilities and now we report the results.
Download:
Watch: Video

Session: Getting Started as a DBA
Speaker: James Palmer (Vertu Motors plc)
Excerpt: Developers have all been in that scenario where there is no DBA available and something needs looking into. It can’t be that hard is the cry from management, and so we find ourselves poking around on an unfamiliar system with just the Knowledge Base for company. This talk aims to give you, the developer, a brief overview of how to get started doing DBA tasks. We’ll look at how to discover what databases and other services are running, how to stop and start them, how to apply database changes, monitor things like backups and After Imaging. We’ll look at how the database structure works, where to find everything on disk, etc. We will also look at things like making sure your database has the latest meta schema, has After Imaging enabled and managed, has a viable backup plan, etc. If you’re a developer who wants to start looking at how things work under the covers, or a junior DBA then this talk is for you.
Download:
Watch: Video

Session: How to make your DBA happy
Speaker: James Palmer (Vertu Motors plc)
Excerpt: This talk is aimed at developers, but may have some interest for DBAs as well. The idea is to give an overview of the things developers can do to help the performance of their application and to make the DBA’s life easier.We all know that a smooth running application is what keeps customers happy. And we all know that the onus to provide that is on the DBA, right? Wrong! Yes, there is a lot that the DBA can do to improve performance, and keep a reliable system, but if the underlying code isn’t efficient, if transaction scoping is poor, if users are regularly blocking each other, then the DBA’s hands are tied. This talk aims to look at some of the things that developers can do to improve the performance and reliability of their application, which in turn will make the DBA a much happier person. We will take a dive into transaction scoping, query tuning, schema changes, and other topics as time allows. All of them aligned to make your DBA a happier person. Guaranteed!
Download:
Watch: Video

Session: PASOE Devops
Speaker: Julian Lyndon-Smith (Build.One)
Excerpt: In this talk we would like to share with you our devops journey with PASOE. We will show how we were able to go from manual code building and shipping to a fully automated process using best of breed products in a short period of time - saving time, saving money and creating an agile environment for both developers and testers. We no longer have developers not knowing how their code was integrated with the rest of the codebase and what happens after. We now have isolated development environments for each feature, automated builds, automated nightly environments for integration and acceptance testing as well as being able to create an isolated environment for any branch , Pull Request or feature. Every workspace is created from a known base image and therefore we can reproduce the exact environment as it was at the time of shipping. Hopefully this will inspire you to start your own journey and implement your own version of devops
Download:
Watch:

Session: TDD revisited
Speaker: Julian Lyndon-Smith (Build.One)
Excerpt: Test-driven development (TDD) is an advanced development technique,using unit tests to drive the design of software. The result of using this practice is a comprehensive suite of unit tests that can be automated and provide feedback that the software is still working either after further development work or changes to the existing parts of the system. This will show how we use TDD, the benefits that we have found and the changes that we had to embrace in our development process.
Download:
Watch: Video

Session: Custom Sonar Rules / Measures
Speaker: Ken Herring (Rocket Mortgage)
Excerpt: Let's discuss how we've created more than 40 sonar rules to help us enforce code quality and leverage a "shift-left" mentality to engineering. This session will discuss some of the rules we've created, roadblocks we've run into, how we leverage sonar issue data for decision making, and how it's helped improve our teams communication around coding standards. This sessions will involve code, but is not a "how to write rules from scratch" session. The focus would be on specific OE related outcomes and team building/communication.
Download:
Watch: Video

Session: OE Build Pipelines w/ Docker
Speaker: Ken Herring (Rocket Mortgage)
Excerpt: Let's discuss how to run build pipelines for every PR that ensure we're deploying code at the highest quality. These pipelines help us avoid frustration in code reviews by using pedantic robots instead of padantic people. This allows reviewers to change focus from small details to the important part: what does the code do? This session will discuss our container design and how we use OE containers in CircleCI pipelines to compile, unit test, sonar scan, and more.
Download:
Watch: Video

Session: VSCode
Speaker: Ken Herring (Rocket Mortgage)
Excerpt: Let's discuss how to use VSCode exclusively in lieu of PDSOE. Let's discuss how we're using it and what we've learned. This will include how we leverage Docker containers for OE, and different environments our engineers choose to use (local repos, WSL, Dev Containers).
Download:
Watch: Video

Session: Implementing and using the Decorator design pattern in your application
Speaker: Lutz Fechner (Consultingwerk)
Excerpt: The Decorator pattern is a classic design pattern from the Gang of Four. It provides a mechanism to add functionality to OOABL application components, in a flexible and extensible way. This session will show what the pattern is; when and why to use it; and any gotchas when implementing this pattern.
Download:
Watch: Video

Session: Using the Factory pattern: how, when and why
Speaker: Lutz Fechner (Consultingwerk)
Excerpt: Instantiating – NEW’ing – objects can be tricky: especially if the developer wants to be 100% sure that they have a valid object. “Valid” being an object with correct default values, with all required dependencies satisfied, being fully initialized and ready to be worked on. Add in the fact that requirements and classes change – usually becoming more complex – over time, and knowing how to get a valid object becomes harder. The Factory pattern and its relatives provide a way in which application infrastructure or frameworks can guarantee that a developer gets what they are asking for. This session will cover the patterns themselves, how to implement them, and why you would want to (and not).
Download:
Watch: Video

Session: ISCORP Commercial Session: Saasify your OpenEdge Application
Speaker: Mark Holton (ISCORP)
Excerpt: Since 1999, ISCorp has been a secure, reliable, and cost-effective delivery platform for Progress OpenEdge-based applications. Today ISCorp’s Managed Secure Private Cloud Platform supports thousands of production Progress OpenEdge databases. Our partners’ OpenEdge based applications service millions of end users globally. * 20+ Years of OpenEdge hosting experience * Thousands of production OpenEdge databases on the platform * Experienced OpenEdge DBAs on staff * Some of the largest production OpenEdge databases globally under management * Millions of end-users served on the platform
Download:
Watch: Video

Session: Monitoring and analyzing temporary tables, avoiding system errors
Speaker: Michal Dzmuran (Freelance)
Excerpt: Many Progress ABL constructs, applications, frameworks use temporary tables. As usage of temporary tables grows, enterprise applications face problems with resources and Progress limits. Complexity of enterprise applications significantly increases needs for tools to monitor various aspects of the production environment. Temporary tables are one of them. The goals of the session are: Static and dynamic temp tables – what is different Temp tables storage Using VSTs to monitor temp tables Logging temp tables information Using TempTableinfo
Download:
Watch: Video

Session: Consultingwerk Commercial Session: The SmartComponent Library – rapid application development and modernization for OpenEdge applications
Speaker: Mike Fechner (Consultingwerk)
Excerpt: The SmartComponent Library is the full stack modernization framework for OpenEdge applications. The framework supports rapid application development as well as migration of existing OpenEdge GUI or TTY applications. The framework features multiple user interface options, a future proof and standards based application backend and powerful application framework functionality – deployed on premise or in the cloud. The framework is used by teams of virtually any size. This will give developers, architects and product managers responsible for maintenance and development of OpenEdge applications an overview of the framework and highlight the web user interface and the modernization tooling provided with the framework.
Download:
Watch: Video

Session: ABL legacy code refactoring – patterns and strategies
Speaker: Mike Fechner (Consultingwerk)
Excerpt: Looking at that old GUI or Character application you’ve been working on in the last decades? Wondering what you can do with it to migrate it to the web or modern desktop UI? Business Logic mixed in UI triggers? Validation sprinkled with user interaction? In this we’ll demo some typical legacy application scenarios we have ran into during customer application migration projects and the techniques we have provided to our clients to overcome modernization obstacles. Among others the will introduce Proparse and how it can be used to read and understand existing source.
Download:
Watch: Video

Session: Mysteries of ProDataset and Temp-Table parameters
Speaker: Mike Fechner (Consultingwerk)
Excerpt: Temp-Tables and ProDatasets are a key construct of many ABL applications – with or without the Progress AppServer. As a fundamental data structure, they allow to separate the gathering of information and it’s processing. At first sight Temp-Table and ProDatasets can be passed very easily as parameters. However, there are some culprits causing common mistakes in the use. In this we will highlight potential issues and how to detect and fix them and discuss potential performance issues when using Temp-Tables and ProDatasets.
Download:
Watch: Video

Session: Using .NET core with OpenEdge
Speaker: Mike Fechner (Consultingwerk)
Excerpt: In this Mike Fechner introduces the ability to use .NET Core from OpenEdge - a new feature released with OpenEdge 12.7. The provides an overview of .NET Core and how it differentiates from previous .NET Integrations in OpenEdge.
Download:
Watch: Video

Session: The ZERO downtime Production Dump and load
Speaker: Nectar Daloglou Mike Furgal Vladimir Soloviev (OmegaServe)
Excerpt: Say goodbye to the hassle of planning downtime for a dump and load in your OpenEdge database! With Table Partitioning, it can be performed online with zero interruption to your application. In this session, we will go over an online dump/load that was actually performed in production. Traditionally a long and painful process involving downtime in your production environment, a dump/load can improve database performance by allowing you to reorganize and optimize the database structure, reducing the amount of disk I/O required for queries and other database operations.
Download:
Watch: Video

Session: 2023 is the year of Wasm. What does that mean for OpenEdge?
Speaker: Nick Finch (inmydata)
Excerpt: 2022 saw WebAssembly (often shortened to Wasm) gain huge momentum. Already heralded as the biggest change to web technologies since the introduction of JavaScript, new standards from the Bytecode Alliance encouraged a host of major companies like Microsoft and Docker to announce new support for Wasm as a server-side technology. It was adopted as an embedded technology in databases, data streaming technologies, network proxies, even crypto-currencies, and the one of the biggest Wasm users, Figma, was acquired for $20 billion dollars by Adobe. In this session I’ll highlight 5 developments we’ll see in 2023 that will cement Wasm as one of the most important developments we’ve seen in the IT industry for a decade. I’ll discuss how these trends effect the OpenEdge community, how we can take advantage of them, and what the future of OpenEdge might look like as these trends develop.
Download:
Watch: Video

Session: Opening OpenEdge – How we enhanced our Progress OpenEdge ERP with modern components and interfaces.
Speaker: Onno de Haan ( VanMeijel)
Excerpt: In this session you will learn how we opened up our OpenEdge ERP to the outside world. We have created modules to add modern authentication, emailing and REST-services to our application. The best thing is a flexible 100% ABL-layer which enables our customers to define "connectors" consisting of multiple database-tables and access those via REST/SOAP. It's also used to drive a flexible workflow module that presents the data on web and mobile, so customers can build workflows. The data is then pushed back into the ERP-system via REST in which financial mutations are processed. 
Download:
Watch: Video

Session: The Curse of Deleted Key Placeholders.
Speaker: Patrice Perrot Dr Paul Murgues (PROGINOV)
Excerpt: Hosting and managing more than 10k Progress DB in our own Datacenters, we have to take care of the Deleted key Placeholders. During this breakout session, we will go deeper using some illustrative examples. We will cover: - What is a Deleted Key Placeholder? o Definition o When do they appear - Why Does It Matter (performance)? o DB access o Real Index %util o Index Level - How Can You Check Your DB? o 3 ways to estimate them - How Are These Placeholders Removed? o And when it does not happen - What Can You Do About It?
Download:
Watch: Video

Session: White Star Software Commercial Session: Success Stories: How ProTop Helps Businesses Overcome Critical Challenges
Speaker: Paul Koufalis (White Star Software)
Excerpt: Do you want to learn how ProTop can help your business tackle its toughest challenges? Join us for a roundtable discussion featuring panelists who have successfully used ProTop to overcome critical business challenges. Our panelists will share their experiences and highlight the key ProTop features and benefits that helped them succeed. From identifying and resolving performance issues to streamlining administrative tasks, ProTop has helped businesses across a range of industries improve their operations and stay competitive. Don't miss out on this opportunity to discover how ProTop can help your business succeed. Whether you're a seasoned ProTop user or just getting started, you'll come away with valuable insights and practical tips that you can apply in your own work. Join us for a lively discussion and learn from the successes of your peers!
Download:
Watch: Video

Session: Mastering OpenEdge Query Performance: Best Practices and Tools for Optimizing Your Database Queries
Speaker: Paul Koufalis (White Star Software)
Excerpt: Are you tired of slow-performing queries and long wait times for your database queries? In this session, you will learn how to optimize your OpenEdge queries and improve their performance using best practices and powerful diagnostic tools. Join us for a hands-on session that will take you through the process of diagnosing and correcting performance problems with your 4GL code. We'll cover a range of tools and techniques, from simple index optimization to more advanced query tuning strategies. You'll come away with a deeper understanding of the factors that can impact query performance, and practical skills that you can apply in your own work. Don't miss this opportunity to master OpenEdge query performance and take your database queries to the next level. Whether you're a seasoned developer or just starting out, this session will provide you with valuable insights and practical skills that you can apply to improve your code and optimize your database performance.
Download:
Watch: Video

Session: Platform Migration Mastery: A Real-World Guide to Successful Transitions
Speaker: Paul Koufalis (White Star Software)
Excerpt: Are you facing a platform migration or upgrade in your organization? Whether it's a move to the cloud, an upgrade to OpenEdge 12, or a transition to a new hardware platform, platform migrations can be complex and challenging. But with the right strategies, tools, and resources, you can ensure a smooth and successful transition. In this , we'll share our real-world experience and provide you with a step-by-step guide to mastering platform migrations. You'll learn the key considerations involved in a successful OpenEdge platform migration, including how to: ● Assess your current/planned environment for OE gotchas/limitations ● Evaluate prospective platforms for OE: CPU, IO, known best platform configurations ● Plan your database migration strategy, including D&L strategies (Type 2 Areas, CDC, pre-dump, before and after counts, etc) ● Schedule your migration to fit into your production outage window ● Test your migration strategy thoroughly to ensure success ● We'll also cover common challenges that organizations may encounter during the migration process and provide solutions for addressing these challenges. Don't miss this opportunity to learn from experienced professionals who have successfully completed many platform migrations and can provide valuable insights into the best practices for ensuring a smooth and successful transition. Attendees will walk away with a clear understanding of the key steps and considerations involved in a successful OpenEdge platform migration and the tools and resources available to help ensure its success.
Download:
Watch: Video

Session: ProPeek: OpenEdge Application Profiling in VSCode
Speaker: Paulius Kuprevičius (Baltic Amadeus)
Excerpt: While the number of OpenEdge developers who use VSCode is growing, we still lack some tooling, even the simplest one, such as profiler interpreter. Everyone who tried to read OE profiler files knows that to understand them, you need an interpreter. Therefore, we created a new open source VSCode extension for Profiling. It does not only recreate the existing Developer Studio's functionality but radically mprove it.
Download:
Watch: Video

Session: Case Study: How we use ANT and Jenkins to do the automated builds from Dev to QA to Production
Speaker: Rahul Arora (Britehouse Automotive)
Excerpt: How we use ANT and Jenkins, both open sources, to do the automated builds from Dev to QA to Production involving hoping on different servers and merging codebase from two different development frameworks, namely Consultingwerk and DWP, and different version control tools, namely SVN and Roundtable.
Download:
Watch:

Session: Secure Your Data: Using TDE for Full-Database Encryption in OpenEdge
Speaker: Rob Fitzpatrick (White Star Software)
Excerpt: : Protecting sensitive data has never been more important, and OpenEdge Transparent Data Encryption (TDE) provides a powerful tool for improving data security. In this session, you'll learn how to use TDE to encrypt all of your data at rest, improving data security and meeting compliance standards. We'll cover the benefits and challenges of using TDE for full-database encryption, including managing encryption keys, optimizing database performance, and meeting compliance standards. You'll come away with a deeper understanding of the TDE architecture and practical tips for implementing full-database encryption in your own OpenEdge environment. Don't miss this opportunity to improve your data security and meet compliance standards by using TDE for full-database encryption. Whether you're a seasoned DBA or just starting out, this session will provide you with valuable insights and practical tips that you can apply in your own work. Join us and take the first step towards securing your data!
Download:
Watch: Video

Session: Troubleshooting Made Easy: Using OpenEdge Diagnostic Data Collection for Root Cause Analysis
Speaker: Rob Fitzpatrick (White Star Software)
Excerpt: When an event like a lock table overflow or system error occurs in your OpenEdge database, diagnosing the root cause can be a time-consuming and challenging task. But with the Diagnostic Data Collection feature introduced in 11.7.1, you can collect helpful data from the database at the time of the event to simplify your root cause analysis. In this session, you'll learn how to use the Diagnostic Data Collection feature to collect and analyze data from your OpenEdge database. We'll cover the benefits and challenges of using the feature, including configuring the feature and analyzing the collected data. You'll come away with a deeper understanding of how the feature works and practical tips for using it to improve your troubleshooting workflow. Don't miss this opportunity to simplify your root cause analysis and improve your troubleshooting capabilities with OpenEdge Diagnostic Data Collection. Whether you're a seasoned DBA or just starting out, this session will provide you with valuable insights and practical tips that you can apply in your own work. Join us and take the first step towards more effective troubleshooting today!
Download:
Watch: Video

Session: Cyberscience Commercial Session: Reporting against all of your Progress data sources easily and quickly
Speaker: Steven Oakes Dave Darby (Cyberscience)
Excerpt: Cyberquery will enable you and your customers to create better, more powerful reports – easily and quickly. Cyberquery will help you win new customers with an impressive Business Intelligence , retain your existing customers by greatly increasing their satisfaction with your applications, and exceed users’ requirements for reporting and BI. Learn how to unlock the data hidden in your OpenEdge database using Cyberquery. This practical session will include the following topics: • The power of Cyberquery and how it can be used to create ad-hoc reports, charts, KPIs, Dashboards, portals, drilldowns and other output • Reporting across multiple Progress data sources – the easy way • How to seamlessly incorporate other data sources into your OpenEdge reporting environment
Download:
Watch: Video

Session: BEA Solutions Commercial Session
Speaker: TBD (BEA Solutions)
Excerpt: nan
Download:
Watch:

Session: Back to Basics: Keeping Your Database, and the Server It Runs On, Healthy
Speaker: Tom Bascom (White Star Software)
Excerpt: If you're a newly-minted OpenEdge DBA, you may be wondering what tasks you should be performing on a daily, weekly, or monthly basis to keep your database healthy and the server running in tip-top condition. With so many questions and potential pitfalls, it can be difficult to know where to start. In this session, we will show you the way through the challenges that lie ahead and help bring peace to your weekends and evenings. You'll learn about best practices for maintaining your OpenEdge database, including tasks like monitoring database growth, identifying and addressing performance bottlenecks, ensuring data integrity, and how to manage system resources such as memory, disk, CPU and network. Join us to learn how to effectively maintain your OpenEdge database server environment and avoid common pitfalls. By the end of this session, you'll have a clear understanding of what tasks you should be performing on a regular basis to keep your database healthy and ensure optimal server performance. Don't miss this opportunity to reduce stress and improve your database management skills!
Download:
Watch: Video

Session: Real-Time Visibility: Using the Client Database-Request Statement Cache to Troubleshoot OpenEdge Performance Issues
Speaker: Tom Bascom (White Star Software)
Excerpt: nan
Download:
Watch: Video

Session: OpenEdge RDBMS Birds Of A Feather: Tips and Lessons Learned for Database Administration
Speaker: Various (Panel) (White Star Software)
Excerpt: As an OpenEdge DBA, there are always new challenges to tackle and lessons to be learned. But how do you stay on top of the latest best practices and techniques? How do you get advice on a tough project or troubleshoot a stubborn issue? And how do you connect with other DBAs who share your passion for database administration? Join us for an informal, ask-me-anything session hosted by a group of experienced OpenEdge DBAs. Bring your questions and discussion topics, whether it's advice on an upcoming project, a burning question you need answered, or a great DBA "war story" to share. Our panelists will share their own experiences and insights, and provide valuable tips and advice for your own database administration work. Don't miss this opportunity to connect with other OpenEdge DBAs, learn from experienced professionals, and take your database administration skills to the next level. Whether you're a seasoned pro or just starting out, this session will provide you with valuable insights and practical tips that you can apply in your own work. Join us and be part of the conversation today!
Download:
Watch:

Session: A Holistic View of OpenEdge Pro2
Speaker: Satya Prasad (Progress Software)
Excerpt: OpenEdge Pro2 Replication Suite is the easiest and most cost-effective approach for replicating OpenEdge databases to MS SQL Server, Oracle or another OpenEdge database for easy BI and Analytics. It removes connectivity limitations without disruption to normal business operations or risk to the transactional database. Pro2 provides maximum flexibility and excellent performance since the solution is totally native to OpenEdge. This will show you the vital features that got delivered in recent 6.x releases. What are you waiting for? Attend this session and get an overview of Pro2 replication architecture and its ultra-cool features along with the live demo of what Pro2 can help you to unlock the data inside your OpenEdge database.
Download:
Watch: Video

Session: A Modern OpenEdge Management Console
Speaker: Srinivasarao Kommineny (Progress Software)
Excerpt: OpenEdge Command Center (OECC) is a cloud-ready browser-based management console currently for managing multiple PAS for OpenEdge (PASOE) instances across OpenEdge 12.2+ releases. OECC uses lightweight agents to discover, manage, clone PASOE instances and controlling the OpenEdge Databases in the OpenEdge environment. The Command Center is a highly available and reliable complimentary tool for all OE 12.2+ licensed customers. Let’s understand and explore some of these capabilities including demos, and hear the future direction of OECC.
Download:
Watch: Video

Session: Apache Kafka: Using OpenEdge Messaging
Speaker: Cameron Wright (Progress Software)
Excerpt: Interested in Apache Kafka? Feeling a bit lost about how to take advantage of the Kafka ecosystem? In this session you'll learn the fundamental concepts of writing Kafka producers and consumers using the ABL.
Download:
Watch: Video

Session: Are You Vulnerable? Securing PAS for OpenEdge
Speaker: Anil Kotha (Progress Software)
Excerpt: Securing your applications is essential in today's world. This session will cover steps you can take to harden your server and the features of the Progress Application Server (PAS) for OpenEdge that aid you in keeping out the bad actors.
Download:
Watch: Video

Session: Customer Migration Success Stories
Speaker: Cameron Wright Dustin Grau (Progress Software)
Excerpt: I want to migrate to PASOE but my story is unique. If you are in this scenario, we can help you see that you are not alone. Learn from common challenges customers faced and their solutions and success stories.
Download:
Watch:

Session: If it ain’t broke … it doesn’t have enough features yet
Speaker: Roland de Pijper (Progress Software)
Excerpt: The quality of your code has a great impact on the cost of maintenance. But what is ‘good quality’ code? Opinions differ per developer, and for some developers even per day. This raises the need for a fact proven methodology that can help you to determine the ‘status quo’ of your application and the means to improve moving forward. SIG (Software Improvement Group) focuses on improving the health and security of software applications. They use scientifically proven and certified (ISO) models to accomplish this. The results are then compared with their vast software analysis database. In this session we will explain what the SIG tools are and how you can use them. We will discuss concrete ABL use cases ‘from the field’, have an in-depth look at the underlying source code and ways to improve.
Download:
Watch: Video

Session: Improving efficiency of the project together with Business Analyst
Speaker: Jūratė Balčiūnė (Baltic Amadeus)
Excerpt: The purpose of the is to present the role of the business analyst in the development team and its influence on the entire project. Differences and benefits of (not) having a business analyst working on the project. Leadership, prioritization, bridging gaps in business-IT collaboration, stakeholders management, conflicts management, define business requirements and putting more details to them in the proper way by using various techniques, making assumptions add a lot of value to the project. What value and how business analyst improves efficiency will be revealed more in the .
Download:
Watch: Video

Session: Legacy NE Bad
Speaker: Claudia Deacu (Wayfare)
Excerpt: This will expose some of the challenges, myths, and realities of writing code. In my professional experience, I was able to distinguish between clean, easy-to-reuse code and the opposite. Although one would think that it is simple to create quality code, real life proves us wrong, as multiple factors can occur. Here are some questions\topics to which we will find answers and tips to leave a good impact in present and future applications. • Defining and understanding the legacy code. What is the impact in an agile world? • Let’s clarify some of the biggest misconceptions when talking about old code. • From legacy to the low code / no code? • Good code and bad code. True or false? • Should every code have a unit test? • How can the old code pass the time test? • Is it worth claiming strict rules when writing code? • Compliance with naming conventions • Why using relevant comments when coding? • Lesson learned after using mature applications. • Tips for a better future legacy code. Finally, we will go through some of real-life situations and analyze together the best approach.
Download:
Watch: Video

Session: MDBA Services
Speaker: Roy Ellis (Progress Software)
Excerpt: Want to sleep soundly at night or go on vacation? Want a partner to keep your application running smoothing? Let’s talk about OpenEdge’s Managed Database Administration Service (MDBA). We can help you monitor your application, increase performance, and plan for growth. You would have 24X7 access in case of emergencies and be partnered with a DBA to help with your needs supported by a team with over 600 years of OpenEdge experience.
Download:
Watch: Video

Session: Observability thru OpenTelemetry for OpenEdge Platform
Speaker: Srinivasarao Kommineny (Progress Software)
Excerpt: OpenTelemetry is a modern initiative for enabling observability into OpenEdge Application performance monitoring. OpenTelemetry metrics are data points related to the health of the IT Service and opentelemetry traces offer insights into where the time is spent in delivering IT service. Today there is no visibility into ABL Procedures or Class methods execution delays during the production runtime. This will explain how Progress wants to support bring-your-own choice of APM tools for monitoring PASOE / OE Database and hear the future direction of the OpenTelemetry initiative.
Download:
Watch: Video

Session: Readying your PASOE Application for the Real World
Speaker: Dustin Grau (Progress Software)
Excerpt: You’ve migrated your application from classic AppServer or WebSpeed to PASOE. It is important that you properly size and test your application using real world scenarios. How many concurrent customers maximum do you expect? Is your application very chatty or does it make long running requests? Do you understand the difference between login sessions and stateless HTTP calls? This session will cover these critical topics regarding testing and deployment to make sure that your migrated application will work under load when deployed to your production environment.
Download:
Watch: Video

Session: Refactor, Rewrite or Redesign your Progress App?
Speaker: Gabriel Lucaciu (TSS-Yonder )
Excerpt: The scope of this is to share with the audience the key takeaways after the experience of modernizing several Progress Applications by using the following strategies depending on the stage of the application: Refactor, Re-architect, Rewrite or Redesign? The key elements of the are: - What are the today’s expectations about a modern application? - What is the lifecycle of an application? - What is the process of application modernization? - What are main the modernization strategies that can be followed depending on the stage of the application? - What are the Progress (and its partners’) tools that can help in each of the stage to have a successful modernization? The key takeaways for the participants will be answering the following questions: - What should I do with my current Progress App to bring it to the expectations of today? - What are the milestones of the modernization journey for my Progress App? - How could Progress and its Partners help?
Download:
Watch: Video

Session: S.O.L.I.D Principles Every Developer Must Know
Speaker: Rahul Arora (Britehouse Automotive)
Excerpt: Software Design Principles are a set of guidelines that helps developers to make a good system design. A successful software will change and develop, as it changes, it becomes increasingly complex. Without good design principles, the software becomes rigid, fragile, immobile, and viscous. The SOLID principles were developed to combat these problematic design patterns.
Download:
Watch:

Session: Secure your business application with OpenEdge Advanced Security
Speaker: Stefan Bolte (Progress Software)
Excerpt: This session will provide a general overview of the security associated challenges affecting IT businesses across the globe and where OpenEdge Advanced Security comes into picture. The session will touch upon the scope of threats and the measures organizations must put in place at different levels to prevent against various kinds of threats. We’ll discuss threat awareness, individual’s role, DevSecOps, etc. to establish an understanding of the topic and showcase OpenEdge Advanced Security and its role in securing sensitive data and establish trust.
Download:
Watch: Video

Session: The Art of Prioritization: Techniques for Managing Product Backlogs
Speaker: Mara Andreicut (mejix)
Excerpt: Attendees will learn about the different prioritization frameworks, including Value vs. Complexity, Kano Model, and Cost of Delay. The will also cover how to balance short-term and long-term goals, align team priorities with business objectives, and communicate effectively with stakeholders.
Download:
Watch:

Session: The Future of OpenEdge
Speaker: Rob Straight (Progress Software)
Excerpt: In this session we will share insights into market trends and technology advancements shaping our product strategy, and dive into the key features and enhancements we have planned. Attendees will gain a deeper understanding of our product vision and strategy, and learn about exciting new capabilities in our backlog aimed at supporting your business needs in the next 3+ years.
Download:
Watch:

Session: The Top Configuration Mistakes That Are Hurting Your OpenEdge Database, and How to Fix Them
Speaker: Adam Backman (White Star Software)
Excerpt: Are you struggling with slow database performance, frequent errors, or other configuration issues? You're not alone. In this session, we'll provide you with the information you need to avoid the most common configuration mistakes that we see in the field, and ensure that your OpenEdge database is running at its best. From forgetting maintenance tasks to misconfigured startup parameters, we'll cover the top configuration mistakes that can impact database performance and reliability. Using real-world examples from our years of experience working with clients, we'll show you how to identify and fix these mistakes quickly and easily, so you can get back to running your database with confidence. Don't miss this opportunity to learn from experienced professionals who have seen it all, and benefit from the mistakes of others to avoid making the same errors yourself. Whether you're a seasoned DBA or just starting out, this session will provide you with valuable insights and practical tips that you can apply in your own work. Join us and start fixing your configuration mistakes today!
Download:
Watch: Video

Session: What to expect in OpenEdge 12.8, the next Long Term Supported (LTS) release!
Speaker: Rob Straight (Progress Software)
Excerpt: OpenEdge 12.8, the next planned LTS release, is a culmination of new and enhanced feature development begun in the OpenEdge 12.3 Innovation release and built upon in subsequent 12.4 through 12.8 releases. This session summarizes the key new capabilities that you can take advantage of, along with insight into the version upgrade process.
Download:
Watch:

Session: What's new in OpenEdge ABL
Speaker: Anil Kotha (Progress Software)
Excerpt: Many new features and capabilities have been added to the ABL in the recent releases. This session provides an overview of the following features: SortedSet Collections, Hash-Code, HashMap Collections, Protected Compiled Rcode, Dynamic Data Masking, OpenTelemetry tracing.
Download:
Watch: Video