Installing and Configuring the Lotus Notes Connector for SharePoint 2013 Server: Part 1 of 2


I am involved with Lotus Notes application migrations to SharePoint from time to time. I am looking for a solution that can keep some legacy Lotus Notes applications in place; but provide search capabilities to the legacy data to SharePoint 2013 users. This could be a very practical and cost-effective business solution to customers.

This is a copy of the blog post that I originally posted here:

Installing and Configuring the Lotus Notes Connector for SharePoint 2013 Server- Part 1 of 2

I want to crawl a Notes database with SharePoint 2013 Search. As part of that effort, I need to install the Lotus Notes client and connector on the SharePoint 2013 Server. But there are a number of steps that I need to execute first. I follow along the steps as detailed here: http://technet.microsoft.com/en-us/library/jj591606.aspx. However, I depart from the steps and do things a bit differently based on where I ran into problems and fixed them. I document everything in detail.

In this first of two blogs, I execute the steps to:

  • install and configure the Lotus Notes client software
  • grant access privileges to the Notes \ data folder
  • install the Notes C++ API
  • create the Mappings database
  • add a user account mapping to the Mappings database

I am logged onto my SharePoint 2013 Server with the SP_Install user account. The SP_Install user account is a member of the Administrators group on this server.

Installing the Lotus Notes Client Software

I am installing the 32-bit version of Lotus Notes R8.5 on my SharePoint 2013 server. I will only install the client and not the Designer or Administrator software. I would typically recommend against ever installing such software on a server. But I don’t have access to a third party connector (e.g. BA-Insight). I have installed Lotus Notes client software more than a hundred of times already. I will touch on the key points.

I double-click on the installation file.

image

I click Yes on the User Account Control window.

image

I change the file path in the InstallShield Wizard and click Next

image

The files are extracted and the installation process begins. The Install Wizard screen appears. I click Next to continue.

image

I accept the terms in the License Agreement screen and click Next to continue.

image

I enter generic text in the Customer Information screen and click Next to continue.

image

I keep the selections in the Installation Path Selection screen and click Next to continue. I actually tried it with the default file paths first and everything worked until I got to the last step of the Lotus Notes Index Setup Wizard. I could not complete the step. But simplifying the default file paths made it work.

Program Files C:\Lotus\Notes\
Data Files C:\Lotus\Notes\Data\

image

I modify the settings in the Custom Setup screen as seen below. I do not select the Domino Designer or the Sametime Client to be installed since I already have it installed on another virtual machine. I really do not want them installed on a server anyway. I click Next to continue.

image

I deselect all of the options on the Ready to Install the Program and click Install to continue.

image

The Install Wizard continues to install until the Install Wizard Completed screen appears. I click Finish.

image

Grant Permissions on the Data Folder

I open Explorer to the Notes data folder.

image

Right-click on the data folder and click on Properties.

image

Click on the Security tab on the Properties window.

image

Click on the Edit button.

image

The Permissions for Data screen appears. Click on Add…

image

The Select Users screen appears. Change the location to the local server and enter WSS_WPG into the object names field and click Check Names.

image

The group name should resolve correctly. Click OK to accept and continue.

image

The WSS_WPG group should appear in the security list. Click the Allow checkbox on Full control under permissions. Click OK to accept the changes and continue.

image

The WSS_WPG group appears in the Security list in the Data Properties screen. Full Control permissions are granted. Click Close to close the screen.

image

Install Lotus C++ API

I downloaded the Lotus C++ API from here: https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=ESD-SUPPORT&S_PKG=CR3DNNA&S_TACT=104CBW71&lang=en_US&cp=UTF-8

I chose the Release 3.0 for Windows file.

image

I executed the c55svna.exe file on the SharePoint 2013 server where the Lotus Notes client will be installed. I clicked on Run in the Open File – Security Warning screen.

image

The Lotus C++ API screen appeared. I clicked Finish to continue.

image

I clicked Yes on the Create directory screen.

image

I clicked OK on the Extraction completed screen.

image

Copy the lcppn30.dll file from the C:\notescpp\lib\mswin32 folder to the C:\Program Files\Microsoft Office Servers\15.0\Bin folder.

RHR (2012-05-05): I fixed a typo below. I referenced the wrong Lotus Notes folder to copy to.

Copy the lcppn30.dll file from the C:\notescpp\lib\mswin32 folder to the C:\Lotus\Notes folder.

image

Update the Path Environmental Variable

I am not convinced that I need to update the Path Environmental Variable; but it has solved problems for me in the past when I use the Lotus C++ API from IBM.

I open Explorer and right-click on Computer. I click on the Properties option on the menu.

image

The System Properties screen appears. I click on the Advanced tab.

image

RHR (2012-05-05): The Control Panel \ System and Security \ System screen may appear. If it does, click on Advanced system settings next.

image

Click on Environment Variables and scroll down in the System Variables and select Path.

image

Click on Edit and the Edit System Variable screen appears. Append the following text to the end of the Variable value field. Then click OK to accept the change and continue.

;C:\Lotus\Notes;C:\notescpp\lib\mswin32

image

Click OK on the Environment Variables screen.

Click OK on the System Properties screen.

Configure the Lotus Notes Client Application

I confirm that my Domino server is running on another virtual machine. The server name is Litwaredemo/litwareinc  and the IP address is 192.168.1.88. The Lotus Notes ID that I plan to use is a member of the applicable administrators groups on the Domino server.

I click the Windows Start button on my keyboard and then click on the Lotus Notes 8.5 icon on the workspace.

image

The Client Configuration screen appears and I click Next to continue.

image

The Client Configuration screen appears and I enter the details as seen below. I click Next to continue.

image

The Client Configuration screen opens. Click Next to continue.

image

The Domino Server Network Information screen appears. I enter the settings as seen below and click Next to continue.

image

The Notes ID File screen appears. I browse to where my Notes ID is stored and click Next to continue.

image

I click Yes in the IBM Lotus Notes screen that appears. I do want my Notes ID file copied to the data directory.

image

I enter the password in the Lotus Notes password screen and click Log In to continue.

Note: Never create this Notes ID without a password! Anyone with access to the SharePoint server could then gain full access to the databases on the Domino server.

image

The Lotus Notes client successfully connects to the Domino server.

image

The Client Configuration screen appears. I leave the settings as is and click Next to continue.

image

Another prompt appears. I check the checkbox in the bottom of the prompt and click No to continue.

image

The Lotus Notes 8.5 Getting Started workspace appears.

image

I keep the Lotus Notes client running in preparation for the next steps.

Verify Access to the Lotus Domino Database that You Want to Crawl

I click on File \ Open \ Lotus Notes Application on the menu bar.

image

The Open Application screen appears. I select my Domino Server (LITWAREDEMO/litwareinc) in the drop down list and click through the folder structure until I see the database that I am looking for. I select it and click Open.

image

I wait for the Lotus Notes database to open. A Create Cross Certificate prompt appears and I click Yes to accept it.

image

The About Database document document appears in the workspace. I click the small x on the tab to close it.

image

The database opens in the workspace. It is opened to the default view named Threaded.

image

I also see a message in the view. The message indicates that the view is still being updated.

image

Eventually, the view completes updating and displays data.

image

I can test access to more Notes databases if I want to. I close the Lotus Notes client software after I completed testing. I click on the X in top right hand corner.

image

I click Yes to exit from Notes when prompted.

image

Create the Lotus Notes Mappings Database

I created the Mappings database on another virtual machine where I have the Lotus Notes Designer client installed. I opened the Lotus Notes Designer client and created a Notes database and named it “Mappings”. I then created a new form named “Mapping”. I added two fields and some labels as seen below.

image

I did change the Window Title of the form to “Mapping”.

image

I created a view named “Mappings”. The View Selection formula is: SELECT Form="Mapping". I add a column for each field. I sort the first column in ascending order. The view design appears as below:

image

I removed the default view that came with the design. Only the Mappings view appears in the view design list now.

image

Add User Accounts to the Mappings Database

I open the Mappings database in the Lotus Notes client and click on Create \ Mapping.

image

A blank Notes document appears as below:

image

I enter the names as below to create a new mapping.

image

Lotus Notes User ID: LitwareInc\System Administrator
Windows User:

contoso\Admin

I click on the save icon image and then close the document by clicking on File \ Close.

image

The new document appears in the Mappings view.

image

I close the Notes client on my virtual machine. I copy the Mappings database file from my Notes \ data folder to a shared folder. I then copy the file from the shared folder to the lotus \ Domino \ data folder on the Domino server. Not to the Notes client on the SharePoint server!

Restart the Server

I have the Search components installed on my SharePoint 2013 server. I have to restart the server before proceeding with the next steps.

This concludes part 1 of 2 of my blog entries on installing and configuring the Lotus Notes Connector for SharePoint 2013. I hope that you found it helpful. Part 2 will provide the steps to complete everything to the point where you can get search results from your Notes databases. You can read my other blog entries on how I installed and configured my SharePoint 2013 server environment.

Installing and Configuring the Lotus Notes Connector for SharePoint 2013 Server: Part 1 of 2

Installing and Configuring the Lotus Notes Connector for SharePoint 2013 Server: Part 2 of 2

2 thoughts on “Installing and Configuring the Lotus Notes Connector for SharePoint 2013 Server: Part 1 of 2

  1. In the mapping database why is your Lotus Notes User ID “LitwareInc\System Administrator” instead of the standard username structure of “System Administrator/LitwareInc”?

    • That’s a good question. To be honest, I don’t remember why it had to be set like that. Perhaps it was so that the name followed the Windows user account format?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s