Any Lotus Notes application has 3 parts to it:
Given the architecture of Lotus Notes and APIs it provides, you can only migrate #3 i.e. the data out of its databases. That's the ground reality. So,
So, migration process and effort depends on whether a Lotus Notes application can be mapped to some out of the box or custom template in SharePoint or not.
Classifying applications based on their complexity, features and integration requirements helps in:
As the Application Analysis Envisioning Process for Lotus Domino Applications guide mentions, dissecting the domino application and determining the baseline pattens will help you be successful in seeing the end-state solution that will replace the Domino Application. Some patterns mentioned in it are:
Based on your environment, you can identify more patterns and then use them to classify applications. One of the ways to classify them might be:
Migration Tool Options
Microsoft Transporter Suite - Microsoft Transporter Suite is a set of interoperability and migration tools to migrate content from Lotus Domino servers or Generic POP/IMAP servers. For Lotus Domino the suite contains a set of tools for Directory and Free/Busy interoperability between Lotus Domino 6, 7 and 8 and Exchange Server 2007 and Windows Server 2003/2008 Active Directory. In addition for Lotus Domino the suite contains migration tools to migrate users, groups, personal address lists, mailboxes, personal mail archives, and applications from Lotus Domino 5, 6, 7 or 8 to Active Directory, Exchange Server 2007, and Windows SharePoint Services 3.0.
You can read the Microsoft Transporter Suite for Lotus Domino white paper for more details. The click-through flash demo - Microsoft Transporter Suite 2007 for Lotus Domino Demo: Application Data Migration shows how to use the Microsoft Transporter Suite 2007 for Lotus Domino to transfer application data to Microsoft Office SharePoint Server 2007.
A lot of migration tools are available from Microsoft partners. Some of these are:
It's difficult to make a recommendation on the tool to use. Microsoft's tool is free, rest of the tools have a license cost and support options which comes along with it.
I would advise you to first try out the Microsoft tool. If it does not suffice your requirement, download evaluation versions of the 3rd Party tools given above and test them on a sample set of your databases. Most vendors provide evaluation version and live demo or Live Meeting options. Appendix 3: Application Migration Tools Matrix in the Application Analysis Envisioning Process for Lotus Domino Applications guide provides a comparison table but most products have been upgraded since then.
There is tool specific content on some blogs also. For example, posts - Migrating Lotus Notes Applications to Microsoft SharePoint: Understanding Application Complexity and the Value of Consolidation and Automation and Thirteen ways to migrate a document to SharePoint on the Notes SharePoint Blog.
Some Tools do claim ability to migrate Lotus Notes Forms and code. Please do evaluate these claims using a trial version to see if the output meets your expectations or not.
IBM Lotus NotesSQL
IBM Lotus NotesSQL is the ODBC driver for Lotus Notes and Domino which allows ODBC-enabled data reporting tools, database tools, and application development tools to read, report, and update information that is stored in Domino databases (NSF files). You can use this driver to migrate data to Microsoft SQL databases in case the target solution is ASP.NET or a InfoPath based application with data in SQL database.
Tools to assist Co-existence
In case, co-existence of Lotus Notes and SharePoint environment is required for some time, there are tools available from Microsoft Partners which can help you in data integration.
Addition Resources for Reference
Application Templates for Windows SharePoint Services are out-of-box custom scenarios for the Windows SharePoint Services platform, tailored to address the needs and requirements of specific business processes or sets of tasks in organizations of any size.
Product Innovation Custom Application Comparison Demo shows a highly customized Lotus Domino application for processing new product ideas, compares that with the same application built on Microsoft Office SharePoint Server 2007, and highlights the ease of creating workflow and reports using Microsoft Office InfoPath 2007 and Excel Services.
Project Tracking Application Template Comparison Demo compares the out-of-the-box project tracking template applications from Lotus Domino and Microsoft Windows SharePoint Services 3.0, and shows how the integrated platform of SharePoint and Microsoft Office can create a more streamlined project management process.
Sales and Inventory Tracking Application Comparison Demo shows a custom suite of Lotus Domino applications developed for a sales organization, and compares that with a Microsoft Office SharePoint Server 2007 sales and inventory tracking application with the same functionality, while highlighting the integrated capabilities of the Microsoft platform using SharePoint Server 2007, Microsoft SQL Server, and Microsoft Office InfoPath 2007.
Hello Vedant, Very good information.
When i was searching a tool for estimating Lotus Notes projects, landed here.
Can you suggest any tool which gives function point analysis for Lotus Notes projects.
AFAIK there are no tools for FP analysis for Lotus Notes databases. I have not checked the latest version of tools from BinaryTree or Quest though.
Typically you get the count of design elements and documents in a Lotus Notes databases through Lotus Notes code itself or using the analysis tools from Microsoft, Quest or BinaryTree I mentioned in earlier "Part 2" of the post.
Besides the count, it is also critical to check usage of the design elements in a Lotus Notes databases. Most times (my experience) there are lot of redundant design elements lying around which need not be migrated at all.
Hello Vedant, thank you very much the information.
can you suggest me any best approach for estimating Lotus Notes project to re engineering into Microsoft technologies.
Has to be said it is the best consolidated information I have found on Notes Migration. ...
I googled and read various article on same subject, but your one is best and properly managed with lots of information includes article, third party provider detail
I am in same process, but in my case I need to migrate lotus notes to SP2010, can you guide me how can I migrate into sharepoint from lotusnotes. I know sharepoint verywell, but lotusnotes is new animal for me.
let me know how I do one POC using installed SP2010.
What I need to do is create a ODBC connection from Notes to Sharepoint
@Jeff: If you want to pull data from Lotus Notes using ODBC connection then what you need is the "IBM Lotus Notes SQL Driver". Please check the "Lotus downloads" page more details - www.ibm.com/.../toolkits.html
We need to read the lotus notes database file...using c#...instead of using third party tools..any suggestions
@Srinivas: AFAIK there is no C# API for Lotus Notes. You can refer to the toolkits page (www.ibm.com/.../toolkits.html) on IBM DeveloperWorks site. This page provides links to no-charge developer toolkit downloads for Lotus software. You can check the option of using the Lotus Notes SQL Driver to query a notes database through the ODBC interface.
Vedant, do you happen to have any updated instructions for migrating to SharePoint 2010 or do most of the 3rd party suggestions you listed have the ability to migrate to SP2010? Which of the tools do you recommend more than others? Thank you!
Anybody help me out, what is best way to archive Lotus Notes Data.? If it MS SQL can u suggest some architecture for that. Or any references.