Connecting to SharePoint Online via CSOM
To connect to SharePoint Online we are using the Layer2 Data Provider for SharePoint (CSOM). Note that this is
an example only. You can also connect to almost any other corporate data sources
like databases, web services, cloud-or on-premises based systems like SharePoint
(on-premises), Exchange (on-premises and Online), SAP, Salesforce etc.
Fig.: Smaple connection to Office
365 to synchronize Microsoft Access data.
Please select the data provider as
shown above. If it does not appear in the list, please install from the Layer2
Cloud Connector distribution package. The connection string depends on
authentication method. Here you will find more information and detailed specification to connect to
You can connect to an existing SharePoint list or create a new one. In the
case we are using a contact list. It already comes with some appropiate fields.
Additionally it provides some useful built-in features, like offline
synchronization with Microsoft Outlook.
You don't have to take care about primary keys in this case (item IDs are
Please verify all settings and display the data preview (right hand side