Migrating Lotus Notes Applications to Microsoft SharePoint

Steve Walch

While the process of migrating standard Lotus Notes applications to Microsoft SharePoint is relatively straightforward, application databases can be quite diverse, and organizations can have many custom Notes applications, as well. The complexity of all these applications can vary greatly, representing everything from trivial lists to large applications with thousands of lines of workflow processing code.

Migrating a large environment can be daunting. Not only is it hard to migrate hundreds or thousands of applications, but categorizing them presents challenges just as great. Which applications will be easy? Which will require a lot of development effort? To which kinds of targets should the various applications map? How can the cost and complexity of the migration process be controlled?

Here, we'll discuss a practical approach to addressing Notes application complexity, and how consolidating similar applications can result in a significant level of reuse and automation of the migration process that can dramatically reduce migration costs.

Several methods for evaluating the complexity of Notes applications have been published in recent years. The most recent is Microsoft's Design Element Index (DEI) algorithm, which suggests relative weightings for different types of design elements, and ultimately computes a complexity number from one to five.

Several good Notes environment analysis tools currently on the market include an implementation of the DEI method, similar proprietary methods, or both. A tool that scans a large environment and performs an initial ranking of complexity can be very helpful in identifying which applications merit further inspection.

However, such complexity calculations do not always adequately address the practical question of which applications will be easy to migrate and which ones will be difficult. Organizations really need a way to rank applications according to the effort required to migrate them to SharePoint, and to recognize the rare cases where SharePoint may not be the best target.

In many cases, migration is lot simpler than it first appears, and easier than an automated calculation would indicate. For example, an application with many forms, views, and agents that is a standard document library in Lotus Notes may be 'complex' in an absolute sense, but map perfectly to a standard SharePoint document library, making it easy to migrate. Another completely custom application took weeks to develop and has multiple forms, actions and agents implementing an approval process, version control and document level security. But, since all of these now are checkbox features in SharePoint, and your migration tool can understand these features, the migration should be simple.

A final example may be a truly complex application-let's call it Application D-that will take some effort to migrate. Someone needs to build SharePoint content types, custom forms and a new workflow. But, since applications E, F and G are based on the same shared Notes template, you can reuse your work migrating Application D to automate the migration of applications E, F and G.

So from a real-world practical perspective, the five levels of Notes application complexity are:

Standard applications-based on standard Lotus Notes application template; map nicely to standard SharePoint templates

Data-centric applications-have custom data schemas but no significant custom design or logic
Configuration-required applications-were custom developed in Notes, but now may be replaced with out-of-the-box SharePoint features

Medium-development applications-require development using designer tools, but don't require deployment of custom code to SharePoint servers

Heavy-development applications-require deployment of custom code to SharePoint servers.

To understand the categories into which your applications fall, consider the features of your environment. Your version of SharePoint; your company's policies on deploying Office clients and customizing SharePoint; your migration team's skill set; your end user's willingness to compromise; and your choice of a migration tool all can affect the level of migration difficulty for certain applications.

Add Comment      Leave a comment on this blog post
Oct 4, 2010 5:10 PM Rodrigo Rodrigo  says:
Hello Steve, Some other points worth evaluating are: - Type of application - Some will fit better in Sharepoint, others may fit better in other systems (you actually mention this in the article) - User population - Is a small group using the app, or the entire company? - Usage patterns - Is the app used on a daily basis, or is it dying? - Development team - Is the team that did the app the same that's doing the migration? - Rate of change - How much is the application being changed? Has it froze, or is it constantly being updated? I actually took this factors out of a blog post that explains the criteria used by one of our customers to evaluate which applications should be migrated first, and to which platform. You can read the full article here: http://blog.outsystems.com/aboutagility/2010/09/from-lotus-notes-and-beyond---an-agile-migration-story.html Cheers, Rodrigo Reply
May 16, 2011 1:05 PM Chetan Chetan  says:
Hi Steve... Article is really very helpfull.. Thank you very much Reply
May 16, 2011 6:05 PM Anonymous Anonymous  says:
Interesting, but I doubt that 20 years of Notes apps development can be reduced to a 1 to 5 complexity score. Thus, dealing with such variety in designs will most likely require significant labor -- or much more sophisticated tools. Reply
Jul 29, 2011 4:07 PM regime hyperproteine regime hyperproteine  says:
Some truly interesting points you have written.Aided me a lot, just what I was searching for :D. Reply
Aug 30, 2011 7:08 AM oilseed press oilseed press  says:
I am happy to find this post very useful for me, as it contains lot of information. I always prefer to read the quality content and this thing I found in you post. Thanks for sharing Reply
Sep 8, 2011 7:09 AM personal injury lawyers in new york personal injury lawyers in new york  says:
It�s in point of fact a nice and helpful piece of info. I�m satisfied that you simply shared this useful information with us. Please keep us up to date like this. Thank you for sharing. Reply
Sep 10, 2011 11:09 AM r�gime cholesterol r�gime cholesterol  says:
Thanks for sharing superb informations. Your web-site is very cool. I'm impressed by the details that you've on this site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for extra articles. You, my pal, ROCK! I found just the info I already searched all over the place and just could not come across. What a great site. Reply
Sep 28, 2011 6:09 AM Dried Fruits Dried Fruits  says:
Thanks for the unmatchable diary.it was rale useful for me.navigator sharing specified ideas in the instant as symptomless.this was actually what i was labour for,and i am voluntary to came here! Reply
Dec 9, 2011 8:12 AM Smart Home Smart Home  says:
This is what I have been searching in many websites and I finally found it here. Amazing article. I am so impressed. Could never think of such a thing is possible with it...I think you have a great knowledge especially while dealings with such subjects. Reply
Dec 12, 2011 4:12 PM Riverside Injury lawyer Riverside Injury lawyer  says:
Great blog, i really like the way you write these articles! I`m really impressed, keep up the good work. Cheers! Reply
Jan 10, 2012 7:01 AM sabri darbar sabri darbar  says:
Swimming is awesome exercise to lose weight as well as cleaning your body and gets abs as well,... Reply
Jan 10, 2012 7:01 AM Boot Camp Boot Camp  says:
Guys green tea is really beneficial because It's got anti-oxidants in it. These are used to soak up stray oxygen ions which can harm cells - things like vitamin C are well-known anti-oxidants. Reply
Jan 10, 2012 7:01 AM Steve1 Steve1  says:
I highly recommend EAS Simply Protein.their are many others but its the best one,..when it is used with milk it gives more better results,.. Boot camp Reply
Jan 12, 2012 6:33 AM Golf Simulator Golf Simulator  says: in response to Boot Camp
Green tea is beneficial to human body as i read this, but don't have any personal experience. and It's got anti-oxidants in it. so it might be good. Reply
Feb 21, 2012 3:02 AM Edible Oil Refine Edible Oil Refine  says:
We would like to invite you to check out our newly launched website, designed for Modesto-area residents, focused on family-friendly events and activities throughout the Central Valley. Reply
Feb 23, 2012 7:02 AM LED Spot Lighting LED Spot Lighting  says:
Organizations really need a way to rank applications according to the effort required to migrate them to SharePoint, and to recognize the rare cases where SharePoint may not be the best target. Reply
Mar 27, 2012 12:03 PM Fitness Marketing Fitness Marketing  says:
Hmmm... sounds very cool... i really like your work.. thanks for sharing it with us.. keep it up.. keep sharing.. Reply
Mar 30, 2012 8:03 AM Golf tipsAnonymous Golf tipsAnonymous  says:
Golf-game-tip.com provides you with information on the best golf tips available, instructions on how to get your strokes down and much more! Reply
Apr 1, 2012 11:04 PM Cool Cool  says:
Cool story bro. :) No really, good article I had in past so much problems with this application. Reply
Apr 6, 2012 3:04 AM Kit audio voiture Kit audio voiture  says:
In the Auto Diagnostic Tools,GM SPS TECH2 Flash Reprogramming is a higher quality 100Z Reply
Apr 7, 2012 6:04 AM ??????? ??????? ??????? ???????  says:
Hello! The article is very interesting, but some issues still remained less affected. I hope that a future article and will reveal things behind the scenes, things that show us the true face of this. Reply
Dec 19, 2012 9:49 AM Lotusnotes to SharePoint migration Lotusnotes to SharePoint migration  says:
Visionet has been providing cost effective and efficient lotus notes to sharepoint migration services over the years. With its VisiMigrate tool, you can easily transfer the content from lotus notes databases to Sharepoint list & libraries. for more visit http://www.visionetsystems.com/visimigrate.html Reply

Post a comment





(Maximum characters: 1200). You have 1200 characters left.



Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.