How to connect and sync IBM Lotus Notes data with SharePoint?
Now we are ready to connect and sync the table "Companies" in an IBM Lotus
Notes with SharePoint contacts.
Fig.: IBM Lotus Notes table to be
synced with SharePoint
Let's create a new connection in the Layer2 Cloud Connector Connection Manager
Fig.: Create a new connection in
the Layer2 Cloud Connector Connection Manager.
Fig.: Notes to SharePoint or Office 365 connection in the Connection
You should first define and test
the connection carefully and set scheduling later on. Let's start with the Notes
data source by providing the following information:
- Connection Title
- Data Provider: Odbc Data Provider
- Connection String: DNS=SPTest; User ID=myUser;
Please use your ODBC DSN name here. User ID and
Password only if required. You can also directly attach Notes databases without
having a DSN as shown in the screen below.
- Select Statement: "Select * from Companies"
Please use any valid
Notes SQL query statement. It will be passed directly to the ODBC driver.
Fig.: Data source configuration in the Layer2 Cloud Connector Connection
Please verify connection string and display a data preview. Now let's configure
the data destination, SharePoint, Office 365 or any other system like SQL,
Exchange, ERP/CRM e.g. SAP, Dynamics, Navision or others. Note that you have to
create the target list before.
Fig.: Data destination configuration
in the Layer2 Cloud Connector (SharePoint as an example, but can be any)
Please provide the following
- Connection Title: e.g. SharePoint
- Data Provider: Layer2 Data Provider for SharePoint (CSOM)
- Connection String: Depending on Authentication and other properties. See
here for specification.
- Primary Key: Not required, SharePoint Item ID is taken automatically.
- Replication Key: Not used in this case.
- Disable Operations: Not used in this sample but can be helpful, e.g. to
prevent deletes of existing SharePoint items.
Please verify connection string and display a data preview. Now it comes to
field / column mapping between data source and destination.
Fig.: Data source field to target
column mapping. SharePoint contact list columns are used in this sample.
Please verify mapping. If all fits, we are ready for first sync.
Fig.: First data synchronization
from Notes to SharePoint. Two new records are inserted.
Please press "Run Now" for first sync. You data should be inserted. Take care
about possible issues, e.g. data conversion issues and fix it, e.g. in mapping.
Run sync again. There should be no changes in case of an unchanged Notes
database. You Notes data are now synced with SharePoint or Office 365 like this.
Fig.: IBM Notes data in Microsoft SharePoint or Office 365.
You can now go back to the
connection settings and set scheduling as required. E.g. you can sync every 10
minutes, per hour or daily - depending on amount of changes and