Click here to Skip to main content
15,937,318 members
Articles / Productivity Apps and Services / Microsoft Office

Migrating Lotus Notes (Domino) data to Microsoft Office SharePoint Server 2007

Rate me:
Please Sign up or sign in to vote.
3.43/5 (4 votes)
11 Dec 2008CPOL4 min read 110.2K   14   10
This article discusses Lotus Notes data migration approach and how to use Quest Notes to SharePoint Migrator tool.


This article discusses Lotus Notes Migration approach and how to use Quest Notes to SharePoint Migrator tool.

Migration Approach


Assessment & Analysis

  • Define objectives
  • Analyze Application portfolio
  • Run Assessment Tool
  • Analyze Notes Database structure
  • Understand operational characteristics & Notes user culture

Architecture & Solution Definition

  • Identify migration requirements
  • Study and Understand Lotus Notes forms and Views
  • Study and Understand SharePoint Site layout, List, Document Library and Site Collection user permission
  • Identify destination SharePoint data source and do mapping
  • Define migration plan

Prototyping & Customization

  • Map and migrate target databases
  • Validate functionality & data
  • Pilot the solution
  • Perform migration readiness analysis
  • Phase wise roll out roadmap of migration by business criticality, users, etc.

Rollout & Support

  • Optimize the performance of the target infrastructure
  • Migration databases data
  • Support during migration

Tools and Technique

Lotus notes to SharePoint migration - there are more than 10 tools available in the market (i.e. Quest, Unify, Transporter and DocAve). This article mainly focus on how to use Quest Notes Migrator for SharePoint 5.0 tool to migrate Notes data to SharePoint.

Notes Migrator for SharePoint includes a powerful facility for reading local Notes databases and remote Domino databases. This software's data query engine extracts document items, view column values, attachments, embedded images, embedded OLE objects, rich text, DocLinks, multi-valued items, unread marks and dynamically computed fields values from Lotus Notes and writes the results to SharePoint Lists. Notes Migrator for SharePoint products supports all standard List Types (such as Document Library, Discussion, and Events) as well as rich text and attachments.


Notes Migrator for SharePoint

Notes Migrator for SharePoint also supports migrating document library files and can preserve Reply-To hierarchies in threaded discussions. It also includes support for advanced SharePoint features such as document level security, versioning, folder support, duplicate document handling, content types and document approval.

Notes Migrator for SharePoint migrates content from standard template-based Notes applications, highly customized Notes applications into SharePoint.


Notes Migrator for SharePoint Import Service

With an intuitive user interface helps Notes / SharePoint developer to easy-to-follow and mapping of Notes data sources to SharePoint list destinations, Notes Migrator for SharePoint can be operated by Notes / SharePoint developers. After a successful migration, your organization’s original Notes information is available for use on the SharePoint platform.


Select Notes Data Source


Select SharePoint Data Target


Map Notes data to SharePoint

Demonstration of Notes to SharePoint Migration

The below example demonstrates how the following notes elements are successfully migrated to SharePoint.

  • Document items and display column values
  • Attachments
  • Embedded images
  • Embedded OLE objects
  • Rich text
  • DocLinks
  • Multi-valued items
  • Unread marks
  • Dynamically computed values

Lotus Notes source document screen shots


Migrated (SharePoint) Lotus Notes document screen shots



Lotus Notes Security Mapping

Notes Migrator for SharePoint 's security mapping options will map various access control properties of the source Notes database.

An extensive set of options are available for mapping various access control properties of the source Notes database and individual Notes documents to the equivalent security constructs in SharePoint. The following diagram summarizes the possible security mapping options available to you.


Security mapping options allow translation of Notes access control rules to SharePoint

The Map ACL Users option will cause any Notes users listed in the source database's Access Control List to be added to the target SharePoint list or library. The Notes user names are mapped to Site Collection identities based on the rules configured in the tool's User Mapping Options and those users are granted access to the target SharePoint list or library.

The Map ACL Groups option will cause any Notes groups listed in the source database's Access Control List to be added to the target SharePoint list or library. The Notes group names are added to the Site Collection as external groups and are granted access to the target SharePoint list or library. Each group name must correspond to an actual Domain group.


The Map ACL Roles to SharePoint Site Groups option causes a new SharePoint Site Collection Group to be created for each Role defined in the Notes database ACL.


Map ACL Users

If the Map document-level Reader/Writer fields option is set, then any Reader Names or Author Names items encountered in a particular Notes document will cause a permission list to be generated on the corresponding SharePoint record. This new permission list will only grant read access to the users and groups named in the Reader Names field and will only grant edit access to the users and groups named in the Author Names field.

Software Requirement

Notes Data Extraction

  • Windows XP, Windows 2003, Windows Vista or Windows 2008
  • Lotus Notes 6.0 client or higher (may connect to remote Notes 3.0 or higher
  • servers on any platform)
  • NET Framework 3.0

SharePoint Data Load

  • Windows 2003 or Windows 2008
  • Windows SharePoint Services 3.0 or Office SharePoint Server 2007 front-end
  • server
  • NET Framework 3.0
  • Administrator access on the SharePoint server, database and site collection

Migration Tools

  1. SharePoint Migration Tool
  2. Microsoft SharePoint Migration Tools
  3. Unify Solutions Composer for Lotus Notes
  4. Transporter Suite


The above solution covers all aspects of Notes to SharePoint Migration. I am sure that this will accelerates migration timeline and have a very minimal impact on your existing environment.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Architect NCS Pte. Ltd. (A member of the SingTel Group)
Singapore Singapore
Stared as a System Analyst, Software Consultant, IT Project Consultant,Solution Architect and Today as a Lead Consultant. Participated various industries related to Telecommunications, IT, Service, Software Development, and Trade in past 13 years. During this period have successfully executed over 25 IT projects.

My main focus is to provide Solution to business problem that organization face and effectively manage, retrieve information on time using information technologies. Beside this i am an effective communicator, Project Manager with exceptional relationship management skills & significant experience in working with top management and Won numerous appreciations and awards for successful project implementations.

Proposal Management, Solution Architect, Project Management, Web 2.0, .NET, Office SharePoint, Windows SharePoint Services, Lotus Notes Domino, SOA and Migrate Lotus Notes application and data to SharePoint.

Comments and Discussions

QuestionNotes to SharePoint Migrator - Issue in migrating attachments/images of rich text fields Pin
Member 117488277-Jun-15 19:01
Member 117488277-Jun-15 19:01 
AnswerMessage Closed Pin
19-Dec-19 7:00
Member 1181929219-Dec-19 7:00 
QuestionNotes doc link Pin
Member 769802016-May-13 2:02
Member 769802016-May-13 2:02 
QuestionQuest Tool Pin
sheriffbasha9-Mar-13 1:34
sheriffbasha9-Mar-13 1:34 
QuestionSMS from Lotus Notes Pin
WilsonLast14-May-12 19:43
WilsonLast14-May-12 19:43 
QuestionWhat are the points to note while analysing Lotus DB Pin
bpraveen6665-Dec-11 20:48
bpraveen6665-Dec-11 20:48 
GeneralMy vote of 4 Pin
Neeraj Kr27-Apr-11 23:43
Neeraj Kr27-Apr-11 23:43 
GeneralMy vote of 1 Pin
vivekthangaswamy28-Jul-10 19:09
professionalvivekthangaswamy28-Jul-10 19:09 
GeneralVery Good Article Pin
kesrisuresh20-Sep-09 21:14
kesrisuresh20-Sep-09 21:14 
GeneralNice! Pin
Guido_d16-Mar-09 4:18
Guido_d16-Mar-09 4:18 
GeneralRe: Nice! Pin
Mohamed Faizal9-Jun-09 17:49
Mohamed Faizal9-Jun-09 17:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.