Application modernization and IBM Notes data

What begins as an application modernization project often ends up as a much broader endeavor of application consolidation and rationalization

Apr 25, 2018 · 3 min read

So, you want to modernize your classic Lotus Notes applications. If you’re going to migrate to a new application platform, you’ll need to go through a standard ETL (extract, transform, load) process to migrate your application data, which shouldn’t be a demanding task. If you plan to stay with IBM Domino, it’s even easier. Or, is it?

“Through 2019, more than 50% of data migration projects will exceed budget and timeline and/or harm the business, due to flawed strategy and execution.”

According to Gartner, data migration efforts are often complex, risky, costly and time-consuming. Because of this, some organizations tend to defer migrating or modernizing their applications.

Semi-structured data represent a specific challenge for modernizing IBM Notes applications.

One challenge is that rich text fields in Notes applications should be transformed to HTML. Another challenge is that most classic Notes applications use “wysiwyg” forms — compound documents whose layouts are precisely designed for both data-entry and print. In modern applications, this concept has been replaced by responsive design for web and mobile (often combined with PDF output for printing or delivering customer-facing documents).

Furthermore, new applications don’t necessarily match old applications one-to-one. There are lots of reasons for this. In some cases, business processes have evolved over the years; in others, mergers, acquisitions, or restructurings have taken place. Or, a company may have simply attempted to reduce IT complexity by consolidating applications and infrastructure.

What begins as an application modernization project often ends up as a much broader endeavor of application consolidation and rationalization.

Whatever the reason, the modernization process provides an opportunity for organizations to transform their application portfolio. However, migrating data from old databases can be more complex than anticipated.

Ask any developer — they prefer to start from a blank slate, without the historical baggage of legacy data. For new applications, they will need to rethink the entire data model and perhaps start from scratch to re-architect the system.

To jettison historical baggage and mitigate risks, companies can break the data migration process into three steps:

While the first step may seem unnecessary since we could leave the legacy data where it was rather than to extract it, there are a number of reasons legacy applications should be properly retired (see: IBM Notes Application Decommissioning). Similarly, using existing backups for longer-term archiving is not a good idea (see: GDPR and IBM Notes Data).

Following this process frees developers from the burden of supporting legacy data, which accelerates new application development and data migration. New databases will contain only live data, while historical records will be available to authorized users for future reference, especially in the event of litigation or an audit.

Originally published at on April 25, 2018.


Opinions on collaborative software, starting with Notes and…

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store