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